category-foods.php

<?php include('./partials-front/menu.php'); ?>

<?php
if (isset($_GET['category_id'])) {
    //url paramater have value;
    $category_id = $_GET['category_id'];
    // category title based on category id 
    $sql = "SELECT title FROM tbl_category WHERE id = '$category_id'";

    //execute query 
    $res = mysqli_query($conn, $sql);

    //get the value from database
    $row = mysqli_fetch_assoc($res);
    // get the title 
    $category_title  = $row['title'];
} else {
    //  not have value
    // redirect
    header('location:' . SITEURL);
}

?>
<!-- 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

        // creat query to get foods based on selected category 
        $sql2 = " SELECT * FROM tbl_food WHERE category_id= '$category_id'";
        //execute query 
        $res2 = mysqli_query($conn, $sql2);
        // count row 
        $count2 = mysqli_num_rows($res2);
        if ($count2) {
            //food is available
            while ($rows =  mysqli_fetch_assoc($res2)) {
                $id = $rows['id'];
                $title = $rows['title'];
                $price = $rows['price'];
                $description = $rows['description'];
                $image_name = $rows['image_name'];
        ?>


        <div class="food-menu-box">
            <div class="food-menu-img">
                <?php if ($image_name != "") {
                        ?><img src="<?php echo SITEURL; ?>/images/food/<?php echo $image_name ?>" alt=""
                    class="img-responsive img-curve"><?php

                                                                                                                                        } else {
                                                                                                                                            echo "<div class='failure'>Image not added</div>";
                                                                                                                                        } ?>
            </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="order.php?food_id=<?php echo $id ?>" class="btn btn-primary">Order Now</a>
            </div>
        </div>




        <?php
            }
        } else {
            // not have food

            echo "<div class='failure'> Food not available</div>";
        }




        ?>


        <div class=" clearfix">
        </div>



    </div>

</section>
<!-- fOOD Menu Section Ends Here -->

<?php include('./partials-front/footer.php'); ?>