1#@!#!123s

: / home3 / encodto1 / aviscollection.com /
Filename : product-list.php
back
<?php include'style.php'; 

$sub_cat = $_GET['category'];
$gender = $_GET['gender'];
$proList = "";

if ($sub_cat != '') {
    $proQry= "SELECT * FROM products WHERE product_sub_id = $sub_cat AND product_gender = '$gender'";
    $proList = mysqli_query($conn, $proQry);
}else{
    $proQry= "SELECT * FROM products WHERE product_gender = '$gender'";
    $proList = mysqli_query($conn, $proQry);
}

// $proQry= "SELECT * FROM products WHERE product_sub_id = $sub_cat AND product_gender = '$gender'";
// $proList = mysqli_query($conn, $proQry);
?>
<body>
<?php include'header.php'; ?>
    <main class="main">
        <div class="page-header breadcrumb-wrap">
            <div class="container">
                <div class="breadcrumb">
                    <a href="index.html" rel="nofollow">Home</a>
                    <span></span> Shop
                    <span></span> <?php echo $gender; ?>
                </div>
            </div>
        </div>
        <section class="mt-50 mb-50">
            <div class="container">
                <div class="row flex-row-reverse">
                    <div class="col-lg-9">
                        <div class="shop-product-fillter">
                            <div class="totall-product">
                            <?php 
                            if($proList-> num_rows > 0){
                                $proNum = mysqli_num_rows($proList);
                                echo '<p> We found <strong class="text-black">'.$proNum.'</strong> items</p>';
                            }else{
                                echo '<p> We found <strong class="text-danger">0</strong> items</p>';
                            }
                            ?>
                                <!-- <p> We found <strong class="text-brand">68</strong> items</p> -->
                            </div>
                            <!-- <div class="sort-by-product-area">
                                <div class="sort-by-cover">
                                    <div class="sort-by-product-wrap">
                                        <div class="sort-by">
                                            <span><i class="fas fa-sort"></i>Sort by:</span>
                                        </div>
                                        <div class="sort-by-dropdown-wrap">
                                            <span> Featured <i class="fas fa-angle-down"></i></span>
                                        </div>
                                    </div>
                                    <div class="sort-by-dropdown">
                                        <ul>
                                            <li><a class="active" href="#">Featured</a></li>
                                            <li><a href="#">Price: Low to High</a></li>
                                            <li><a href="#">Price: High to Low</a></li>
                                            <li><a href="#">Release Date</a></li>
                                            <li><a href="#">Avg. Rating</a></li>
                                        </ul>
                                    </div>
                                </div>
                            </div> -->
                        </div>
                        <div class="row product-grid-3">
                            <?php
                            if($proList-> num_rows > 0){
                            while ($pro = mysqli_fetch_assoc($proList)) { ?>
                            <div class="col-lg-4 col-md-4 col-12 col-sm-6">
                                <div class="product-cart-wrap mb-30">
                                    <div class="product-img-action-wrap">
                                        <div class="product-img product-img-zoom">
                                            <a>
                                                <img class="default-img" src="admin/product-images/<?php echo $pro['product_img1']; ?>" alt="<?php echo $pro['product_name']; ?>">
                                                <img class="hover-img" src="admin/product-images/<?php echo $pro['product_img2']; ?>" alt="<?php echo $pro['product_name']; ?>">
                                            </a>
                                        </div>
                                        <div class="product-action-1">
                                            <a aria-label="Quick view" class="action-btn hover-up" href="product-details?product=<?php echo $pro['product_id']; ?>&sub_category=<?php echo $pro['product_sub_id']; ?>"><i class="far fa-eye"></i></a>
                                            <a aria-label="Add To Wishlist" class="action-btn hover-up" href="shop-wishlist.html"><i class="far fa-heart"></i></a>
                                        </div>
                                        <div class="product-badges product-badges-position product-badges-mrg">
                                            <span class="hot"><?php echo $gender; ?></span>
                                        </div>
                                    </div>
                                    <div class="product-content-wrap">
                                        <h2><a href="product-details?product=<?php echo $pro['product_id']; ?>&sub_category=<?php echo $pro['product_sub_id']; ?>"><?php echo $pro['product_name']; ?></a></h2>
                                        <div class="product_offer" title="product offer">
                                            <span>
                                                <span>35% OFF</span>
                                            </span>
                                        </div>
                                        <!-- <div class="product-price">
                                            <span><i class="fa-solid fa-indian-rupee-sign"></i> 238.85 </span>
                                            <span class="old-price"><i class="fa-solid fa-indian-rupee-sign"></i> 245.8</span>
                                        </div> -->
                                    </div>
                                </div>
                            </div>
                            <?php } } ?>

                        </div>

                    </div>
                    <div class="col-lg-3 primary-sidebar sticky-sidebar">
                        <div class="widget-category mb-30">
                            <h5 class="section-title style-1 mb-30 wow fadeIn animated">Category</h5>
                            <ul class="categories">
                                <?php 
                                $subQry= "SELECT * FROM product_sub_category WHERE sub_category_gender = '$gender'";
                                $subList = mysqli_query($conn, $subQry);
                                while ($res = mysqli_fetch_assoc($subList)) { ?>
                                    <li><a href="product-list?category=<?php echo $res['sub_category_id']; ?>&gender=<?php echo $gender; ?>" ><?php echo $res['sub_category_name']; ?></a></li>
                                <?php } ?>
                            </ul>
                        </div>
                        
                    </div>
                </div>
            </div>
        </section>
    </main>

<?php include'footer.php'; ?>
</body>

</html>