Kacharyu-menulist.php

<div class="container-fluid my-5 mx-0 px-2">
    <h1 class="display-6 text-secondary text-center mb-4"><span class="border-bottom border-5 mb-4">Kachriyu</span></h1>
    <div class="menulist-carousel-kachriyu owl-carousel owl-theme">
        <?php 
            $sql = "SELECT `PRODUCT_ID`, `PRODUCT_NAME`, `PRICE`, `DESCRIPTION`, `QUANTITY`, `IMAGE` FROM product WHERE `CATEGORY_ID` = (SELECT CATEGORY_ID FROM category WHERE category_name = 'KACHARIYU') LIMIT 5";
            $result = mysqli_query($con,$sql);
            if($result)
            {
                while(($row=mysqli_fetch_assoc($result))!=null)
                {
                    $img = $row['IMAGE'];
                    $name = $row['PRODUCT_NAME'];
                    $price = $row['PRICE'];
                    $qty = $row["QUANTITY"];
                    $id = $row['PRODUCT_ID'];
                    echo "<div class='item'>
                            <div class='card m-4' style='width:16rem;'>
                                <img src='{$product_images}{$img}' class='card-img-top'>
                                    <div class='card-body'>
                                    <h5 class='card-title'>{$name}</h5>
                                    <p class='card-text mb-0'>Price : {$price} Rs / Pkt</p>
                                    <p class='card-text mt-0'>Quantity : {$qty} gm</p>
                                    <div class='row container-fluid p-0 mx-auto'>
                                        <a href='{$product_page}?id={$id}' class='btn btn-primary col-12 text-nowrap mx-md-1 my-md-0 my-sm-2 mx-sm-0 my-2'>View <i class='bi bi-eye'></i></a>
                                    </div>
                                </div>
                            </div>
                        </div>";
                }
            }
        ?>
        
        <div class='item d-flex justify-content-center'>
            <div class='card m-4 d-flex align-items-center justify-content-center overflow-hidden' style='width:16rem;'>
                <?php 
                    $sql = "SELECT category_id FROM category WHERE category_name = 'CHIKKI'";
                    $result = mysqli_query($con,$sql);
                    $row = mysqli_fetch_assoc($result);
                    $cid = $row['category_id'];
                ?>
                <a href="<?php echo "{$category_page}?cid={$cid}"; ?>" class="stretched-link"><img src='Assets/Images/viewmore.jpeg' class='card-img' style="transform:scale(1.2);"></a>
            </div>
        </div>
    </div>
</div>