Olive Branch MS Chamber of Commerce (circa Oct 1999)
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
This repo is archived. You can view files and clone it, but cannot push or open issues/pull-requests.

64 lines
2.4 KiB

  1. <html>
  2. <head>
  3. <title>Olive Branch, MS</title>
  4. <base target="section_body">
  5. <link rel=stylesheet href=/styles/basic.css type=text/css>
  6. </head>
  7. <body>
  8. <form method="post" action="bsearchbody.php3">
  9. <?
  10. // connect to the database
  11. $connection = pg_connect("localhost", "5432", "olivebranch");
  12. if($connection)
  13. {
  14. $query = "SELECT distinct category FROM member";
  15. $result = pg_exec($connection, $query);
  16. if($result)
  17. {
  18. print("Category:<br><select name=\"category\">\n");
  19. print("<option value=\"\">--- All Categories ---\n");
  20. for($row = 0; $row < pg_NumRows($result); $row++)
  21. {
  22. print("<option value=\"" . pg_result($result, $row, 0) . "\">");
  23. print(pg_result($result, $row, 0));
  24. print("\n");
  25. }
  26. pg_freeresult($result);
  27. }
  28. print("</select><br>\n");
  29. pg_close($connection);
  30. }
  31. print("<input type=\"hidden\" name=\"begin\" value=\"0\">\n");
  32. print("<input type=\"hidden\" name=\"page\" value=\"0\">\n");
  33. print("<table border=0 cellpadding=0 cellspacing=0>");
  34. print("<tr><td colspan=2 align=left>Company Name:</td></tr>");
  35. print("<tr><td colspan=2><input type=\"text\" name=\"wordsearch\" maxlength=32 size=17><br>\n</td></tr>");
  36. print("<tr><td align=left><input type=\"radio\" name=\"wordoption\" value=\"start\">Starts with</td>");
  37. print("<td align=right><input type=\"radio\" name=\"wordoption\" value=\"end\">Ends with</td></tr>");
  38. print("<tr><td colspan=2 align=center><input type=\"radio\" checked name=\"wordoption\" value=\"contain\">Contains<br></td></tr>");
  39. print("</table>");
  40. print("<table border=0>");
  41. print("<tr><td colspan=2 align=left>Contact Name:</td></tr>");
  42. print("<tr><td colspan=2><input type=\"text\" name=\"contactsearch\" maxlength=32 size=17><br>\n</td></tr>");
  43. print("<tr><td align=left><input type=\"radio\" name=\"contactoption\" value=\"start\">Starts with</td>");
  44. print("<td align=right><input type=\"radio\" name=\"contactoption\" value=\"end\">Ends with</td></tr>");
  45. print("<tr><td colspan=2 align=center><input type=\"radio\" checked name=\"contactoption\" value=\"contain\">Contains<br></td></tr>");
  46. print("</table>");
  47. print("<table border=0>");
  48. print("<tr><td colspan=2 align=left>Results per Page:</td></tr>");
  49. print("<tr><td colspan=2><input type=\"text\" value = \"5\"name=\"linesperpage\" maxlength=32 size=17><br>\n</td></tr>");
  50. print("</table>");
  51. ?>
  52. <input type="submit">
  53. </p>
  54. </form>
  55. </body>
  56. </html>