1#@!#!123s

https 1#@!#!123s
: / home2 / hershinecreation / public_html / hasonss.net /
Filename : single-cat.php
back
<?php
include 'include/header.php';

// Include database connection file
require 'DB/db.php';

// Check if the 'cid' parameter is set in the URL
if(isset($_GET['cid'])) {
    // Sanitize the 'cid' parameter to prevent SQL injection
    $cid = mysqli_real_escape_string($conn, $_GET['cid']);

    // Query to fetch products with the specified 'c_id'
    $sql = "SELECT * FROM products WHERE c_id = '$cid'";
    $result = $conn->query($sql);

    // Check if products were found for the specified category
    if ($result->num_rows > 0) {
        ?>

<!-- ::::::  Start  Breadcrumb Section  ::::::  -->
<div class="page-breadcrumb">
   <div>
        <img id="con1" src="assets/all.png" style="position:relative;width: 100%;bottom:0px;margin-top:-23px" alt="">
        <img id="con2" src="assets/edited.png" style="position:relative;width: 100%;bottom:0px;margin-top:-23px" alt="">
    </div>
    <div class="container" style="position: relative;bottom:85px;">
        <div class="row">
            <div class="col-12">
                <ul class="page-breadcrumb__menu">
                    <li class="page-breadcrumb__nav"><a style="color: black;font-weight:600" href="index.php">Home</a></li>
                    <li style="color: black;font-weight:600" class="page-breadcrumb__nav active">Products</li>
                </ul>
            </div>
        </div>
    </div>
</div> <!-- ::::::  End  Breadcrumb Section  ::::::  -->

<!-- :::::: Start Main Container Wrapper :::::: -->
<main id="main-container" class="main-container mb-5">
    <div class="container">
        <div class="row">
            <!-- Start Content - 5Grid -->
            <div class="col-12">
            <div class="section-content m-b-35 text-center">
                        <h5 class="section-content__title">Our Products</h5>
                    </div> <!-- End Section Title -->
                <div class="product-tab-area">
                    <div class="tab-content">
                        <div class="tab-pane show active shop-grid" id="sort-grid">
                            <div class="row">
                            <?php
                    // Loop through each product and display it
                    while ($row = $result->fetch_assoc()) {
                    ?>
                                <div class="col-lg-3 col-md-4 col-sm-6 col-12">
                                    <!-- Start Single Default Product -->
                                    <div class="product__box product__box--default">
                                        <!-- Start Product Image -->
                                        <div class="product__img-box">
                                            <a href="product.php?id=<?php echo $row['id']; ?>" class="product__img--link">
                                                <img class="product__img" src="imgupload/pUpload/<?php echo $row['p_img']; ?>" alt="">
                                                <img class="product__img" src="imgupload/pUpload/<?php echo $row['p_img1']; ?>" alt="">
                                            </a>
                                            
                                        </div> <!-- End Product Image -->
                                        <!-- Start Product Content -->
                                        <div class="product__content pos-relative">
                                            <a href="product.php?id=<?php echo $row['id']; ?>" class="text-center product__link product__link--weight-light m-t-15"><?php echo $row['p_name']; ?></a>
                                        </div> <!-- End Product Content -->
                                    </div> <!-- End Single Default Product -->
                                </div>
                                <?php
                    }
                    ?>     
                            </div>
                        </div>
                    </div>
                </div>
            </div> <!-- Start Content - 5Grid -->
        </div>
    </div>
</main> <!-- :::::: End MainContainer Wrapper :::::: -->

<?php
    } else {
        echo "No products found for this category";
    }
} else {
    echo "Invalid request";
}

include 'include/footer.php';
?>