Server : LiteSpeed System : Linux us-phx-web1202.main-hosting.eu 4.18.0-553.84.1.lve.el8.x86_64 #1 SMP Tue Nov 25 18:33:03 UTC 2025 x86_64 User : u615232177 ( 615232177) PHP Version : 8.1.33 Disable Function : NONE Directory : /home/u615232177/domains/base24rooftop.com/public_html/ |
<?php session_start();
$page_name = basename($_SERVER['PHP_SELF']);
$page_title = "VIP Food Menu";
$page_header = "c9a189edf4.jpg";
include("header.php"); ?>
<title><?php echo $company_name; ?> - <?php echo $page_title; ?></title>
<?php include("page_header.php"); ?>
<br><br>
<section class="faq-page">
<div class="container">
<div class="row justify-content-center">
<div class="col-xl-12 col-lg-12" style='background-image: url("site_img/general/bg_food.jpg"); background-size: contain; background-position: center; border-radius:5px;'>
<?php
$word = "Food VIP";
$stmt = $con -> prepare('SELECT cat_id,cat_title FROM categories WHERE featured = ?');
$stmt -> bind_param('s', $word);
$stmt -> execute();
$stmt -> store_result();
$stmt -> bind_result($cat_id,$category_name);
$numrows = $stmt -> num_rows();
if($numrows > 0){
while ($stmt -> fetch()) {
echo "<br><h2 style='color:white;text-align:center;'>$category_name</h2>";
echo"<hr style='height: 4px; border: none; background: linear-gradient(to right, red, orange, yellow);'>
";
// Fetch and display the products in this category
$stmt2 = $con -> prepare('SELECT product_title,product_price,product_desc FROM products WHERE product_cat = ?');
$stmt2 -> bind_param('i', $cat_id);
$stmt2 -> execute();
$stmt2 -> store_result();
$stmt2 -> bind_result($product_title, $product_price, $product_desc);
$numrows2 = $stmt2 -> num_rows();
if($numrows2 > 0){
echo "<div class='row'>";
while ($stmt2 -> fetch()) {
echo"
<div class='col-md-4' style='margin-bottom:20px;'>
<div class='card' style='background:transparent;'>
<div class='card-body'>
<h5 class='card-title' style='color:#d4b400;font-weight:900;'>$product_title</h5>
<span style='color:white;'>$product_desc</span>
<p class='card-text' style='color:#d4b400 !important; font-weight:900;'>"; ?><?php echo $currency; echo number_format((float)$product_price, 2, '.', ','); ?><?php echo"</p>
</div>
</div>
</div>
";
}
echo "</div>"; // end row
} else {
echo "<p style='color:white;text-align:center;'>No products available in this category.</p>";
}
}
}
?>
</div>
</div>
</div>
</section>
<br><br>
<?php include("footer.php") ?>