editing the simple search tutorial found here on phpfreaks

[barrowvian]

Hi, Ive been playing around with the simple search tutorial that is provided here on php freaks but have a question or two about how to change it. So far I have it edited for my own requirements;

<?php
// Set up our error check and result check array
$error = array();
$results = array();

// First check if a form was submitted. 
// Since this is a search we will use $_GET
if (isset($_GET['search'])) {
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms); // remove any html/javascript.
   
   if (strlen($searchTerms) < 3) {
      $error[] = "Search terms must be longer than 3 characters.";
   }else {
      $searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
   }
   
   // If there are no errors, lets get the search going.
   if (count($error) < 1) {
      $searchSQL = "SELECT * FROM adverts WHERE ";
      
      // grab the search types.
      $types = array();
      $types[] = isset($_GET['cname'])?"`company_name` LIKE '%{$searchTermDB}%'":'';
      $types[] = isset($_GET['desc'])?"`search_data` LIKE '%{$searchTermDB}%'":'';
      
      $types = array_filter($types, "removeEmpty"); // removes any item that was empty (not checked)
      
      if (count($types) < 1)
         $types[] = "`search_data` LIKE '%{$searchTermDB}%'"; // use the search data as a default search if none are checked
      
          $andOr = isset($_GET['matchall'])?'AND':'OR';
      $searchSQL .= implode(" {$andOr} ", $types) . " ORDER BY `company_name`"; // order by title.

      $searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
      
      if (mysql_num_rows($searchResult) < 1) {
         $error[] = "The search term provided {$searchTerms} yielded no results.";
      }else {
         $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$i}: {$row['company_name']}<br />{$row['search_data']}<br /><br />";
            $i++;
         }
      }
   }
}

function removeEmpty($var) {
   return (!empty($var)); 
}
?>


   <style type="text/css">
      #error {
         color: red;
      }
   </style>

      <?php echo (count($error) > 0)?"The following had errors:<br /><span id=\"error\">" . implode("<br />", $error) . "</span><br /><br />":""; ?>
      <form method="GET" action="<?php echo $_SERVER['PHP_SELF'];?>" name="searchForm">
         Search For: <input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" /><br />
         Search In:<br />
         Company Name: <input type="checkbox" name="cname" value="on" <?php echo isset($_GET['cname'])?"checked":''; ?> /> | 
         Description: <input type="checkbox" name="desc" value="on" <?php echo isset($_GET['desc'])?"checked":''; ?> /><br />
                 Match All Selected Fields? <input type="checkbox" name="matchall" value="on" <?php echo isset($_GET['matchall'])?"checked":''; ?><br /><br />
         <input type="submit" name="submit" value="Search!" />
      </form>
      <?php echo (count($results) > 0)?"Your search term: {$searchTerms} returned:<br /><br />" . implode("", $results):""; ?>

 

However, Im wanting to adjust it so that if a user searches using multiple keywords then it can identify that there is more than one. So far, if a user searches clothes and clothing then it will give me the results, as both of these keywords are located within the same row of data. But if the user searched for example clothes and mcdonalds then it just gives an errror message rather than finding all of the rows with clothes and mcdonalds in them. Also, is there any way to order the results by relevance? thanks

 

[barrowvian]

anyone?