D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
tresboutique.in
/
Filename :
products.php
back
Copy
<?php // Fetch filters directly from the URL $catId = $_GET['catId'] ?? ''; $occassion = $_GET['occassion'] ?? ''; ?> <!DOCTYPE html> <html class="no-js" lang="en"> <head> <title>Tres Boutique - Products</title> <?php require('style.php'); ?> </head> <body> <?php include 'header.php'; ?> <main class="main"> <div class="page-header breadcrumb-wrap"> <div class="container"> <div class="breadcrumb"> <a href=".php" rel="nofollow">Home</a> <span></span> Shop </div> </div> </div> <section class="mt-50 mb-50"> <div class="container"> <div class="row"> <div class="col-lg-12"> <div class="row product-grid-3"> <?php // SQL query with filters $sql = "SELECT p.*, c.product_category_name FROM products p JOIN product_category c ON p.product_category = c.product_category_id WHERE 1"; $params = []; $types = ''; if ($catId) { $sql .= " AND p.product_category = ?"; $params[] = $catId; $types .= 'i'; } if ($occassion) { $sql .= " AND p.product_occassion = ?"; $params[] = $occassion; $types .= 's'; } $stmt = $conn->prepare($sql); if (!empty($params)) { $stmt->bind_param($types, ...$params); } $stmt->execute(); $result = $stmt->get_result(); // Display products if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { ?> <div class="col-lg-3 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 href="productdetails.php?product_id=<?php echo $row['product_id']; ?>"> <img class="default-img" src="tresadmin/uploads/products/<?php echo $row['product_img_1']; ?>" alt=""> <img class="hover-img" src="tresadmin/uploads/products/<?php echo $row['product_img_1']; ?>" alt="hover image"> </a> </div> </div> <div class="product-content-wrap"> <div class="product-category"> <a href="#"><?php echo ucfirst($row['product_category_name']); ?></a> </div> <h2><a href="productdetails.php?id=<?php echo $row['product_id']; ?>"><?php echo $row['product_name']; ?></a></h2> <div class="product-price"> <span>Rs.<?php echo number_format($row['product_price'], 2); ?></span> </div> </div> </div> </div> <?php } } else { echo '<p>No products found for the selected filters.</p>'; } $stmt->close(); ?> </div> </div> </div> </div> </section> </main> <?php include 'footer.php' ?> <!-- Preloader Start --> <div id="preloader-active"> <div class="preloader d-flex align-items-center justify-content-center"> <div class="preloader-inner position-relative"> <div class="text-center"> <h5 class="mb-5">Now Loading</h5> <div class="loader"> <div class="bar bar1"></div> <div class="bar bar2"></div> <div class="bar bar3"></div> </div> </div> </div> </div> </div> <!-- Vendor JS--> <script src="assets/js/vendor/modernizr-3.6.0.min.js"></script> <script src="assets/js/vendor/jquery-3.6.0.min.js"></script> <script src="assets/js/vendor/jquery-migrate-3.3.0.min.js"></script> <script src="assets/js/vendor/bootstrap.bundle.min.js"></script> <script src="assets/js/plugins/slick.js"></script> <script src="assets/js/plugins/jquery.syotimer.min.js"></script> <script src="assets/js/plugins/wow.js"></script> <script src="assets/js/plugins/jquery-ui.js"></script> <script src="assets/js/plugins/perfect-scrollbar.js"></script> <script src="assets/js/plugins/magnific-popup.js"></script> <script src="assets/js/plugins/select2.min.js"></script> <script src="assets/js/plugins/waypoints.js"></script> <script src="assets/js/plugins/counterup.js"></script> <script src="assets/js/plugins/jquery.countdown.min.js"></script> <script src="assets/js/plugins/images-loaded.js"></script> <script src="assets/js/plugins/isotope.js"></script> <script src="assets/js/plugins/scrollup.js"></script> <script src="assets/js/plugins/jquery.vticker-min.js"></script> <script src="assets/js/plugins/jquery.theia.sticky.js"></script> <script src="assets/js/plugins/jquery.elevatezoom.js"></script> <!-- Template JS --> <script src="assets/js/main.js"></script> <script src="assets/js/shop.js"></script> </body> </html>