File manager - Edit - /home/gppowercontrol/public_html/shop.php
Back
<!doctype html> <html class="no-js" lang=""> <head> <?php include "include/head.php" ?> </head> <body> <?php include "include/header.php" ?> <div class="breadcurb-area"> <div class="container"> <ul class="breadcrumb"> <li class="home"><a href="index.php">Home </a></li> <li> Shop</li> </ul> </div> </div> <div class="shop-product-area"> <div class="container"> <div class="row"> <div class="col-lg-3 col-md-12"> <div class="left-sidebar"> <div class="left-sidebar-title"> <h2>Shop By</h2> </div> <div class="shop-layout"> <div class="layout-title"> <h2>Accessories</h2> </div> <div class="layout-list"> <ul> <?php $sql = mysqli_query($con, "SELECT * FROM `category` ORDER BY id DESC"); while ($category = mysqli_fetch_assoc($sql)) { ?> <li><a href="shop.php?url=<?= $category['url'] ?>"><?= $category['name'] ?> (<?php $cat = $category['id']; $sqli = mysqli_query($con, "SELECT * FROM `product` WHERE `category` = '$cat'"); $count = mysqli_num_rows($sqli); echo $count; ?>)</a></li> <?php } ?> </ul> </div> </div> </div> </div> <div class="col-lg-9 col-md-12"> <div class="shop-product-view"> <div class="product-tab-area"> <div class="tab-content"> <div class="tab-pane active" id="shop-product"> <div class="tab-single-product"> <?php // How many products per page? $products_per_page = 9; // Get current page from URL, default is 1 $current_page = isset($_GET['page']) && is_numeric($_GET['page']) ? (int) $_GET['page'] : 1; if ($current_page < 1) $current_page = 1; // Calculate the starting LIMIT number $offset = ($current_page - 1) * $products_per_page; // Base query if (isset($_GET['url']) && $_GET['url'] != '') { $cat_url = mysqli_real_escape_string($con, $_GET['url']); $sqli = "SELECT * FROM `category` WHERE `url` = '$cat_url' AND `status` = '1' LIMIT 1"; $resss = mysqli_query($con, $sqli); if ($resss && mysqli_num_rows($resss) > 0) { $rowww = mysqli_fetch_assoc($resss); $category = (int)$rowww['id']; // Count total products for this category $count_query = "SELECT COUNT(*) as total FROM `product` WHERE `category` = '$category' AND `status` = '1'"; $sql = "SELECT * FROM `product` WHERE `category` = '$category' AND `status` = '1' LIMIT $offset, $products_per_page"; } else { // Invalid category fallback $count_query = "SELECT COUNT(*) as total FROM `product` WHERE `status` = '1'"; $sql = "SELECT * FROM `product` WHERE `status` = '1' LIMIT $offset, $products_per_page"; } } else { // Count total products for all $count_query = "SELECT COUNT(*) as total FROM `product` WHERE `status` = '1'"; $sql = "SELECT * FROM `product` WHERE `status` = '1' LIMIT $offset, $products_per_page"; } // Get total products $count_result = mysqli_query($con, $count_query); $count_row = mysqli_fetch_assoc($count_result); $total_products = $count_row['total'] ?? 0; // Total pages $total_pages = max(1, ceil($total_products / $products_per_page)); // Fetch paginated products $res = mysqli_query($con, $sql); while ($product = mysqli_fetch_assoc($res)) { $image = json_decode($product['image'], true) ?? []; $cat_id = (int) $product['category']; $sql2 = mysqli_query($con, "SELECT `name`, `url` FROM `category` WHERE `id`='$cat_id' LIMIT 1"); if ($sql2 && mysqli_num_rows($sql2) > 0) { $category = mysqli_fetch_assoc($sql2); $cat_name = $category['name']; $cat_url = $category['url']; } else { $cat_name = "Unknown Category"; $cat_url = "#"; } ?> <div class="singel-product single-product-col"> <div class="single-product-img"><a href="product.php?url=<?= $product['url'] ?>"><img src="media/product/<?= $image[0] ?>" alt="<?= $product['name'] ?>" alt="product"></a></div> <div class="single-product-content"> <h2 class="product-name"><a title="Product Name" href="product.php?url=<?= $product['url'] ?>"><?= $product['name'] ?></a> </h2> <div class="product-price"> <p>₹<?= $product['discounted_price'] ?></p> </div> <div class="product-actions"><button class="button btn-cart" title="Add to Cart" type="button" onclick="addtocart('<?= $product['id'] ?>','<?= htmlspecialchars($product['name']) ?>','<?= $image[0] ?? '' ?>','<?= $product['discounted_price'] ?>','<?= $product['url'] ?>','<?= $product['base_price'] ?>')"><i class="fa fa-shopping-cart"> </i><span>Add to Cart</span></button> <div class="add-to-link"> <ul class=""> <li class="wishlist"><a <?php if (isset($_SESSION['u_email'])) { ?> onclick="add_to_wishlist('<?= $product['id'] ?>','<?= $user['id'] ?>')" <?php } else { ?> href="login.php" <?php } ?>><i class="fa fa-heart"></i></a> </li> </ul> </div> </div> </div> </div> <?php } ?> </div> </div> </div> <div class="tab-bar tab-bar-bottom"> <div class="toolbar"> <div class="pages"> <strong>Page:</strong> <ol> <?php if ($current_page > 1): ?> <li> <a title="Previous" href="?page=<?= $current_page - 1 ?><?= isset($cat_url) ? '&url=' . urlencode($cat_url) : '' ?>"> <i class="fa fa-arrow-left"></i> </a> </li> <?php endif; ?> <?php for ($i = 1; $i <= $total_pages; $i++): ?> <?php if ($i == $current_page): ?> <li class="current"><?= $i ?></li> <?php else: ?> <li> <a href="?page=<?= $i ?><?= isset($cat_url) ? '&url=' . urlencode($cat_url) : '' ?>"> <?= $i ?> </a> </li> <?php endif; ?> <?php endfor; ?> <?php if ($current_page < $total_pages): ?> <li> <a title="Next" href="?page=<?= $current_page + 1 ?><?= isset($cat_url) ? '&url=' . urlencode($cat_url) : '' ?>"> <i class="fa fa-arrow-right"></i> </a> </li> <?php endif; ?> </ol> </div> </div> </div> </div> </div> </div> </div> </div> </div> <?php include "include/footer.php" ?> <?php include "include/foot.php" ?> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 8.1.34 | Generation time: 0.68 |
proxy
|
phpinfo
|
Settings