<?php include"connection/config.php"; ?>
<style>
.gold-rate-menu {
min-width: 230px;
background: #fff;
border: none;
border-radius: 12px;
box-shadow: 0 8px 25px rgba(0, 0, 0, 0.1);
padding: 15px 20px;
}
/* Title */
.gold-rate-menu .title {
font-size: 16px;
color: #222;
font-weight: 600;
letter-spacing: 0.5px;
}
/* Divider */
.gold-rate-menu .divider {
margin: 10px 0;
border-top: 1px solid #eee;
}
/* Rate Rows */
.gold-rate-menu .rate-line {
display: flex;
justify-content: space-between;
align-items: center;
font-size: 15px;
padding: 6px 0;
color: #333;
}
.gold-rate-menu .rate-line strong {
color: #101010ff; /* subtle gold tone */
font-weight: 600;
}
/* Updated Time */
.gold-rate-menu .updated {
font-size: 13px;
color: #777;
margin-top: 10px;
line-height: 1.4;
}
/* Hover dropdown effect (optional, for nav use) */
.nav-item.dropdown:hover .dropdown-menu {
display: block;
}
</style>
<!-- header-menu start -->
<div class="col-xl-8 d-none d-xl-block header-element header-menu">
<div class="mainmenu-content">
<div class="main-wrap d-flex justify-content-center">
<ul class="menu-ul d-flex flex-wrap">
<li class="menu-li">
<a href="index.php" class="menu-link font-16 d-flex align-items-center plr-15">
<span class="menu-title text-uppercase heading-weight">Home</span>
</a>
</li>
<?php
include 'connection/config.php';
error_reporting(E_ALL);
ini_set('display_errors', 1);
try {
// ✅ Fetch Gold Categories
$stmtGold = $pdo->prepare("
SELECT mc.*, pc.name AS category_name, pg.gender_name
FROM main_categories mc
JOIN product_categories pc ON mc.category_id = pc.id
JOIN products_gender pg ON mc.gender_id = pg.id
WHERE pc.id = 1
ORDER BY mc.id ASC
");
$stmtGold->execute();
$goldCategories = $stmtGold->fetchAll(PDO::FETCH_ASSOC);
// ✅ Fetch Silver Categories
$stmtSilver = $pdo->prepare("
SELECT mc.*, pc.name AS category_name, pg.gender_name
FROM main_categories mc
JOIN product_categories pc ON mc.category_id = pc.id
JOIN products_gender pg ON mc.gender_id = pg.id
WHERE pc.id = 2
ORDER BY mc.id ASC
");
$stmtSilver->execute();
$silverCategories = $stmtSilver->fetchAll(PDO::FETCH_ASSOC);
// ✅ Fetch francy Categories
$stmtFrancy = $pdo->prepare("
SELECT mc.*, pc.name AS category_name, pg.gender_name
FROM main_categories mc
JOIN product_categories pc ON mc.category_id = pc.id
JOIN products_gender pg ON mc.gender_id = pg.id
WHERE pc.id = 3
ORDER BY mc.id ASC
");
$stmtFrancy->execute();
$francyCategories = $stmtFrancy->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
die("Database connection failed: " . $e->getMessage());
}
?>
<!-- ✅ Gold Category Menu -->
<li class="menu-li">
<a href="product_category.php?slug=gold" class="menu-link font-16 d-flex align-items-center plr-15">
<span class="menu-title text-uppercase heading-weight">Gold</span>
<span class="icon-16 fw-normal"><i class="ri-arrow-down-s-line d-block lh-1"></i></span>
</a>
<div class="menu-dropdown menu-mega collapse position-absolute top-auto start-0 end-0 extra-bg z-2 DropDownSlide box-shadow">
<div class="container ptb-25">
<div class="menu-overview heading-color ptb-5 text-uppercase heading-weight">
<?php if (!empty($goldCategories)): ?>
<?php foreach ($goldCategories as $cat): ?>
<?php
// 🔹 Fetch subcategories for this main category
$stmtSub = $pdo->prepare("SELECT id FROM sub_categories WHERE main_category_id = ?");
$stmtSub->execute([$cat['id']]);
$subCategories = $stmtSub->fetchAll(PDO::FETCH_COLUMN);
// 🔹 Convert to comma-separated string
$subIds = $subCategories ? implode(",", $subCategories) : "";
?>
<span class="d-block ptb-5">
<a href="category_details.php?slug=<?= urlencode($cat['category_name']); ?>&main=<?= urlencode($cat['id']); ?>&sub=<?= urlencode($subIds); ?>"
class="d-inline-block body-dominant-color">
<?= htmlspecialchars($cat['name']) ?>
</a>
</span>
<?php endforeach; ?>
<?php else: ?>
<span class="d-block ptb-5">
<a href="#" class="d-inline-block body-dominant-color">No Gold Categories Found</a>
</span>
<?php endif; ?>
</div>
</div>
</div>
</li>
<!-- ✅ Silver Category Menu -->
<li class="menu-li">
<a href="product_category.php?slug=silver" class="menu-link font-16 d-flex align-items-center plr-15">
<span class="menu-title text-uppercase heading-weight">Silver</span>
<span class="icon-16 fw-normal"><i class="ri-arrow-down-s-line d-block lh-1"></i></span>
</a>
<div class="menu-dropdown menu-mega collapse position-absolute top-auto start-0 end-0 extra-bg z-2 DropDownSlide box-shadow">
<div class="container ptb-25">
<div class="menu-overview heading-color ptb-5 text-uppercase heading-weight">
<?php if (!empty($silverCategories)): ?>
<?php foreach ($silverCategories as $cat): ?>
<?php
// 🔹 Fetch subcategories for this main category
$stmtSub = $pdo->prepare("SELECT id FROM sub_categories WHERE main_category_id = ?");
$stmtSub->execute([$cat['id']]);
$subCategories = $stmtSub->fetchAll(PDO::FETCH_COLUMN);
// 🔹 Convert to comma-separated string
$subIds = $subCategories ? implode(",", $subCategories) : "";
?>
<span class="d-block ptb-5">
<a href="category_details.php?slug=<?= urlencode($cat['category_name']); ?>&main=<?= urlencode($cat['id']); ?>&sub=<?= urlencode($subIds); ?>"
class="d-inline-block body-dominant-color">
<?= htmlspecialchars($cat['name']) ?>
</a>
</span>
<?php endforeach; ?>
<?php else: ?>
<span class="d-block ptb-5">
<a href="#" class="d-inline-block body-dominant-color">No Silver Categories Found</a>
</span>
<?php endif; ?>
</div>
</div>
</div>
</li>
<!-- ✅ Fancy Category Menu -->
<li class="menu-li">
<a href="product_category.php?slug=Fancy Jewellery" class="menu-link font-16 d-flex align-items-center plr-15">
<span class="menu-title text-uppercase heading-weight">Fancy</span>
<span class="icon-16 fw-normal"><i class="ri-arrow-down-s-line d-block lh-1"></i></span>
</a>
<div class="menu-dropdown menu-mega collapse position-absolute top-auto start-0 end-0 extra-bg z-2 DropDownSlide box-shadow">
<div class="container ptb-25">
<div class="menu-overview heading-color ptb-5 text-uppercase heading-weight">
<?php if (!empty($francyCategories)): ?>
<?php foreach ($francyCategories as $cat): ?>
<?php
// 🔹 Fetch subcategories for this main category
$stmtSub = $pdo->prepare("SELECT id FROM sub_categories WHERE main_category_id = ?");
$stmtSub->execute([$cat['id']]);
$subCategories = $stmtSub->fetchAll(PDO::FETCH_COLUMN);
// 🔹 Convert to comma-separated string
$subIds = $subCategories ? implode(",", $subCategories) : "";
?>
<span class="d-block ptb-5">
<a href="category_details.php?slug=<?= urlencode($cat['category_name']); ?>&main=<?= urlencode($cat['id']); ?>&sub=<?= urlencode($subIds); ?>"
class="d-inline-block body-dominant-color">
<?= htmlspecialchars($cat['name']) ?>
</a>
</span>
<?php endforeach; ?>
<?php else: ?>
<span class="d-block ptb-5">
<a href="#" class="d-inline-block body-dominant-color">No Fancy Categories Found</a>
</span>
<?php endif; ?>
</div>
</div>
</div>
</li>
<!-- ✅ Fancy Category Menu -->
<li class="menu-li">
<a href="product_category.php?slug=Fancy Jewellery" class="menu-link font-16 d-flex align-items-center plr-15">
<span class="menu-title text-uppercase heading-weight">Rental</span>
<span class="icon-16 fw-normal"><i class="ri-arrow-down-s-line d-block lh-1"></i></span>
</a>
<div class="menu-dropdown menu-mega collapse position-absolute top-auto start-0 end-0 extra-bg z-2 DropDownSlide box-shadow">
<div class="container ptb-25">
<div class="menu-overview heading-color ptb-5 text-uppercase heading-weight">
<?php if (!empty($francyCategories)): ?>
<?php foreach ($francyCategories as $cat): ?>
<?php
// 🔹 Fetch subcategories for this main category
$stmtSub = $pdo->prepare("SELECT id FROM sub_categories WHERE main_category_id = ?");
$stmtSub->execute([$cat['id']]);
$subCategories = $stmtSub->fetchAll(PDO::FETCH_COLUMN);
// 🔹 Convert to comma-separated string
$subIds = $subCategories ? implode(",", $subCategories) : "";
?>
<span class="d-block ptb-5">
<a href="category_details.php?slug=<?= urlencode($cat['category_name']); ?>&main=<?= urlencode($cat['id']); ?>&sub=<?= urlencode($subIds); ?>"
class="d-inline-block body-dominant-color">
<?= htmlspecialchars($cat['name']) ?>
</a>
</span>
<?php endforeach; ?>
<?php else: ?>
<span class="d-block ptb-5">
<a href="#" class="d-inline-block body-dominant-color">No Fancy Categories Found</a>
</span>
<?php endif; ?>
</div>
</div>
</div>
</li>
<li class="menu-li">
<a href="store.php" class="menu-link font-16 d-flex align-items-center plr-15">
<span class="menu-title text-uppercase heading-weight">Our Store</span>
</a>
</li>
<li class="nav-item dropdown menu-li">
<a href="#" class="nav-link dropdown-toggle font-16 d-flex align-items-center plr-15 text-dark"
id="goldRateDropdown" role="button" aria-expanded="false">
<span class="menu-title text-uppercase heading-weight">Gold Rate</span>
</a>
<?php
include 'connection/config.php';
// ---------- Fetch 24K gold rate ----------
$stmt = $pdo->query("SELECT * FROM gold_rates WHERE purity='24KT' LIMIT 1");
$rate_24k = $stmt->fetch();
// Karat ratios
$karat_ratios = [
'24 KT' => 1,
'22 KT' => 22 / 24,
'18 KT' => 18 / 24,
'14 KT' => 14 / 24,
'9 KT' => 9 / 24
];
// Format for date/time
$updated_date = !empty($rate_24k['effective_date']) ? date('d/m/Y', strtotime($rate_24k['effective_date'])) : '';
$updated_time = !empty($rate_24k['effective_date']) ? date('h:i A', strtotime($rate_24k['effective_date'])) : '';
?>
<!-- Gold Rate Dropdown Menu -->
<ul class="dropdown-menu gold-rate-menu" aria-labelledby="goldRateDropdown">
<li class="text-center">
<strong class="title">Today's Gold Rate (10gm)</strong>
</li>
<li><hr class="divider"></li>
<?php if (!empty($rate_24k)): ?>
<?php foreach ($karat_ratios as $kt => $ratio):
$price_10gm = round($rate_24k['price_per_gram'] * $ratio * 10); // 10gm price
?>
<li class="rate-line">
<span><?= $kt ?><?php if($kt=='22 KT') echo ' (916)'; elseif($kt=='18 KT') echo ' (750)'; elseif($kt=='14 KT') echo ' (585)'; ?></span> -
<strong>₹ <?= number_format($price_10gm) ?> /10g</strong>
</li>
<?php endforeach; ?>
<li class="updated text-center">
Updated on:<br>
<strong><?= $updated_date ?> — <?= $updated_time ?></strong>
</li>
<?php else: ?>
<li class="text-center text-danger">24K rate not set yet</li>
<?php endif; ?>
</ul>
</li>
</ul>
</div>
</div>
</div>
<!-- header-menu end -->