[thelist] GET POST Form PHP

Kae Verens kverens at contactjuggling.org
Mon Feb 24 05:51:01 CST 2003

Andrew Maynes wrote:
> PHP guys and dolls
> Could someone clarify my muddy thoughts regarding using a form to search a MySQL
> DB with php?
> I am need to either post or get a query and wondered if any of you can tell me
> what the best way to proceed is?
> Andrew

A simple search form might be simply this:
<form action="search.php">
  <label>Search Term: <input type="text" name="s" /></label><br />
  <input type="submit" value="Search" />

This would send the search term to search.php, which may contain
something like this:
$q=mysql_query('select id,name from searchtable where desc like
"%'.$s.'%" or name like "%'.$s.'%" limit 0,20');
  ?>Items matching your search:<ul><?
  ?><em>No matches for that search</em><?

Assumes you are searching a table called "searchtable", which contains
fields called id, name, and desc.

Kae Verens               _______\_   webworks.ie
work: www.webworks.ie       _____\\__   webhosts
play: www.contactjuggling.org  ___\\\___  design
kae:  kverens.contactjuggling.org _\\\\____ code

More information about the thelist mailing list