<?php
if ($s) {
require("config.php");
$search = $s . '%';
$result = mysql_query ("SELECT * FROM memorial WHERE fname LIKE '$search' ");
if ($row = mysql_fetch_array($result)) {
printf ("<center>");
printf (" Search Results for: %s ", $search);
printf ("<br>");
printf ("<br>");
printf ("</center>");
do {
printf ("<body bgcolor=#FFFFFF>");
printf ("<center>");
printf("<a href=\"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $row["id"], $row["fname"], $row["lname"]);
printf ("</center>");
} while($row = mysql_fetch_array($result));
} else {print "<br><br><center><b> Sorry, no records were found! </b></center>";}
} else { ?>
<form method=post action="test1.php?s=<?php echo $fsearch; ?>">
<p>First Name:
<input type="text" name="fsearch" Value="<?php echo $fsearch ?>">
</p>
<p>Last Name:
<input type="text" name="lsearch" Value="<?php echo $lsearch ?>">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
<?php } ?>
<?php
require("config.php");
// display individual record
if ($id) {
$result = mysql_query("SELECT * FROM memorial WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
printf("First name: %s\n<br>", $myrow["fname"]);
printf("Last name: %s\n<br>", $myrow["lname"]);
printf("Date of Birth: %s\n<br>", $myrow["dob"]);
printf("Date of Death: %s\n<br>", $myrow["dod"]);
printf("Biography: %s\n<br>", $myrow["bio"]);
printf("MemPicID: %s\n<br>", $myrow["mempicid"]);
include("test.php");
} else {
// show memorial list
$result = mysql_query("SELECT * FROM memorial",$db);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are records to display
do {
printf("<a href=\"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["id"], $myrow["fname"], $myrow["lname"]);
} while ($myrow = mysql_fetch_array($result));
} else {
// no records to display
echo "Sorry, no records were found!";
}
}
?>
