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/bond-lounge.com/public_html/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php session_start();
$page_name = basename($_SERVER['PHP_SELF']);
$page_title = "Drink Menu";
$page_header = "about_header.jpg";
include("header.php"); ?>
<title><?php echo $company_name; ?> - <?php echo $page_title; ?></title>


<section class="faq-one">
    <div class="container-fluid">
        <div class="row justify-content-center">
            <div class="col-xl-12 col-lg-12" style='background-image: url("site_img/general/bg.jpg"); background-size: contain; background-position: center;'>
                    <br>
                    <h1 style='color:white;text-align:center;'><?= $page_title ?></h1>
                    <br><br>
<?php
    $word = "Arena Drinks";
	$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>";
            // 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>
                               $product_desc 
                                 <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>
        
<?php include("footer.php"); ?>