food-search.php

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

    <!-- fOOD sEARCH Section Starts Here -->
    <section class="food-search text-center">
        <div class="container">
            <?php 
                //Get the search keyword
                //$search = $_POST['search'];
                $search = mysqli_real_escape_string($conn,$_POST['search']);
            ?>
            
            <h2>Foods on Your Search <a href="<?php echo SITEURL; ?>foods.php" class="text-white">"<?php echo $search; ?>"</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 
                                //create sql query to display food from database thats are active and featured
                                $sql = "SELECT * FROM tbl_food WHERE title LIKE '%$search%' OR description LIKE '%$search%'";
                                //execute the query
                                $res = mysqli_query($conn,$sql);
                                //count rows to check whether the category is available or not
                                $count = mysqli_num_rows($res);
                                if($count>0) {
                                    //categories available
                                    while ($row=mysqli_fetch_assoc($res)) {
                                        //Get data like id,title,description,price,image
                                        //Display the Featured Food
                                        $id = $row['id'];
                                        $title = $row['title'];
                                        $description = $row['description'];
                                        $price = $row['price'];
                                        $image_name = $row['image_name'];

                        ?>
                    <div class="food-menu-box">
                         <div class="food-menu-img">
                            <?php 
                                //check image is available or not
                                if ($image_name=="") {
                                        //display messege
                                        //image not available
                                        echo "<div class='error'>Image not Available</div>";
                                    }else{
                                        //image is available
                                        ?>
                                        <img src="<?php echo SITEURL; ?>images/food/<?php echo $image_name;  ?>" alt="<?php echo $image_name;  ?>" class="img-responsive img-curve">
                                       <?php
                                    }
                             ?>
                         </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="<?php echo SITEURL; ?>order.php?food_id=<?php echo $id; ?>" class="btn btn-primary">Order Now</a>
                        </div>
                    </div>

                        <?php
                        }
                }else{
                    //Featured Food are not available
                    echo "<div class='error'>No Food found</div>";
                    echo "<br><br>";
                    echo "<div class='error'><a href='".SITEURL."foods.php'>Click Here to search again</a></div>";
                }

            ?>

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

            

        </div>

    </section>
    <!-- fOOD Menu Section Ends Here -->
<?php
    include('partials-front/footer.php');
?>