I have a table in a mysql database with 5 columns, id, Name, Wifi, Bluetooth, GPS, with rows that are for example 1, Galaxy S2, yes, yes, yes. So basically i want to build a form that has check boxes (3 checkboxes for wifi bluetooth and GPS respectively) that once selected will query the database depending on which check boxes are selected. I have made the form but need to know what to put in the filter.php to make the results be displayed accordingly. Ideally if anyone knows how i would want it so the results were shown on the same page which i believe u need to use ajax to happen but any help on how to show the results will be greatful.
the code for the form i have made is as follows:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>test</title>
</head>
<body>
<form action="filter.php" method="post">
<INPUT TYPE=CHECKBOX NAME="option[]" VALUE="Wifi" id="r1">Wifi
<INPUT TYPE=CHECKBOX NAME="option[]" VALUE="Bluetooth" id="b1">Bluetooth
<INPUT TYPE=CHECKBOX NAME="option[]" VALUE="GPS" id="g1">GPS
<input type="submit" name="formSubmit" value="Submit" />
</form>
</body>
</html>
im not sure on how to make the filter.php page but i do have this code for displaying the all the data but i want to kno how to make it only display the data from the choices on the checkboxes
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>pls work</title>
</head>
<body>
<?php
function h($s) {
echo htmlspecialchars($s);
}
mysql_connect("localhost", "root", "") or die (mysql_error());
mysql_select_db("project") or die (mysql_error());
$result= mysql_query('SELECT * FROM test') or die('Error, query failed');
?>
<?php if (mysql_num_rows($result)==0) { ?>
Database is empty <br/>
<?php } else { ?>
<table>
<tr>
<th></th>
<th>Name</th>
<th>Wifi</th>
<th>Bluetooth</th>
<th>GPS</th>
</tr>
<?php while ($row= mysql_fetch_assoc($result)) { ?>
<tr>
<td>
<a href="uploaded-images/<?php h($row['Name']); ?>.jpg">
<img src="uploaded-images/<?php h($row['Name']); ?>.jpg" alt="test"/>
</a>
</td>
<td><a href="textonly.html"><?php h($row['Name']); ?></a></td>
<td><?php h($row['Wifi']); ?></td>
<td><?php h($row['Bluetooth']); ?></td>
<td><?php h($row['GPS']); ?></td>
</tr>
<?php } ?>
</table>
<?php } ?>
</body>
</html>