query("SELECT * FROM hero_slides WHERE is_active = 1 ORDER BY sort_order ASC, created_at DESC");
$heroSlides = $stmtHero->fetchAll(PDO::FETCH_ASSOC);
// ── Fetch Promise Bar ──
$stmtPromise = $pdo->query("SELECT * FROM promise_bar WHERE is_active = 1 ORDER BY sort_order ASC, created_at DESC");
$promiseBar = $stmtPromise->fetchAll(PDO::FETCH_ASSOC);
// ── Fetch Editorial Banner ──
$stmtEd = $pdo->query("SELECT * FROM editorial_banner WHERE is_active = 1 LIMIT 1");
$editorialBanner = $stmtEd->fetch(PDO::FETCH_ASSOC);
// ── Fetch Video Reel ──
$stmtVid = $pdo->query("SELECT * FROM video_reel WHERE is_active = 1 ORDER BY sort_order ASC, created_at DESC");
$videoReels = $stmtVid->fetchAll(PDO::FETCH_ASSOC);
// ── Fetch categories with their first product image ──
$stmtCats = $pdo->query("
SELECT c.*,
(SELECT p.design_swatches FROM products p WHERE FIND_IN_SET(c.id, p.category_id) AND p.is_active = 1 LIMIT 1) AS sample_swatch
FROM categories c
ORDER BY c.sort_order, c.name
");
$homeCategories = $stmtCats->fetchAll(PDO::FETCH_ASSOC);
// ── Fetch New Arrivals (latest 8 active products) ──
$stmtNew = $pdo->query("
SELECT p.*, c.name AS category_name
FROM products p
LEFT JOIN categories c ON c.id = CAST(SUBSTRING_INDEX(p.category_id, ',', 1) AS UNSIGNED)
WHERE p.is_active = 1
ORDER BY p.created_at DESC
LIMIT 8
");
$newArrivals = $stmtNew->fetchAll(PDO::FETCH_ASSOC);
// ── Fetch Best Sellers (products with badge or fallback) ──
$stmtBest = $pdo->prepare("
SELECT p.*, c.name AS category_name
FROM products p
LEFT JOIN categories c ON c.id = CAST(SUBSTRING_INDEX(p.category_id, ',', 1) AS UNSIGNED)
WHERE p.is_active = 1
ORDER BY RAND()
LIMIT 8
");
$stmtBest->execute();
$bestSellers = $stmtBest->fetchAll(PDO::FETCH_ASSOC);
// Helper: get first swatch image from product
function getProductImage($product, $index = 0) {
$swatches = json_decode($product['design_swatches'] ?? '[]', true);
if (empty($swatches)) return 'assets/placeholder-product.jpg';
// Support refined structure: thumb or gallery
$sw = $swatches[0]; // Primary swatch
if ($index > 0 && !empty($sw['gallery']) && isset($sw['gallery'][$index-1])) {
return $sw['gallery'][$index-1]; // Hover image from gallery
}
if (!empty($sw['thumb'])) return $sw['thumb'];
if (!empty($sw['src'])) return $sw['src']; // Old format fallback
if (!empty($sw['gallery'])) return $sw['gallery'][0];
return 'assets/placeholder-product.jpg';
}
function getProductVideo($product) {
$swatches = json_decode($product['design_swatches'] ?? '[]', true);
if (empty($swatches)) return '';
$sw = $swatches[0];
if (!empty($sw['videos'][0])) return $sw['videos'][0];
return '';
}
function getCategoryImage($cat) {
if (!empty($cat['image'])) {
return 'assets/uploads/categories/' . $cat['image'];
}
$swatches = json_decode($cat['sample_swatch'] ?? '[]', true);
if (empty($swatches)) return 'assets/placeholder-product.jpg';
$sw = $swatches[0];
if (!empty($sw['thumb'])) return $sw['thumb'];
if (!empty($sw['src'])) return $sw['src'];
if (!empty($sw['gallery'])) return $sw['gallery'][0];
return 'assets/placeholder-product.jpg';
}
?>
Elegance of India — South Asian Luxury Fashion
$slide): ?>
1): ?>
$slide): ?>
Collections
Explore By Category
Discover our curated world of South Asian luxury fashion