| Server IP : 147.93.80.58 / Your IP : 216.73.216.249 Web Server : LiteSpeed System : Linux id-dci-web1866.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64 User : u939086737 ( 939086737) PHP Version : 8.2.28 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u939086737/domains/jeevikagaumaa.in/public_html/ |
Upload File : |
<?php
session_start();
include './action/config.php';
$per_page_record = 24;
$p = $_GET['p'] ?? 1;
$start_from = ($p - 1) * $per_page_record;
?>
<!DOCTYPE html>
<html lang="en" data-bs-theme="light">
<head>
<!--required meta tags-->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!--meta-->
<meta name="description" content="">
<meta name="author" content="">
<meta name="keywords" content="">
<link rel="icon" href="assets/img/favicon.png" type="image/png" sizes="16x16">
<title><?= $shop['name'] ?></title>
<link rel="stylesheet" href="assets/css/main.css">
<style>
label {
font-size: 12px;
font-weight: 700;
}
</style>
</head>
<body>
<div class="main-wrapper">
<?php include './header.php'; ?>
<!--breadcrumb section start-->
<div class="gstore-breadcrumb position-relative z-1 overflow-hidden mt--50">
<img src="assets/img/shapes/bg-shape-6.png" alt="bg-shape" class="position-absolute start-0 z--1 w-100 bg-shape">
<img src="assets/img/shapes/pata-xs.svg" alt="pata" class="position-absolute pata-xs z--1 vector-shape">
<img src="assets/img/shapes/onion.png" alt="onion" class="position-absolute z--1 onion start-0 top-0 vector-shape">
<img src="assets/img/shapes/frame-circle.svg" alt="frame circle" class="position-absolute z--1 frame-circle vector-shape">
<img src="assets/img/shapes/leaf.svg" alt="leaf" class="position-absolute z--1 leaf vector-shape">
<img src="assets/img/shapes/garlic-white.png" alt="garlic" class="position-absolute z--1 garlic vector-shape">
<img src="assets/img/shapes/roll-1.png" alt="roll" class="position-absolute z--1 roll vector-shape">
<img src="assets/img/shapes/roll-2.png" alt="roll" class="position-absolute z--1 roll-2 vector-shape">
<img src="assets/img/shapes/pata-xs.svg" alt="roll" class="position-absolute z--1 pata-xs-2 vector-shape">
<img src="assets/img/shapes/tomato-half.svg" alt="tomato" class="position-absolute z--1 tomato-half vector-shape">
<img src="assets/img/shapes/tomato-slice.svg" alt="tomato" class="position-absolute z--1 tomato-slice vector-shape">
<img src="assets/img/shapes/cauliflower.png" alt="tomato" class="position-absolute z--1 cauliflower vector-shape">
<img src="assets/img/shapes/leaf-gray.png" alt="tomato" class="position-absolute z--1 leaf-gray vector-shape">
<div class="container">
<div class="row">
<div class="col-12">
<div class="breadcrumb-content">
<h2 class="mb-2 text-center">Shop</h2>
<nav>
<ol class="breadcrumb justify-content-center">
<li class="breadcrumb-item fw-bold" aria-current="page"><a href="./">Home</a></li>
<li class="breadcrumb-item fw-bold" aria-current="page">Shop</li>
<li class="breadcrumb-item fw-bold" aria-current="page"><?= isset($_GET['category']) ? $_GET['category'] : 'All' ?></li>
</ol>
</nav>
</div>
</div>
</div>
</div>
</div>
<!--breadcrumb section end-->
<!--shop grid section start-->
<section class="gshop-gshop-grid ptb-120">
<div class="container">
<div class="row g-4">
<div class="col-xl-3">
<div class="gshop-sidebar bg-white rounded-2 overflow-hidden" style="position: -webkit-sticky; position: sticky; top: 150px;">
<div class="sidebar-widget search-widget bg-white py-5 px-4">
<div class="widget-title d-flex">
<h6 class="mb-0 flex-shrink-0">Search Now</h6>
<span class="hr-line w-100 position-relative d-block align-self-end ms-1"></span>
</div>
<form class="search-form d-flex align-items-center mt-4" method="get">
<input type="text" name="search" placeholder="Search...">
<button type="submit" class="submit-icon-btn-secondary"><i class="fa-solid fa-magnifying-glass"></i></button>
</form>
</div>
<div class="sidebar-widget category-widget bg-white py-5 px-4 border-top">
<div class="widget-title d-flex">
<h6 class="mb-0 flex-shrink-0">Categories</h6>
<span class="hr-line w-100 position-relative d-block align-self-end ms-1"></span>
</div>
<ul class="widget-nav mt-4">
<?php
$qry1 = mysqli_query($con, "SELECT DISTINCT category FROM product WHERE status = 1 ORDER BY category ASC");
while ($cr = mysqli_fetch_array($qry1)) :
?>
<li>
<a href="shop?p=1&category=<?= $cr['category'] ?>" class="d-flex justify-content-between align-items-center"><span class="fw-bold fs-xs total-count"><?= $cr['category'] ?></span></a>
</li>
<?php endwhile; ?>
</ul>
</div>
</div>
</div>
<div class="col-xl-9">
<div class="shop-grid">
<div class="listing-top d-flex align-items-center justify-content-between flex-wrap gap-3 bg-white rounded-2 px-4 py-0 mb-6">
<div class="text-end d-inline-flex align-items-center gap-3 flex-wrap">
<div class="select-filter d-inline-flex align-items-center gap-3">
<label class="fw-bold fs-xs text-dark flex-shrink-0">Sort by:</label>
<select class="form-select fs-xxs fw-medium theme-select select-sm" id="sort_by" onchange="changeUrl()">
<option value="relavent">Relavent</option>
<option value="price_desc">Price High to Low</option>
<option value="price_asc">Price Low to High</option>
<option value="name_asc">Name A to Z</option>
</select>
</div>
</div>
</div>
<div class="row g-4 justify-content-center">
<?php
$sql = "SELECT * FROM `product` WHERE status=1 ";
if (isset($_GET['search'])) {
$search = $_GET['search'];
$sql .= " AND pname LIKE '%$search%' ";
}
if (isset($_GET['category'])) {
$category = $_GET['category'];
$sql .= " AND category='$category' ";
}
if (isset($_GET['sort'])) {
switch ($_GET['sort']) {
case 'relavent':
$sort = 'id DESC';
break;
case 'price_desc':
$sort = 'offer_price DESC';
break;
case 'price_asc':
$sort = 'offer_price ASC';
break;
case 'name_asc':
$sort = 'pname ASC';
break;
default:
$sort = 'id'; // Default sorting
}
$sql .= " ORDER BY $sort ";
}
$cnt = mysqli_num_rows(mysqli_query($con, $sql));
?>
<span>Showing <?= $start_from + 1 ?> - <?= min($start_from + $per_page_record, $cnt) ?> of <?= $cnt ?> results</span>
<?php
$sql .= " LIMIT $start_from, $per_page_record";
$qr = mysqli_query($con, $sql);
while ($pr = mysqli_fetch_array($qr)) :
$defaultImage = "assets/img/favicon2.png";
$imagePath = $path . $pr['img1'];
if (!file_exists($imagePath) || empty($pr['img1'])) {
$imagePath = $defaultImage;
}
?>
<div class="col-lg-3 col-md-6 col-sm-10 col-6">
<div class="vertical-product-card rounded-2 position-relative bg-white">
<?php if ($pr['disc'] > 0) { ?>
<span class="offer-badge text-white fw-bold fs-xxs bg-danger position-absolute start-0 top-0"><?= $pr['disc'] ?>% Cashback</span>
<?php } ?>
<div class="thumbnail position-relative text-center p-4">
<a title="<?= $pr['pname'] . ' ' . $pr['quantity'] ?>" href="./product-details?id=<?= base64_encode($pr["id"]) ?>">
<img src="<?= $imagePath ?>" alt="<?= $pr['pname'] . ' ' . $pr['quantity'] ?>" class="img-fluid" style="height: 150px;">
</a>
<div class="product-btns position-absolute d-flex gap-2 flex-column">
<a href="#" class="rounded-btn"><i class="fa-regular fa-heart"></i></a>
</div>
</div>
<div class="card-content">
<div class="mb-2 tt-category tt-line-clamp tt-clamp-1">
<a href="#" class="d-inline-block text-muted fs-xxs"><?= $pr['category'] ?></a>
</div>
<a title="<?= $pr['pname'] . ' ' . $pr['quantity'] ?>" href="./product-details?id=<?= base64_encode($pr["id"]) ?>" class="card-title fw-bold d-block mb-2 tt-line-clamp tt-clamp-2"><?= substr($pr['pname'], 0, 14) . ' ' . $pr['quantity'] ?></a>
<h6 class="text-danger">₹ <?= $pr['offer_price'] ?></h6>
<div class="cart-buttons" id="cart-buttons-<?= $pr['id'] ?>" data-product-id="<?= $pr['id'] ?>">
<button style="width:100%" class="btn btn-primary d-block btn-md add-to-cart-button" data-product-id="<?= $pr['id'] ?>" data-product-name="<?= $pr['pname'] . ' - ' . $pr['quantity'] ?>" data-product-price="<?= $pr['offer_price'] ?>" data-product-img="<?= $path . $pr['img1'] ?>">Add to Cart</button>
</div>
</div>
</div>
</div>
<?php endwhile; ?>
</div>
<ul class="template-pagination d-flex align-items-center mt-6">
<?php
$total_pages = ceil($cnt / $per_page_record);
$url_params = $_GET;
unset($url_params['p']);
$base_url = strtok($_SERVER["REQUEST_URI"], '?');
$base_url .= '?' . http_build_query($url_params) . '&';
if ($total_pages > 1) {
$page = isset($_GET['p']) ? $_GET['p'] : 1;
echo '<li><a href="' . $base_url . 'p=' . max($page - 1, 1) . '"><i class="fas fa-angle-double-left"></i></a></li>';
for ($i = 1; $i <= $total_pages; $i++) {
if ($i == $page) {
echo '<li><a class="active" href="javascript:void">' . $i . '</a></li>';
} else {
echo '<li><a href="' . $base_url . 'p=' . $i . '">' . $i . '</a></li>';
}
}
echo '<li><a href="' . $base_url . 'p=' . min($page + 1, $total_pages) . '"><i class="fas fa-angle-double-right"></i></a></li>';
}
?>
</ul>
</div>
</div>
</div>
</div>
</section>
<!--shop grid section end-->
<?php include './footer.php'; ?>
<script>
function changeUrl() {
var selectElement = document.getElementById("sort_by");
var selectedValue = selectElement.options[selectElement.selectedIndex].value;
var currentUrl = window.location.href;
if (currentUrl.includes('sort=')) {
var newUrl = currentUrl.replace(/sort=[^&]*/, 'sort=' + selectedValue);
} else {
var separator = currentUrl.includes('?') ? '&' : '?';
var newUrl = currentUrl + separator + 'sort=' + selectedValue;
}
window.location.href = newUrl;
}
</script>
</body>
</html>