How to make a php form that queries a database based on check box options?

[masterk123]

Hi im new to php and I need help making webpage that queries a mysql database based on a 3 check boxes and displays results on the same page or on another page. The table being queried has 4 columns, name, gps, wifi, bluetooth. So for example a row in the table would be like, samsung galaxy s2, yes, yes, yes. The idea is for it to be a website that will display phones according to their features.

 

So the idea is depending on if the boxes were ticked the samsung galaxy would be displayed as a result. So i need some help understanding how to make this.

 

Some1 gave me the code below in attempt to help me (im not sure it works or not) but im not sure how fully use it, ie what pages i need to make and how i create the connection to the mysql database, and how to use the query that they wrote to display the results

 

thanks

 

code:

<form action="?do=filter" method="post">
<table cellspacing="0" cellpadding="3" border="1">
<tr>
<td>GPS<input type="checkbox" name="gps" value="checked"></td>
<td>Wifi<input type="checkbox" name="wifi" value="checked"></td>
<td>Bluetooth<input type="checkbox" name="bluetooth" value="checked"></td>
</tr>
<tr><td><input type='submit' name='filter' value='Filter'></td></tr>
</table>
</form>
</html>
<?php
function filterMe($filter){
if(isset($_POST[$filter])){
return "Yes";
}else{
return "No";
}
}

if(isset($_POST['filter'])){
echo "Gps - " . filterMe('gps');
echo "
Wifi - " . filterMe('wifi');
echo "
Bluetooth - " . filterMe('bluetooth');
}
?>


All you need to do is use a query something like 
SELECT name,gps,wifi,bluetooth FROM `product` WHERE `gps`='".filterMe('gps')."' AND `wifi`='".filterMe('wifi')."' AND `bluetooth`='".filterMe('bluetooth')."'

[Barand]

This http://www.phpfreaks.com/forums/index.php?topic=138921.msg589650#msg589650 may help