Help on search function
Posted: Tue Jan 10, 2006 1:39 am
hi all,
I had get a search function from a reference book, but it doesn't work and display all the selected results when the page is loaded. I want it to only display the result when the search button is clicked. the commented code is the original code from the book.
hope someone can help me on this, thks in advance
I had get a search function from a reference book, but it doesn't work and display all the selected results when the page is loaded. I want it to only display the result when the search button is clicked. the commented code is the original code from the book.
Code: Select all
//if($submit)
//{
//add
print ("<form action=\"./search3.php\" method=\"get\">\n");
print ("<table width=\"525\" cellspacing=\"1\" cellpadding=\"3\" border=\"0\" bgcolor=\"#123456\">\n");
print ("<tr>\n");
print ("<td colspan=\"2\" bgcolor=\"#DFFFDF\"><b>Search your address book...</b></td>\n");
print ("</tr>\n");
print ("<tr>\n");
print ("<td colspan=\"2\" bgcolor=\"#ffffff\">\n");
print ("<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n");
print ("<tr>\n");
print ("<td> First Name</td>\n");
print ("<td>Last Name</td>\n");
print ("</tr>\n");
print ("<tr>\n");
print ("<td> <input type=\"text\" name=\"display_name\" size=\"20\" maxsize=\"20\"></td>\n");
print ("<td><input type=\"text\" name=\"lastName\" size=\"30\" maxsize=\"30\"></td>\n");
print ("</tr>\n");
print ("</table>\n");
print ("</td>");
print ("</tr>");
print ("<tr>\n");
print ("<td colspan=\"2\" align=\"right\" bgcolor=\"#DFFFDF\">\n");
print ("<input type=\"hidden\" name=\"tab\" value=\"?\">");
print ("<input type=\"submit\" name=\"submit\" value=\"Search\"> ");
print ("</td>\n");
print ("</tr>\n");
print ("</table>\n");
print ("</form>\n");
//add
$query = "select display_name, mobile_numb, level, class from address_book " .
"where display_name like '{$display_name}%'";
$query .= " order by display_name";
$pg_result = pg_query($dbconn, $query);
echo($pg_query);
print ("<table width=\"525\" cellspacing=\"1\" cellpadding=\"3\" border=\"0\" bgcolor=\"#123456\">");
print ("<tr>");
print ("<td bgcolor=\"#dfdfdf\"><b>Name</b></td>");
print ("<td bgcolor=\"#dfdfdf\"><b>Phone</b></td>");
print ("<td bgcolor=\"#dfdfdf\"><b>E-Mail</b></td>");
print ("</tr>");
while($row = pg_fetch_row($pg_result))
{
echo "ha";
if(($row[4] == 1) or ($row[4] == ""))
{
$primaryPhone = $row[10];
$primaryEmail = $row[13];
}
if($row[4] == 2)
{
$primaryPhone = $row[20];
$primaryEmail = $row[23];
}
print("<tr>\n");
printf("<td bgcolor=\"#ffffff\"> <a href=\"./search3.php?contactID=%s\">%s, %s</a></td>\n", $rowcolor, $row[0], $row[1], $row[2]);
printf("<td bgcolor=\"#ffffff\"> <a href=\"./search3.php?contactID=%s\">%s</a></td>\n", $rowcolor, $row[0], $primaryPhone);
printf("<td bgcolor=\"#ffffff\"> <a href=\"./search3.php?contactID=%s\">%s</a></td>\n", $rowcolor, $row[0], $primaryEmail);
print("</tr>\n");
}
print ("<tr>");
print ("<th bgcolor=\"#dfdfdf\"> </th>");
print ("<th bgcolor=\"#dfdfdf\"> </th>");
print ("<th bgcolor=\"#dfdfdf\"> </th>");
print ("</tr>");
print ("<tr>\n");
print ("<td colspan=\"3\" align=\"right\" bgcolor=\"#DFFFDF\">\n");
print ("<a href=\"./search3.php?tab=?\">Search Again</a>.");
print ("</td>\n");
print ("</tr>\n");
print ("</table>");
//}
//else
//{
//echo "aa";
//print ("<form action=\"./search3.php\" method=\"get\">\n");
//print ("<table width=\"525\" cellspacing=\"1\" cellpadding=\"3\" border=\"0\" bgcolor=\"#123456\">\n");
//print ("<tr>\n");
//print ("<td colspan=\"2\" bgcolor=\"#DFFFDF\"><b>Search your address book...</b></td>\n");
//print ("</tr>\n");
//print ("<tr>\n");
//print ("<td colspan=\"2\" bgcolor=\"#ffffff\">\n");
//print ("<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n");
//print ("<tr>\n");
//print ("<td> First Name</td>\n");
//print ("<td>Last Name</td>\n");
//print ("</tr>\n");
//print ("<tr>\n");
//print ("<td> <input type=\"text\" name=\"display_name\" size=\"20\" maxsize=\"20\"></td>\n");
//print ("<td><input type=\"text\" name=\"lastName\" size=\"30\" maxsize=\"30\"></td>\n");
//print ("</tr>\n");
//print ("</table>\n");
//print ("</td>");
//print ("</tr>");
//print ("<tr>\n");
//print ("<td colspan=\"2\" align=\"right\" bgcolor=\"#DFFFDF\">\n");
//print ("<input type=\"hidden\" name=\"tab\" value=\"?\">");
//print ("<input type=\"submit\" name=\"submit\" value=\"Search\"> ");
//print ("</td>\n");
//print ("</tr>\n");
//print ("</table>\n");
//print ("</form>\n");
//}
?>