forked from BlackX-Studio/Food-Order-CMS
-
Notifications
You must be signed in to change notification settings - Fork 4
/
category-foods.php
108 lines (94 loc) · 4.14 KB
/
category-foods.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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
<?php
include('partials-front/menu.php');
?>
<?php
//check whether clicked or not in home page
if (isset($_GET['category_id'])) {
//get the cat title based on cat id
$category_id = $_GET['category_id'];
//create query to get cat title
$sql = "SELECT title FROM tbl_category WHERE id=$category_id";
//execute the query
$res = mysqli_query($conn,$sql);
//Get the value from database
$row = mysqli_fetch_assoc($res);
//get the title
$category_title = $row['title'];
}else{
//redirct to the homepage
header('location:'.SITEURL.'categories.php');
}
?>
<!-- fOOD sEARCH Section Starts Here -->
<section class="food-search text-center">
<div class="container">
<h2>Foods on <a href="#" class="text-white">"<?php echo $category_title; ?>"</a></h2>
</div>
</section>
<!-- fOOD sEARCH Section Ends Here -->
<!-- fOOD MEnu Section Starts Here -->
<section class="food-menu">
<div class="container">
<h2 class="text-center">Food Menu</h2>
<?php
//Get the id from home page
//$cat_id = $_GET['category_id'];
//create sql query to display food from database thats are active and featured
$sql1 = "SELECT * FROM tbl_food WHERE category_id=$category_id";
//execute the query
$res1 = mysqli_query($conn,$sql1);
//count rows to check whether the category is available or not
$count1 = mysqli_num_rows($res1);
if($count1>0) {
//categories available
while ($row1=mysqli_fetch_assoc($res1)) {
//Get data like id,title,description,price,image
//Display the Featured Food
$id = $row1['id'];
$title = $row1['title'];
$description = $row1['description'];
$price = $row1['price'];
$image_name = $row1['image_name'];
?>
<div class="food-menu-box">
<div class="food-menu-img">
<?php
//check image is available or not
if ($image_name=="") {
//display messege
//image not available
echo "<div class='error'>Image not Available</div>";
}else{
//image is available
?>
<img src="<?php echo SITEURL; ?>images/food/<?php echo $image_name; ?>" alt="<?php echo $image_name; ?>" class="img-responsive img-curve">
<?php
}
?>
</div>
<div class="food-menu-desc">
<h4><?php echo $title; ?></h4>
<p class="food-price"><?php echo $price; ?></p>
<p class="food-detail">
<?php echo $description; ?>
</p>
<br>
<a href="<?php echo SITEURL; ?>order.php?food_id=<?php echo $id; ?>" class="btn btn-primary">Order Now</a>
</div>
</div>
<?php
}
}else{
//Featured Food are not available
echo "<div class='error'>Selected Category have no food</div>";
echo "<br><br>";
echo "<div class='error'><a href='".SITEURL."categories.php'>Click Here to check another category</a></div>";
}
?>
<div class="clearfix"></div>
</div>
</section>
<!-- fOOD Menu Section Ends Here -->
<?php
include('partials-front/footer.php');
?>