RE: [PHP] How to search products on my site
| From: | Jim Moseby | Date: | Tue, 09 Aug 2005 12:37:08 +0000 |
| Subject: | RE: [PHP] How to search products on my site | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-220284@lists.php.net to get a copy of this message | ||
>
> I have a site with some phone products. I want to search for
> a specific products. I use this:
>
> SELECT product_id, product_name FROM products WHERE
> product_name LIKE '%$search_string%'
>
> It works fine if the search string counts 1 word. But if the
> search string id counts 2 or 3 or more words it's not
> working.. How can i do this kind of search. I do not want a
> boolean search or a fulltext search.
If you have decided to abandon MySQL's search functions, you will probably
need to do something like this:
$searchtype = "OR"; // Ask the user for preference 'AND' or 'OR'
$pieces=explode(' ',$searchstring);
$sql="select * from inventory where ";
foreach($pieces as $thispiece){
$sql .= "description like '%".$thispiece."%' ".$searchtype;
}
...to build a query string. Of course you will probably want to look at the
search terms for unnecessary words and definately protect yourself from SQL
injection, but this is the general idea.
>
> Thabks for any help!
Thabk you for askibg! ;-)
JM