Creating a Search Application -

(Page 23 of 29 )

In this function we will do an exact keyword search. This search is relatively straightforward, as it only consists of a single SQL query. Because the number of search terms can change, we need to dynamically create the query. This query will result in URLs being returned along with the number of times those URLs contained the search terms. The results will be ordered from highest to lowest by the number of search term matches.

This function will return the data from the query, or FALSE if there were not any rows in the result set.

<?php function doSearch() {     $match = "keywords.keyword in ('"            . $this-&gt;_searchterms[0] . "'";     for ($i = 1; $i &lt; $this-&gt;_numterms; $i++) {         $match .= ", '" . $this-&gt;_searchterms[$i] . "'";     }     $match .= ")";     $query = "SELECT urls.url, count(*) as counter "            . "FROM urls, keywords "            . "WHERE $match "            . "AND keywords.url_id = urls.id "            . "GROUP BY keywords.url_id "            . "ORDER BY counter DESC";     $result = $this-&gt;_db-&gt;fetch($query);     if (count($result) &gt; 0)         $return = $result;     else         $return = FALSE;     return $return; } ?>

Next: >>
 

More Database Articles Articles
More By Matt Wade

Comments On: Creating a Search Application

·     · I've copy and paste the five files regarded in this tutorial, and created the db,...    · Hello, 'id' INT NOT NULL AUTO_INCREMENT PRIMARY KEY , I'm...    · THANKS - MATTVery clear explained tutorial.Wonderful search, I am...    · My phpadmin had no issues with the table creation, but can't get the harvest script...    · It's an ok search tutorial, but too many errors.[QUOTE]Warning: array_walk()...    · Where to post for help on this tutorial?CheersWest    · great tutorial and very inspiring column in your conclusion.   >>> Post your comment now!