DB Items Search

<?
/*
 Kevin Clevenger, 1999-05-23
 This is just a quick and dirty script for pulling catalog items
 from a MySQL database. This script supports the use of 'And' or 'Or' 
 or 'Not' between keywords. 
 Config.inc consists of
 $dbname   = "db_name";
 $dbserver  = "localhost";
 $dbuser   = "uid";
 $dbpass   = "password"; 
 If you make improvements to this script please mail a copy to 
 [email protected]
*/
<table border=0 cellpadding=4 align=center width=90%>
<tr><td colspan=2 align=center><font size="6">Search</font></td></tr> 
<? 
 if ($search) {
  echo "<tr><td colspan=2 align=center>Search for: $search</td></tr><tr colspan=2><td></td></tr>";
  include("config.inc");
  $arrSearch = explode(" ", $search);
  for ($i=0; $i<count($arrSearch); $i++) {
   if (strToUpper($arrSearch[$i])=='AND' or strToUpper($arrSearch[$i])=='OR' or strToUpper($arrSearch[$i])=='NOT') {
    if (strToUpper($arrSearch[$i])=='NOT') {
     $i++;
     $strWhere = $strWhere." and descr not like '%".$arrSearch[$i]."%'";
	} else {
     $strWhere = $strWhere." ".$arrSearch[$i]." ";
	}
   } else {
    $strWhere = $strWhere."descr like '%".$arrSearch[$i]."%'";
   }
  }
  $cn=mysql_connect($dbserver, $dbuser, $dbpass);
  mysql_select_db($dbname,$cn);
  $sql="SELECT * FROM items WHERE ".$strWhere." ORDER BY name";
  $rsCat_query=mysql_query($sql, $cn);
  if (!(mysql_errno()==0)) {
   echo "<tr><td colspan=2 align=center><big>There was a problem with the query syntax</big></td></tr>";
   echo "<tr><td colspan=2 align=center><a href=search.php3>Back</a></td></tr></table>";
   exit;
  }
  if (mysql_num_rows($rsCat_query)==0) {
   echo "<tr><td colspan=2 align=center><big>No items were found matching the criteria</big></td></tr>";
   echo "<tr><td colspan=2 align=center><a href=search.php3>Back</a></td></tr></table>";
   exit;
  }
  while($rsCat = mysql_fetch_array($rsCat_query)) {
?>
  <tr><td>Iterate through your fields here</td></tr>
  <tr><td>Field_1 Value:</td><td><? echo $rsCat["field1_name"] ?></td></tr>
  <tr><td>Field_2 Value:</td><td><? echo $rsCat["field2_name"] ?></td></tr>
  <tr><td>Field_3 Value:</td><td><? echo $rsCat["field3_name"] ?></td></tr>
<? 
 }
} else {
?>
<form action=search.php3 method=post>
<tr><td align=center colspan=2>&nbsp;&nbsp;<input type=text name=search id=search size=25>
 <input type=submit name=submit value=Submit></td></tr>
<tr><td colspan=2 align=center>Enter the criteria you wish to search for. The search is not case sensitive.</td></tr>
<tr><td colspan=2 align=center>You may use 'And' or 'Or' or 'Not' between keywords.</td></tr>
<tr><td align=right width=100>Example 1:</td><td>this and that</td></tr>
<tr><td align=right>Example 2:</td><td>this not that</td></tr>
<tr><td align=right>Example 3:</td><td>this and that not those</td></tr>
<tr><td align=right>Example 4:</td><td>this and that or those</td></tr>
</form>
<? } ?>
</table>

Upload