trang index.php
<?php
require 'connect.inc.php' ;
?>
<form action ="index.php" method ="GET">
Choose a food type:
<select name ="uh">
<option value ="u">Unhealthy</option>
<option value ="h" >Healthy</option>
</select><br><br>
<input type ="submit" value ="submit">
</form>
<?php
if (isset($_GET['uh'])&& !empty($_GET['uh'])) {
$uh = strtolower( $_GET['uh']) ;
if ($uh=='u'|| $uh == 'h') {
$query =" SELECT `food`, `calories` FROM `food` WHERE `healthy_unhealthy`='$uh' ORDER BY `id` DESC";
if ($query_run = mysql_query($query)) {
if (mysql_num_rows($query_run) ==NULL) {
echo 'No results found.';
} else {
while ($query_row = mysql_fetch_assoc($query_run)) {
$food = $query_row['food'] ;
$calories = $query_row['calories'];
echo $food . ' has ' . $calories . ' calories.<br> ';
}
}
} else {
echo mysql_error();
}
}
}
?>