multiple search

[migi48]

Hi! I'm trying to do a multiple search in my php code. I have an input text field where I input my wanted values then when I click the search button, An html table would show all my searched values from my database table.

For example, I want to search multiple names(mark, jake, john, michael) <-- this is typed in a single text field separated by commas.

Then it will go to another page which will show all records from my database having a name of "mark", "jake", "john", or "michael".


This is my initial code (page afrer clicking the search button) result.php:

$search = $_POST["search"];
$array_search = explode(',', $search);
$imploded_search = implode(",", $array_search);
 
$query = mysql_query("SELECT * FROM users WHERE name IN($imploded_search)");
 
while ($row = mysql_fetch_array($query)) 
{
    echo $row['name'];
}
 

Nothing seems to display :(
When I added '' in $imploded_search in

$query = mysql_query("SELECT * FROM users WHERE name IN('$imploded_search')"); 

It only searches for ONE name which is the first name I have inputted. ("mark")

I believe that $imploded_search creates one string 'mark, jake, john, michael' =

$query = mysql_query("SELECT * FROM users WHERE name IN('mark, jake, john, michael')"); 

and it needs to become 'mark', 'jake', 'john', 'michael' in order for it to work.

$query = mysql_query("SELECT * FROM users WHERE name IN('mark', 'jake', 'john', 'michael')"); 

I need help on how to do this.
THANK YOU VERY MUCH in advance!

[Dormilich]

as you have already found out, you need to enclose each element of the array by quotes. why not using implode() for that (as implode() also adds the commas)?

besides the fact that you’re wide open to SQL Injection ...

[roshan ban]

Create a simple array that can store a search word in array after parsing the special seperator that you have place like (, or ; etc)
then make a search in a loop one after another simultaneously

[migi48]

Hello guys thanks for the replies,

@Dormilich - That's what I'm actually trying to do. But unfortunately, I cannot figure out how can I enclose each element of the array by quotes using implode. Please teach me how to do that. Sorry for being new to PHP functions.

@roshan ban - Are you suggesting to make a loop of SQL querries? I believe that it would only make the system slower?

[deric]

Try this:

$array_search = explode(',', $search);
$imploded_search = "'".implode("','", $array_search)."'";