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%' ";

[Back to original message]