ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/product_category.php |
<?php
session_start();
include"cart-handler.php";
$customer_id = isset($_SESSION['customer_id']) ? intval($_SESSION['customer_id']) : 0;
// Fetch allorders for the customer
$stmt = $pdo->prepare("SELECT * FROM allorders WHERE customer_id = :customer_id ORDER BY created_at DESC");
$stmt->execute([':customer_id' => $customer_id]);
$allorders = $stmt->fetchAll();
$stmt = $pdo->prepare("SELECT * FROM store_locations");
$stmt->execute();
$store_locations = $stmt->fetch(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="en">
<!-- Mirrored from spacingtech.com/html/veppo/template/index3.php by HTTrack Website Copier/3.x [XR&CO'2014], Fri, 18 Jul 2025 06:27:32 GMT -->
<!-- Added by HTTrack --><meta http-equiv="content-type" content="text/html;charset=UTF-8" /><!-- /Added by HTTrack -->
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>Pooja Jewellers Bhubaneswar – Elegant Gold, Silver & Fancy Jewellery</title>
<meta name="description" content="Browse Pooja Jewellers in Bhubaneswar for a stunning range of gold, silver, and fancy jewellery—perfect for weddings, everyday elegance, and modern minimalism.">
<meta name="keywords" content="Pooja Jewellers Bhubaneswar, gold jewellery Bhubaneswar, silver jewellery Bhubaneswar, fancy jewellery Bhubaneswar, minimalist jewellery India, wedding jewellery Bhubaneswar">
<meta name="author" content="spacingtech_webify">
<!-- favicon -->
<link rel="shortcut icon" type="image/favicon" href="assets/image/fav.jpg">
<!-- plugin css -->
<link rel="stylesheet" type="text/css" href="assets/css/plugin.css">
<!-- theme css -->
<link rel="stylesheet" type="text/css" href="assets/css/theme3.css">
<!-- collection css -->
<link rel="stylesheet" type="text/css" href="assets/css/collection3.css">
<!-- blog css -->
<link rel="stylesheet" type="text/css" href="assets/css/blog3.css">
<!-- style css -->
<link rel="stylesheet" type="text/css" href="assets/css/style3.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.css">
</head>
<body>
<!-- preloader start -->
<div class="preloader position-fixed top-0 start-0 w-100 h-100 body-bg z-index-5">
<div class="loader-img position-absolute top-0 start-0 w-100 h-100 d-flex align-items-center justify-content-center">
<img src="assets/image/preloader.png" class="width-96 width-xl-144 img-fluid" alt="logo">
</div>
</div>
<!-- preloader end -->
<!-- header start -->
<header id="header" class="main-header">
<!-- header-top start -->
<div class="header-top-area">
<!-- notification-bar start -->
<div class="notification-bar ptb-10 dominant-bg">
<div class="container-fluid d-none d-xl-block">
<div class="text-center extra-color">First Order 20% Off on Fancy Jewellery <a href="product_category.php?slug=Fancy jewellery" class="extra-color text-uppercase text-decoration-underline blinking">Shop now</a>!</div>
</div>
</div>
<!-- notification-bar end -->
<!-- header-bar start -->
<div class="header-bar d-none d-xl-block ptb-11 extra-bg beb">
<div class="container-fluid">
<div class="row">
<div class="col">
<ul class="ul-mt30 justify-content-start">
<li>
<span class="d-inline-block body-secondary-color">
<a href="mailto:<?php echo $store_locations['email1']; ?>">
<i class="ri-mail-line icon-16 mer-5"></i><?php echo $store_locations['email1']; ?>
</a>
</span>
</li>
<li>
<span class="d-inline-block body-secondary-color">
<a href="tel:<?php echo $store_locations['phone1']; ?>">
<i class="ri-phone-line icon-16 mer-5"></i><?php echo $store_locations['phone1']; ?>
</a>
</span>
</li>
</ul>
</div>
<div class="col">
<ul class="ul-mt30 justify-content-end">
<li>
<span class="d-inline-block body-secondary-color">
<a href="calender.php">
<i class="ri-calendar-event-fill icon-16 mer-5"></i>Calender
</a>
</span>
</li>
<li>
<span class="d-inline-block body-secondary-color text-dark">
<a href="javascript:void(0)"
data-bs-toggle="modal"
data-bs-target="#goldCalculatorModal"
class="nav-link">
<i class="ri-calculator-line icon-16 mer-5"></i> Calculator
</a>
</span>
</li>
</ul>
</div>
</div>
</div>
</div>
<!-- header-bar end -->
<!-- header-top-first start -->
<div class="header-top-first ptb-15 ptb-xl-20 position-relative extra-bg">
<div class="container-fluid">
<div class="row align-items-center header-area">
<!-- header-logo start -->
<div class="col-6 col-xl-2 header-element header-logo">
<div class="header-theme-logo">
<a href="index.php" class="d-inline-block theme-logo">
<img src="assets/image/headerlogo.webp" class="width-96 width-xl-144 img-fluid" alt="logo">
</a>
</div>
</div>
<!-- header-logo end -->
<?php include "common/header.php"; ?>
<!-- header-icon start -->
<div class="col-6 col-xl-2 header-element header-icon">
<div class="header-icon-block d-flex justify-content-end">
<ul class="ul-mt30 flex-nowrap align-items-center header-icon-element">
<li class="header-icon-wrap toggler-wrap d-xl-none">
<div class="header-icon-wrapper">
<a href="javascript:void(0)" class="d-block header-icon-toggler toggler-btn" aria-label="Menu toggler button">
<span class="d-block header-block-icon dominant-link icon-16"><i class="ri-menu-line"></i></span>
</a>
</div>
</li>
<li class="header-icon-wrap search-wrap d-xl-none">
<div class="header-icon-wrapper">
<a href="#searchmodal" class="d-block header-icon-search" data-bs-toggle="modal" aria-label="Search modal">
<span class="d-block header-block-icon dominant-link icon-16"><i class="ri-search-line"></i></span>
</a>
</div>
</li>
<li class="header-icon-wrap user-wrap d-none d-md-block">
<div class="header-icon-wrapper">
<span class="header-block-icon-wrap dominant-link ul-mt5 flex-nowrap align-items-center">
<span class="header-block-icon icon-16"><i class="ri-user-3-line"></i></span>
<span class="d-none d-xl-block header-text-content">
<?php if ($customerName): ?>
<a href="dashboard.php"><b><?= htmlspecialchars($customerName) ?></b></a>
<?php else: ?>
<a href="login.php">Login</a>
<?php endif; ?>
</span>
</span>
</div>
</li>
<li class="header-icon-wrap cart-wrap d-none d-md-block">
<div class="header-icon-wrapper">
<a href="javascript:void(0)" class="d-block header-icon-cart js-cart-drawer">
<span class="header-block-icon-wrap dominant-link ul-mt5 flex-nowrap align-items-center">
<span class="header-block-icon icon-16"><i class="ri-shopping-bag-3-line"></i></span>
<span class="d-none d-xl-block header-text-content">Cart</span>
<?php
$cartCount = 0;
if (isset($_SESSION['cart'])) {
$cartCount += count($_SESSION['cart']);
}
if (isset($_SESSION['rentals'])) {
$cartCount += count($_SESSION['rentals']);
}
// Show the counter only if there’s something in cart
if ($cartCount > 0) {
echo '<span class="header-block-counter cart-counter dominant-color">' . $cartCount . '</span>';
}
?>
</span>
</a>
</div>
</li>
</ul>
</div>
</div>
<!-- header-icon end -->
</div>
</div>
</div>
<!-- header-top-first end -->
</div>
<!-- header-top end -->
</header>
<!-- header end -->
<!-- breadcrumb-area start -->
<div class="breadcrumb-area ptb-15" data-bgimg="assets/image/other/breadcrumb-bgimg.jpg">
<div class="container">
<span class="d-block extra-color"><a href="index.php" class="extra-color">Home</a> / <?php $slug = isset($_GET['slug']) ? $_GET['slug'] : ''; ?></span>
</div>
</div>
<!-- breadcrumb-area end -->
<!-- main start -->
<main id="main">
<!-- collections start -->
<div class="section-ptb">
<div class="container">
<div class="row row-mtm30">
<?php
include 'connection/config.php';
// Get slug & page number
$slug = isset($_GET['slug']) ? $_GET['slug'] : '';
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$limit = 8; // ✅ Show 8 products per page
$offset = ($page - 1) * $limit;
if ($slug) {
// Get category id from slug
$stmt = $pdo->prepare("SELECT id FROM product_categories WHERE LOWER(name) = LOWER(?)");
$stmt->execute([$slug]);
$productCategory = $stmt->fetch(PDO::FETCH_ASSOC);
if ($productCategory) {
$categoryId = $productCategory['id'];
// ✅ Count total main categories for pagination
$stmt = $pdo->prepare("SELECT COUNT(*) FROM main_categories WHERE category_id = ?");
$stmt->execute([$categoryId]);
$totalProducts = $stmt->fetchColumn();
$totalPages = ceil($totalProducts / $limit);
// ✅ Fetch paginated results (8 per page)
$stmt = $pdo->prepare("SELECT * FROM main_categories WHERE category_id = ? LIMIT $limit OFFSET $offset");
$stmt->execute([$categoryId]);
$mainCategories = $stmt->fetchAll(PDO::FETCH_ASSOC);
if ($mainCategories) {
foreach ($mainCategories as $cat) {
// Fetch subcategories for each main category
$stmtSub = $pdo->prepare("SELECT id FROM sub_categories WHERE main_category_id = ?");
$stmtSub->execute([$cat['id']]);
$subCategories = $stmtSub->fetchAll(PDO::FETCH_COLUMN);
$subIds = $subCategories ? implode(",", $subCategories) : "";
?>
<div class="col-6 col-md-4 col-xl-3" data-animate="animate__fadeIn">
<div class="collection-block text-center">
<div class="collection-img position-relative extra-bg br-hidden">
<img src="<?= htmlspecialchars($cat['image']); ?>" class="w-100 img-fluid" alt="<?= htmlspecialchars($cat['name']); ?>">
</div>
<div class="collection-content">
<a href="category_details.php?slug=<?= urlencode($slug) ?>&main=<?= urlencode($cat['id']); ?>&sub=<?= urlencode($subIds); ?>"
class="d-block w-100 secondary-btn ptb-10 plr-15 extra-bg text-truncate text-uppercase heading-weight border-radius">
<?= htmlspecialchars($cat['name']); ?>
</a>
</div>
</div>
</div>
<?php
}
} else {
echo "<p>No main categories found for " . htmlspecialchars($slug) . "</p>";
}
// ✅ Pagination Section
if ($totalPages > 1) {
echo '<div class="paginatoin-area section-pt" data-animate="animate__fadeIn">
<nav aria-label="Page navigation example">
<ul class="pagination ul-mt5 align-items-center justify-content-center pagination-box">';
// First
echo '<li class="page-item first">
<a href="?slug=' . urlencode($slug) . '&page=1" class="page-link">First</a>
</li>';
// Previous
$prevPage = ($page > 1) ? $page - 1 : 1;
echo '<li class="page-item prev">
<a href="?slug=' . urlencode($slug) . '&page=' . $prevPage . '" class="page-link">
<i class="ri-arrow-left-line d-block lh-1"></i>
</a>
</li>';
// Page numbers
for ($i = 1; $i <= $totalPages; $i++) {
$active = ($i == $page) ? 'active' : '';
echo '<li class="page-item">
<a href="?slug=' . urlencode($slug) . '&page=' . $i . '" class="page-link ' . $active . '">' . $i . '</a>
</li>';
}
// Next
$nextPage = ($page < $totalPages) ? $page + 1 : $totalPages;
echo '<li class="page-item next">
<a href="?slug=' . urlencode($slug) . '&page=' . $nextPage . '" class="page-link">
<i class="ri-arrow-right-line d-block lh-1"></i>
</a>
</li>';
// Last
echo '<li class="page-item last">
<a href="?slug=' . urlencode($slug) . '&page=' . $totalPages . '" class="page-link">Last</a>
</li>';
echo '</ul></nav></div>';
}
} else {
echo "<p>Invalid category slug.</p>";
}
}
?>
</div>
</div>
</div>
<!-- collections end -->
</main>
<!-- main end -->
<?php include "common/footer.php"; ?>
........