D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
universalhomedecor.in
/
Filename :
category-details.php
back
Copy
<?php require('admin/config.php'); ?> <!DOCTYPE HTML> <html lang="en-US"> <head> <title>Category Details - UHD</title> <?php require('style.php'); ?> <style> .product-thumb .image img { width: 100%; height: auto; object-fit: cover; } .product-layout { margin-bottom: 30px; } .product-thumb { text-align: left; margin-bottom: 20px; } </style> </head> <body class="common-home Fauteuil"> <!-- HEADER DEFAULT MENU AREA --> <?php require('header.php'); ?> <!-- breadcrumb --> <div class="breadcrumb-main"> <div class="container"> <div class="breadcrumb-container"> <h2 class="page-title">Category Details</h2> <ul class="breadcrumb"> <li class="breadcrumb-item"> <a href="#">Home</a> </li> <li class="breadcrumb-item"> <a href="#">Category Details</a> </li> </ul> </div> </div> </div> <!-- main --> <main> <div id="product-category" class="container"> <div class="row"> <div id="content" class="col-sm-12"> <div class="category-row"> <!-- Fetch and Display Products for the Category --> <?php // Get category ID from URL $categoryId = isset($_GET['id']) ? intval($_GET['id']) : 0; // Fetch category details $categoryQuery = "SELECT * FROM `product_category` WHERE `id` = $categoryId"; $categoryResult = mysqli_query($conn, $categoryQuery); $category = mysqli_fetch_assoc($categoryResult); if ($category) { echo "<h3>Category: " . $category['category_name'] . "</h3>"; echo "<br>"; // Fetch products for the category $productQuery = "SELECT * FROM `products` WHERE `category` = $categoryId"; $productResult = mysqli_query($conn, $productQuery); if ($productResult && mysqli_num_rows($productResult) > 0) { echo '<div id="product-list" class="product-layout row row-cols-1 row-cols-sm-2 row-cols-md-3">'; while ($product = mysqli_fetch_assoc($productResult)) { ?> <div class="col"> <div class="product-thumb transition"> <div class="image"> <a href="product-details.php?id=<?php echo $product['id']; ?>" class="thumb-image"> <img src="admin/uploads/<?php echo $product['image']; ?>" alt="<?php echo $product['name']; ?>" title="<?php echo $product['name']; ?>" class="img-responsive"> </a> <div class="button-group"> <a href="product-details.php?id=<?php echo $product['id']; ?>"> <button class="addcart" type="button"> <i class="icon-eye"></i> <span class="hidden">View Product</span> </button> </a> </div> </div> <div class="product-description"> <div class="caption"> <div class="title-rating clearfix"> <h4 class="product-title"> <a href="product-details.php?id=<?php echo $product['id']; ?>"><?php echo $product['name']; ?></a> </h4> </div> <p><?php echo $product['short_desc']; ?></p> </div> </div> </div> </div> <?php } echo '</div>'; } else { echo '<p>No products found in this category.</p>'; } } else { echo '<p>Category not found.</p>'; } ?> </div> </div> </div> </div> </main> <!-- FOOTER AREA --> <?php require('footer.php'); ?> <a class="scrollToTop back-to-top" href="#" data-toggle="tooltip" title="" data-original-title="Top" style="display: block" data-bs-original-title=""> <i class="fa fa-angle-up"></i> </a> <!-- .FOOTER AREA --> <!-- Main jquery js --> <script src="assets/js/vendor/jquery-3.2.1.min.js"></script> <!-- bootstrap js --> <script src="assets/js/bootstrap.min.js"></script> <!-- owl-carousel js --> <script src="assets/js/owl.carousel.min.js"></script> <!-- js --> <script src="assets/js/themability_megamenu.js"></script> <!-- wow js --> <script src="https://cdnjs.cloudflare.com/ajax/libs/wow/1.1.2/wow.min.js"></script> <!-- Main js --> <script src="assets/js/theme.js"></script> </body> </html>