|
|
Posted by "Richard Lynch" on 05/22/05 08:27
On Sat, May 21, 2005 1:35 pm, virtualsoftware@gmail.com said:
> I need to build up a search module for a shop. If I make a basic search
> (product title for example) it is ok.
>
> $query = "SELECT product_id FROM products WHERE title LIKE '%$title%'";
>
> But i need an advance search for more than one field (title, description,
> price, weight)
> The problem is that i don't know which field is filled in by the user
> (title, description, price or weight)
> I mean, the user can fill in all fields, or only price field, or title and
> weight etc
You can use http://php.net/strlen to determine if the user has typed
anything into any given INPUT.
Or, if you want a "simple" search with only one INPUT, something like:
$query = "select product_id from products where 1 = 0 ";
$words = explode(' ', $input);
while (list(, $word) = each($words)){
$query .= " or title like '%$word%' ";
$query .= " or description like '%$word%' ";
Navigation:
[Reply to this message]
|