1#@!#!123s

https 1#@!#!123s
: / home2 / hershinecreation / www / hiainternational.com /
Filename : category.php
back
<?php include 'header.php';
$page_flname = $_REQUEST['c_name'];

$flname1 = str_replace(".php", "", $page_flname);

$flname = strtolower($flname1);
$sql = "SELECT * FROM category WHERE slug = '$flname'"; // Query to fetch product details

$result = $con->query($sql);
while ($row = mysqli_fetch_assoc($result)) {

    $id = $row['id'];

?>
    <!-- Breadcrumb Start -->
    <div class="bread-crumb" style="background-image:url(assets/images/indian.png)">
        <div class="container">
            <div class="matter">
                <h2>products</h2>
                <ul class="list-inline">
                    <li class="list-inline-item"><a href="index.php">HOME</a></li>
                    <li class="list-inline-item"><a href="#">products</a></li>
                </ul>
            </div>
        </div>
    </div>
    <!-- Breadcrumb End -->
     
    <div class="shop">
        <div class="container">
            <div class="row">
            <div class="col-sm-12 commontop text-center">
                <h4>Products</h4>
                <div class="divider style-1 center">
                    <span class="hr-simple left"></span>
                    <i class="icofont icofont-ui-press hr-icon"></i>
                    <span class="hr-simple right"></span>
                </div>
                <!-- <p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam efficitur placerat nulla, in suscipit erat sodales id. Nullam ultricies eu turpis at accumsan. Mauris a sodales mi, eget lobortis nulla.</p> -->
            </div>
            </div>
            <div class="row" >
                <div class="col-md-12 mainpage">
                    <div class="form-row" style="justify-content: center;">
                        <?php
                        $sql = "SELECT * FROM product WHERE `category-id` = $id";

                        $result = mysqli_query($con, $sql);

                        while ($row = mysqli_fetch_assoc($result)) {
                        ?>
                            <div class="product-layout product-grid col-lg-4 col-md-4 col-sm-6 col-12">
                                <div class="product-thumb">
                                    <div class="image">
                                        <a class="link" href="product/<?php echo $row['slug'] ?>"><img src="admin/<?php echo $row['img'] ?>" alt="<?php echo $row['name'] ?>" title="<?php echo $row['name'] ?>" class="img-fluid" /></a>
                                        <div class="hoverbox">
                                            <!-- <a class="btn btn-theme btn-md" href="shopping-cart.html">Add To Cart</a> -->
                                        </div>
                                    </div>
                                    <div class="caption ">
                                        <a href="product/<?php echo $row['slug'] ?>"><h4 ><?php echo $row['name'] ?></h4></a>
                                    </div>
                                </div>
                            </div>
                        <?php } ?>
                        <!-- Single Product End -->
                        <!-- Product List End -->
                    </div>

                </div>
            </div>
        </div>
    </div>

<?php }
include 'footer.php' ?>