category-foods.php

<?php include('./partials_front/menu.php');?>
<?php
    if(isset($_GET['category_id'])){
        $category_id = $_GET['category_id'];
        $sql = "SELECT `title` FROM `table_category` where `table_category`.`id` = '$category_id'";
        $res = mysqli_query($conn,$sql);
        $row = mysqli_fetch_assoc($res);
        $category_title = $row['title'];
    }
    else{
        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 
                

                $sql2 = "SELECT * FROM `table_food` WHERE `table_food`.`title` LIKE '%$category_title%'";
                
                $res2 = mysqli_query($conn,$sql2);

                $count2 = mysqli_num_rows($res2);

                if($count2 >0){
                    while($row2 = mysqli_fetch_assoc($res2)){
                        $id = $row2['id'];
                        $title = $row2['title'];
                        $price = $row2['price'];
                        $description = $row2['description'];
                        $image_name = $row2['image_name'];
                        
                        ?>
                        <div class="food-menu-box">
                            <div class="food-menu-img">
                            <?php 
                                if($image_name == ""){
                                    echo "<div class = \"error\">Image Not Available.</div>";
                                }
                                else{
                                    ?>
                                    <img src="<?php echo SITEURL;?>imag/food/<?php echo $image_name; ?>" alt="Chicke Hawain Pizza" class="img-responsive img-curve">
                                    <?php
                                    
                                }

                            ?>
                                
                            </div>

                            <div class="food-menu-desc">
                                <h4><?php echo $title;?></h4>
                                <p class="food-price">Rs. <?php echo $price;?></p>
                                <p class="food-detail">
                                    <?php echo $description;?>
                                </p>
                                <br>
                                <form action="order.php" method="post">
                                <input type="hidden" name="food_id" value="<?php echo $id; ?>">
                                <input type="submit" class="btn btn-primary" value="Add To Cart"></input>
                                </form>
                                
                            </div>
                        </div>
                        <?php
                    }
                }
                else{
                    echo "<div class = \"error\">Food not Found.</div>";
                }
                
            ?>

            


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

            

        </div>

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

    

    <?php include('./partials_front/footer.php');?>