Search with more than one keywords

Anon

Dear all,

We know that a keyword is searched by using

$sql="select * from table1 where content LIKE '%$keyword%'";

If we want to search more than one keywords but the number of keywords we search is unknown, then how do we write the SQL tag conveniently given that we add some connective word such as "and", "or" in between?

Thanks
Simon

thefury

you try this..
$sql="select * from table1 where content LIKE '%$keyword%' OR LIKE '%$keyword2%'";

Anon

Dear Jordan,

Thanks for your reply, however, your solution is not my expected. This is because, the client enters his keyword in a box and it may contain more than one keywords with connective words "and", "or" and so forth in between and the no. of keywords is unknown.

Regards,
Simon.

Jordan wrote:

you try this..
$sql="select * from table1 where content LIKE '%$keyword%' OR LIKE '%$keyword2%'";

Anon

I do not have the benefit of a PHP server to test this...

You need to parse the keywords and build the appropriate WHERE clause...

// Assuming the user must separate keywords with a valid boolean keyword...
$arg = "dog or cat and bird or canary and snake";
$words = explode(" ",$arg);
$sql="select * from table1 where content ";

// Now, you've got all the bools in the odd array elements (you should validate them too; I didn't here)...
$x=0;$y = count($words);
while (1==1) {
if ($x == $y) {break;}
$sql .= "LIKE '%$words[$x]%' ";
$x++;
$sql .= $words[$x] . " ";
$x++;
}

Anon

oops. Move this check down. Remember the last array element will be snake in the example above--no final bool is required... So move this if ($x == $y) {break;} after the first $x++...