-
Notifications
You must be signed in to change notification settings - Fork 2
/
item-menu.php
125 lines (121 loc) · 6.07 KB
/
item-menu.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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
<div class="container w-75 my-4 h-100 nav-justified item-menu" style="margin-bottom: 200px !important;">
<ul class="nav nav-tabs">
<li class="nav-item tab-item">
<a class="nav-link active" data-bs-toggle="tab" href="#laddu">Laddu</a>
</li>
<li class="nav-item tab-item">
<a class="nav-link" data-bs-toggle="tab" href="#snacks">Snacks</a>
</li>
<li class="nav-item tab-item">
<a class="nav-link" data-bs-toggle="tab" href="#papad">Papad</a>
</li>
</ul>
<!-- Tab panes -->
<div class="tab-content">
<div class="tab-pane container active" id="laddu">
<div class="d-flex flex-wrap justify-content-center">
<?php
require 'dbconnection.php';
$sql = "SELECT `PRODUCT_ID`, `PRODUCT_NAME`, `PRICE`, `DESCRIPTION`, `QUANTITY`, `IMAGE` FROM product WHERE `CATEGORY_ID` = (SELECT CATEGORY_ID FROM category WHERE category_name = 'LADDU') LIMIT 9";
$result = mysqli_query($con,$sql);
if($result)
{
while(($row=mysqli_fetch_assoc($result))!=null)
{
$img = $row['IMAGE'];
$name = $row['PRODUCT_NAME'];
$price = $row['PRICE'];
$qty = $row["QUANTITY"];
$id = $row['PRODUCT_ID'];
echo "<div class='card m-3' style='width:16rem;'>
<img src='{$product_images}{$img}' class='card-img-top'>
<div class='card-body'>
<h5 class='card-title'>{$name}</h5>
<p class='card-text mb-0'>Price : {$price} Rs / Pkt</p>
<p class='card-text mt-0'>Quantity : {$qty} gm</p>
<div class='row container-fluid p-0 mx-auto'>
<a href='{$product_page}?id={$id}' class='btn btn-primary col-12 text-nowrap mx-md-1 my-md-0 my-sm-2 mx-sm-0 my-2'>View <i class='bi bi-eye'></i></a>
</div>
</div>
</div>";
}
}
else
{
echo "error";
}
?>
</div>
</div>
<div class="tab-pane container fade" id="snacks">
<div class="d-flex flex-wrap justify-content-center">
<?php
require 'dbconnection.php';
$sql = "SELECT `PRODUCT_ID`, `PRODUCT_NAME`, `PRICE`, `DESCRIPTION`, `QUANTITY`, `IMAGE` FROM product WHERE `CATEGORY_ID` = (SELECT CATEGORY_ID FROM category WHERE category_name = 'SNACKS') LIMIT 9";
$result = mysqli_query($con,$sql);
if($result)
{
while(($row=mysqli_fetch_assoc($result))!=null)
{
$img = $row['IMAGE'];
$name = $row['PRODUCT_NAME'];
$price = $row['PRICE'];
$qty = $row["QUANTITY"];
$id = $row['PRODUCT_ID'];
echo "<div class='card m-3' style='width:16rem;'>
<img src='{$product_images}{$img}' class='card-img-top'>
<div class='card-body'>
<h5 class='card-title'>{$name}</h5>
<p class='card-text mb-0'>Price : {$price} Rs / Pkt</p>
<p class='card-text mt-0'>Quantity : {$qty} gm</p>
<div class='row container-fluid p-0 mx-auto'>
<a href='{$product_page}?id={$id}' class='btn btn-primary col-12 text-nowrap mx-md-1 my-md-0 my-sm-2 mx-sm-0 my-2'>View <i class='bi bi-eye'></i></a>
</div>
</div>
</div>";
}
}
else
{
echo "error";
}
?>
</div>
</div>
<div class="tab-pane container fade" id="papad">
<div class="d-flex flex-wrap justify-content-center">
<?php
require 'dbconnection.php';
$sql = "SELECT `PRODUCT_ID`, `PRODUCT_NAME`, `PRICE`, `DESCRIPTION`, `QUANTITY`, `IMAGE` FROM product WHERE `CATEGORY_ID` = (SELECT CATEGORY_ID FROM category WHERE category_name = 'PAPAD') LIMIT 9";
$result = mysqli_query($con,$sql);
if($result)
{
while(($row=mysqli_fetch_assoc($result))!=null)
{
$img = $row['IMAGE'];
$name = $row['PRODUCT_NAME'];
$price = $row['PRICE'];
$qty = $row["QUANTITY"];
$id = $row['PRODUCT_ID'];
echo "<div class='card m-3' style='width:16rem;'>
<img src='{$product_images}{$img}' class='card-img-top'>
<div class='card-body'>
<h5 class='card-title'>{$name}</h5>
<p class='card-text mb-0'>Price : {$price} Rs / Pkt</p>
<p class='card-text mt-0'>Quantity : {$qty} gm</p>
<div class='row container-fluid p-0 mx-auto'>
<a href='{$product_page}?id={$id}' class='btn btn-primary col-12 text-nowrap mx-md-1 my-md-0 my-sm-2 mx-sm-0 my-2'>View <i class='bi bi-eye'></i></a>
</div>
</div>
</div>";
}
}
else
{
echo "error";
}
?>
</div>
</div>
</div>
</div>