Creating hyperlinks from MySQL dB
Posted: Wed May 14, 2008 5:56 am
One last question I'm hoping somebody can help with.
This is my PHP code for my "results" page:
What I want to do is insert hyperlinks for various ancestors.
Take a look at http://www.didymus.org.uk/display.php?urn=583
Let's take Edwin's mother as an example.
There are two columns for her in my MySQL database. One is $mother which gives her full name and the other is $motherurn which stores her Unique Reference Number (URN).
I want the results page to show her name as a hyperlink. When the user clicks on it, they're taken to http://www.didymus.org.uk/display.php?urn= (plus the reference number stored in $motherurn).
Thing is, I don't know how to do this. I want to do it this way to avoid having to produce a separate PHP page for EACH ancestor.
HAYLP! PLEASE!
Kris.
This is my PHP code for my "results" page:
Code: Select all
<?php
/* Program: display.php
* Desc: Displays all details of selected individual.
*/
?>
<html>
<head><title>Results</title></head>
<body>
<?php
include_once("*******.inc");
$cxn = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
mysql_select_db($database);
$urn=$_GET['urn']; //urn passed by hyperlink
$query = "SELECT * FROM tree WHERE urn='$urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
/* Display results in a table */
$urn = ucfirst($urn);
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<font face='Arial' size='3'><b>$surname, $forename $middlenames</font></b>";
echo "<table cellspacing='0'>";
echo "<tr><td colspan='3'><hr /></td></tr>";
echo " <tr>\n
<td valign='top'><font face='Arial' size='1'><b>URN:</font></b></td><td valign='top'><font face='Arial' size='1'>$urn</font></td>\n
<tr bgcolor='#CCFFCC' valign='top'><td><font face='Arial' size='1'><b>SURNAME:</font></b></td><td valign='top'><font face='Arial' size='1'>$surname</font></td>\n</tr>
<tr valign='top'><td><font face='Arial' size='1'><b>FORENAME(S):</font></b></td><td><font face='Arial' size='1'>$forename $middlenames</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td><font face='Arial' size='1'><b>DATE OF BIRTH:</font></b></td><td><font face='Arial' size='1'>$dateofbirth</font></td>\n</tr>
<tr valign='top'><td><font face='Arial' size='1'><b>PLACE OF BIRTH:</font></b></td><td><font face='Arial' size='1'>$placeofbirth</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td><font face='Arial' size='1'><b>MOTHER:</font></b></td><td><font face='Arial' size='1'>$mother</font></td>\n</tr>
<tr valign='top'><td><font face='Arial' size='1'><b>FATHER:</font></b></td><td><font face='Arial' size='1'>$father</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td><font face='Arial' size='1'><b>SIBLINGS:</font></b></td><td><font face='Arial' size='1'>$sibling1</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$sibling2</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$sibling3</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$sibling4</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$sibling5</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$sibling6</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$sibling7</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$sibling8</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1' bgcolor='#CCFFCC'>$sibling9</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$sibling10</font></td>\n</tr>
<tr valign='top'><td><font face='Arial' size='1'><b>CHRISTENING DATE:</font></b></td><td><font face='Arial' size='1'>$christeningdate</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td><font face='Arial' size='1'><b>CHRISTENING PLACE:</font></b></td><td><font face='Arial' size='1'>$christeningplace</font></td>\n</tr>
<tr valign='top'><td><font face='Arial' size='1'><b>SPOUSE 1:</font></b></td><td><font face='Arial' size='1'>$spouse1</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td><font face='Arial' size='1'><b>MARRIAGE DATE:</font></b></td><td><font face='Arial' size='1'>$spouse1marriagedate</font></td>\n</tr>
<tr valign='top'><td><font face='Arial' size='1'><b>MARRIAGE PLACE:</font></b></td><td><font face='Arial' size='1'>$spouse1marriageplace</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td><font face='Arial' size='1'><b>CHILDREN:</font></b></td><td><font face='Arial' size='1'>$spouse1child1</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1' bgcolor='#CCFFCC'>$spouse1child2</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1' bgcolor='#CCFFCC'>$spouse1child3</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse1child4</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse1child5</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse1child6</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse1child7</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse1child8</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse1child9</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse1child10</td>\n</tr>
<tr valign='top'><td><font face='Arial' size='1'><b>SPOUSE 2:</font></b></td><td><font face='Arial' size='1'>$spouse2</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td><font face='Arial' size='1'><b>MARRIAGE DATE:</font></b></td><td><font face='Arial' size='1'>$spouse2marriagedate</font></td>\n</tr>
<tr valign='top'><td><font face='Arial' size='1'><b>MARRIAGE PLACE:</font></b></td><td><font face='Arial' size='1'>$spouse2marriageplace</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td><font face='Arial' size='1'><b>CHILDREN:</font></b></td><td><font face='Arial' size='1'>$spouse2child1</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse2child2</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse2child3</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse2child4</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse2child5</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse2child6</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse2child7</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse2child8</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse2child9</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td></td><td><font face='Arial' size='1'>$spouse2child10</td>\n</tr>
<tr valign='top'><td><font face='Arial' size='1'><b>OCCUPATION:</font></b></td><td><font face='Arial' size='1'>$occupation</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td><font face='Arial' size='1'><b>DATE OF DEATH:</font></b></td><td><font face='Arial' size='1'>$dateofdeath</font></td>\n</tr>
<tr valign='top'><td><font face='Arial' size='1'><b>PLACE OF DEATH:</font></b></td><td><font face='Arial' size='1'>$placeofdeath</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td><font face='Arial' size='1'><b>CAUSE OF DEATH:</font></b></td><td><font face='Arial' size='1'>$causeofdeath</font></td>\n</tr>
<tr valign='top'><td><font face='Arial' size='1'><b>NOTES:</font></b></td><td><font face='Arial' size='1'>$notes</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td><font face='Arial' size='1'><b>CERTIFICATES:</font></b></td><td><font face='Arial' size='1'>$certificates</font></td>\n</tr>
<tr valign='top'><td><font face='Arial' size='1'><b>CENSUS:</font></b></td><td><font face='Arial' size='1'>$census</font></td>\n</tr>
<tr bgcolor='#CCFFCC' valign='top'><td><font face='Arial' size='1'><b>PHOTOGRAPHS:</font></b></td><td><font face='Arial' size='1'>$photographs</font></td>\n</tr>
<tr valign='top'><td><font face='Arial' size='1'><b>SCRAPBOOK:</font></b></td><td><font face='Arial' size='1'>$scrapbook</font></td>\n</tr>
</tr>\n";
echo "<tr><td colspan='3'><hr /></td></tr>\n";
}
echo "</table>\n";
?>
</body></html>Take a look at http://www.didymus.org.uk/display.php?urn=583
Let's take Edwin's mother as an example.
There are two columns for her in my MySQL database. One is $mother which gives her full name and the other is $motherurn which stores her Unique Reference Number (URN).
I want the results page to show her name as a hyperlink. When the user clicks on it, they're taken to http://www.didymus.org.uk/display.php?urn= (plus the reference number stored in $motherurn).
Thing is, I don't know how to do this. I want to do it this way to avoid having to produce a separate PHP page for EACH ancestor.
HAYLP! PLEASE!
Kris.