1#@!#!123s

https 1#@!#!123s
: / home2 / hershinecreation / www / hariomtrader.com /
Filename : category.php
back
<?php
require 'DB/db.php';
include 'header.php';

// Get the category name from the request
$page_flname = $_REQUEST['cat_name'];

// SQL query to fetch category details based on the slug
$sql = "SELECT * FROM category WHERE c_slug = '$page_flname'"; 

// Execute the query
$result = $conn->query($sql);

// Fetch category details
while ($row = mysqli_fetch_assoc($result)) { 
?>
    <!-- main-area -->
    <main>

        <?php $id =  $row['c_id'];
        //  echo $id;
        ?>
        <!-- breadcrumb-area -->
        <section class="breadcrumb-area tg-motion-effects breadcrumb-bg" data-background="imgupload/cUpload/<?php echo $row['c_img'] ?>">
            <div class="container">
                <div class="row">
                    <div class="col-lg-12">
                        <div class="breadcrumb-content">
                            <h1 class="title"><?php echo $row['c_name'] ?></h1>
                            <ol class="breadcrumb">
                                <li class="breadcrumb-item"><a href="<?php $rout ?>">Home</a></li>
                                <li class="breadcrumb-item active" aria-current="page"><?php echo $row['c_name'] ?></li>
                            </ol>
                            </nav>
                        </div>
                    </div>
                </div>
            </div>
        </section>
        <!-- breadcrumb-area-end -->



        <!-- product-area -->
        <section class="product-area-three product-bg-three">
            <div class="container">
                <div class="row">
                    <div class="col-lg-12">
                        <div class="section-title text-center mb-50">
                            <span class="sub-title">Mirmuslima Llc</span>
                            <h2 class="title">Our <?php echo $row['c_name'] ?></h2>
                            <div class="title-shape" data-background="assets/img/images/title_shape.png" style="background-image: url(&quot;assets/img/images/title_shape.png&quot;);"></div>
                        </div>
                    </div>
                </div>
                <div class="product-item-wrap-three">
                    <div class="row justify-content-center">
                        <!-- <div class="col-xl-3 col-lg-4 col-md-6 col-sm-10" > -->
                        <?php
                        $sql = "SELECT * FROM products WHERE c_id = '$id'";
                        // echo $sql;
                        $result = mysqli_query($conn, $sql);
                        while ($row = mysqli_fetch_assoc($result)) {
                        ?>
                            <div class="col-md-4 " style="border: 20px solid #F0FFF0;">
                                <div class="product-item-three">
                                    <div class="product-thumb-three">
                                        <a href="product/<?php echo $row['slug'] ?>"><img src="imgupload/pUpload/<?php echo $row['p_img'] ?>" alt=""></a>
                                        <!-- <span class="batch">New<i class="fas fa-star"></i></span> -->
                                    </div>
                                    <div class="product-content-three">
                                        <h2 class="title"><a href="product/<?php echo $row['slug'] ?>"><?php echo $row['p_name'] ?></a></h2>
                                    </div>
                                </div>
                            </div>
                        <?php } ?>
                    </div>
                </div>
            </div>
        </section>
        <!-- product-area-end -->



    </main>
    <!-- main-area-end -->

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