/
search_result_by_food_name.php
65 lines (56 loc) · 1.76 KB
/
search_result_by_food_name.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
<?php
include ('food_galaxy_fns.php');
$search_key = $_GET['search_key'];
do_html_header("Search Results: ".$search_key);
display_search_result_by_name($search_key);
session_start();
$name = $_SESSION['name'];
write_log($name." did a search");
do_html_footer();
?>
<?php
function display_search_result_by_name($search_key) {
// query database for the books in a category
if ((!$search_key) || ($search_key == '')) {
return false;
}
$conn = db_connect();
$query = "select * from food;";
$result = @$conn->query($query);
if (!$result){
echo "Error: Can't execute query about food";
return false;
}
$num = @$result->num_rows;
if($num == 0){
return false;
}
$is_search_mached = false;
while($row = $result->fetch_assoc()){
if(strpos($row['name'], $search_key) !== false){
echo "<div class=\"col-xs-12 col-sm-6 col-md-4\">
<div class=\"thumbnail\">
<a href=\"food_details.php?food_id=".$row['food_id']."\"><img src=\"img/".$row['food_id'].".jpg\" alt=\"...\"></a>
<div class=\"caption\">
<h3><b>Name: </b>".$row['name']."</h3>
<p><b>Description: </b>".$row['description']."</p>
<p>
<a href=\"food_details.php?food_id=".$row['food_id']."\" class=\"btn btn-primary\" role=\"button\">View Details</a>
</p>
</div>
</div>
</div>";
$is_search_mached = true;
}
}
if(!$is_search_mached){
echo '<div class="form-group" id="success_message">
<div class="col-sm-offset-2 col-sm-8">
<div class="alert alert-danger">
<h3> No results!</h3>
</div>
</div>
</div>';
}
}
?>