ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/blog.php |
<?php
session_start();
include 'connection/config.php';
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">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<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">
</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> / Blog </span>
</div>
</div>
<!-- breadcrumb-area end -->
<!-- main start -->
<main id="main">
<!-- blog-news start -->
<section class="blog-news section-ptb">
<div class="container">
<!-- blog-grid start -->
<div class="row row-mtm">
<?php
include 'connection/config.php';
// Pagination setup
$limit = 6; // Blogs per page
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
if ($page < 1) $page = 1;
$offset = ($page - 1) * $limit;
try {
// Count total blogs
$countStmt = $pdo->query("SELECT COUNT(*) FROM blog");
$total_blogs = $countStmt->fetchColumn();
$total_pages = ceil($total_blogs / $limit);
// Fetch limited blogs
$stmt = $pdo->prepare("SELECT * FROM blog ORDER BY id DESC LIMIT :limit OFFSET :offset");
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
while ($blog = $stmt->fetch(PDO::FETCH_ASSOC)) {
?>
<div class="col-12 col-md-6 col-lg-4" data-animate="animate__fadeIn">
<div class="blog-post banner-hover">
<div class="blog-main-img">
<a href="blog_details.php?slug=<?= htmlspecialchars($blog['slug']) ?>" class="d-block banner-img position-relative br-hidden">
<span class="banner-icon icon-16 position-absolute top-50 start-50 width-48 height-48 d-flex align-items-center justify-content-center extra-bg z-1 rounded-circle">
<i class="ri-links-line d-block lh-1"></i>
</span>
<img src="uploads/blog/<?= htmlspecialchars($blog['image']) ?>" class="w-100 img-fluid" alt="blog image" style="height:230px; object-fit:cover;">
</a>
</div>
<div class="blog-post-content pst-26">
<span class="d-inline-block meb-12 mt-4"><?= htmlspecialchars($blog['publish_date']) ?></span>
<h6 class="font-18">
<a href="blog_details.php?slug=<?= htmlspecialchars($blog['slug']) ?>" class="d-inline-block dominant-link">
<?= htmlspecialchars($blog['title']) ?>
</a>
</h6>
</div>
</div>
</div>
<?php
} // end while
} catch (PDOException $e) {
echo "<div class='col-12'><p>Error: " . $e->getMessage() . "</p></div>";
}
?>
</div>
<!-- blog-grid end -->
<!-- pagination start -->
<?php if ($total_pages > 1): ?>
<div class="paginatoin-area section-pt" data-animate="animate__fadeIn">
<nav aria-label="Page navigation">
<ul class="pagination ul-mt5 align-items-center justify-content-center pagination-box">
<!-- First -->
<li class="page-item <?= ($page <= 1) ? 'disabled' : '' ?>">
<a href="?page=1" class="page-link p-0 m-0 bg-transparent heading-weight border-0 lh-1">First</a>
</li>
<!-- Previous -->
<li class="page-item <?= ($page <= 1) ? 'disabled' : '' ?>">
<a href="?page=<?= max(1, $page - 1) ?>" class="page-link icon-16 d-flex align-items-center justify-content-center p-0 m-0 bg-transparent heading-weight border-0 border-radius">
<i class="ri-arrow-left-line d-block lh-1"></i>
</a>
</li>
<!-- Dynamic page numbers (max 5 visible) -->
<?php
$visible_links = 5;
$half = floor($visible_links / 2);
$start = max(1, $page - $half);
$end = min($total_pages, $start + $visible_links - 1);
if ($end - $start < $visible_links - 1) {
$start = max(1, $end - $visible_links + 1);
}
for ($i = $start; $i <= $end; $i++):
?>
<li class="page-item <?= ($i == $page) ? 'active' : '' ?>">
<a href="?page=<?= $i ?>" class="page-link d-flex align-items-center justify-content-center p-0 m-0 heading-weight border-0 border-radius lh-1">
<?= $i ?>
</a>
</li>
<?php endfor; ?>
<!-- Next -->
<li class="page-item <?= ($page >= $total_pages) ? 'disabled' : '' ?>">
<a href="?page=<?= min($total_pages, $page + 1) ?>" class="page-link icon-16 d-flex align-items-center justify-content-center p-0 m-0 bg-transparent heading-weight border-0 border-radius">
<i class="ri-arrow-right-line d-block lh-1"></i>
</a>
</li>
<!-- Last -->
<li class="page-item <?= ($page >= $total_pages) ? 'disabled' : '' ?>">
<a href="?page=<?= $total_pages ?>" class="page-link p-0 m-0 bg-transparent heading-weight border-0 lh-1">Last</a>
</li>
</ul>
</nav>
</div>
<?php endif; ?>
<!-- pagination end -->
</div>
</section>
<!-- blog-news end -->
</main>
<!-- main end -->
<?php include "common/footer.php"; ?>
........