如何基于多个复选框进行搜索

Question

I have a form with checkbox based on which I want to made a search in sql table.

<input name="pc[]" type="checkbox" value="1">I  &nbsp &nbsp &nbsp   
<input name="pc[]" type="checkbox" value="2">II  &nbsp &nbsp &nbsp   
<input name="pc[]" type="checkbox" value="3">III

If checkbox 1 is ticked then the query should be like this

$result=$mysql_query="SELECT * FROM students1 WHERE PartCode IN ('1') "; 

If checkbox 1 and 2 are ticked then the query should be like this

$result=$mysql_query="SELECT * FROM students1 WHERE PartCode IN ('1', '2') "; 

etc.

For that purpose I wrote the following code. But its not working.

$ad = implode ("','",$_POST['pc']); 
$result=mysql_query("SELECT * FROM students1 WHERE PartCode IN ('$ad') "); 

how to edit the code?

Answer 1

Remove the quotes for $ad from the query. Also your implode is not enclosing the values within quotes. So try with the following code:

$ad  = "'" .implode("', '", $_POST['pc']) . "'";   // outputs '1', '2' etc
$result=mysql_query("SELECT * FROM students1 WHERE PartCode IN ($ad) ");