bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

halohalo bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

<?php
$pageTitle = 'STANJO | Modern LED Lighting Solutions';

$extraHead = '
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/swiper@11/swiper-bundle.min.css" />
<script src="https://cdn.jsdelivr.net/npm/swiper@11/swiper-bundle.min.js"></script>
<style>
    .gallery-card {
        height: 420px;
        border-radius: 0;
        overflow: hidden;
        transition: 0.4s;
    }
    .gallery-card img {
        width: 100%;
        height: 100%;
        object-fit: cover;
        transition: 0.6s;
    }
    .gallery-card:hover img {
        transform: scale(1.1);
    }
    .swiper-slide-active .gallery-card {
        transform: scale(1.0);
    }
    .swiper-pagination-bullet {
        background: #fff !important;
        opacity: 0.3;
    }
    .swiper-pagination-bullet-active {
        background: #FFD700 !important; /* Stanjo Yellow */
        opacity: 1;
    }
</style>';

$extraFooterScripts = '
<script>
    var testimonialSwiper = new Swiper(".mySwiper", {
        slidesPerView: 1,
        centeredSlides: true,
        loop: true,
        spaceBetween: 20,
        autoplay: {
            delay: 2500,
            disableOnInteraction: false,
        },
        breakpoints: {
            768: {
                slidesPerView: 2,
                spaceBetween: 30,
            },
            1024: {
                slidesPerView: 3,
                spaceBetween: 30,
            }
        }
    });

var gallerySwiper = new Swiper(".gallerySwiper", {
        slidesPerView: 1,
        spaceBetween: 10,
        loop: true,
        autoplay: {
            delay: 3000,
            disableOnInteraction: false,
        },
        breakpoints: {
            640: {
                slidesPerView: 2,
                spaceBetween: 20,
            },
            1024: {
                slidesPerView: 4,
                spaceBetween: 30,
            },
            1280: {
                slidesPerView: 5,
                spaceBetween: 30,
            }
        },
        pagination: {
            el: ".swiper-pagination",
            clickable: true,
        },
    });
</script>';

include 'header.php';
?>

<main>
    
    <?php
    $bannerRes = null;
    $checkTable = mysqli_query($conn, "SHOW TABLES LIKE 'hero_banner'");
    if (mysqli_num_rows($checkTable) > 0) {
        $bannerRes = mysqli_query($conn, "SELECT * FROM hero_banner WHERE status = 1 ORDER BY id DESC LIMIT 1");
    }

if ($bannerRes && mysqli_num_rows($bannerRes) > 0) {
        $banner = mysqli_fetch_assoc($bannerRes);
        ?>
        <section class="relative h-[65vh] md:h-screen flex items-center justify-center overflow-hidden">
            
            <?php if ($banner['banner_type'] == 'video'): ?>
                <video autoplay muted loop playsinline class="absolute inset-0 w-full h-full object-cover scale-[1.03]">
                    <source src="admin/uploads/<?php echo $banner['file_path']; ?>" type="video/mp4">
                </video>
            <?php else: ?>
                <img src="admin/uploads/<?php echo $banner['file_path']; ?>"
                    class="absolute inset-0 w-full h-full object-cover">
            <?php endif; ?>

<div class="relative z-10 container-custom text-center px-4">
                <span class="text-white text-l md:text-3xl font-extralight mb-3 md:mb-5 block">
                    <?php echo htmlspecialchars($banner['subtitle']); ?>
                </span>

<?php if (!empty($banner['button_text'])): ?>
                    <div class="flex justify-center mt-6">
                        <div class="inline-block p-1">
                            <a href="<?php echo !empty($banner['button_link']) ? $banner['button_link'] : 'shop.php'; ?>"
                                class="px-8 py-3 border border-white text-white font-light tracking-[4px] uppercase text-xs hover:bg-[#333] hover:text-white transition-all block">
                                <?php echo htmlspecialchars($banner['button_text']); ?>
                            </a>
                        </div>
                    </div>
                <?php endif; ?>
            </div>
        </section>
    <?php } else { ?>
        
        <section class="relative h-[65vh] md:h-screen flex items-center justify-center overflow-hidden">
            <video autoplay muted loop playsinline class="absolute inset-0 w-full h-full object-cover scale-[1.03]">
                <source src="assets/videos/hero.mp4" type="video/mp4">
            </video>
            <div class="relative z-10 container-custom text-center px-4">
                <span class="text-white text-l md:text-3xl font-extralight mb-3 md:mb-5 block">
                    Upgrade your Space With
                </span>
                <h1
                    class="text-xl sm:text-2xl md:text-3xl lg:text-4xl font-extralight uppercase tracking-[1px] md:tracking-[6px] leading-tight text-white font-heading">
                    Modern LED <br class="md:hidden"> Lighting
                </h1>
                <div class="flex justify-center mt-6">
                    <div class="inline-block p-1">
                        <a href="shop.php"
                            class="px-8 py-3 border border-white text-white font-light tracking-[4px] uppercase text-xs hover:bg-[#333] hover:text-white transition-all block">
                            View Our Products
                        </a>
                    </div>
                </div>
            </div>
        </section>
    <?php } ?>

<?php
    $catQuery = "SELECT id, title, slug, image 
             FROM categories 
             WHERE status = 1 AND image IS NOT NULL AND image != '' 
             ORDER BY id DESC 
             LIMIT 8";

$catResult = mysqli_query($conn, $catQuery);
    ?>

<h2 class="text-[16px] md:text-[26px] font-extralight mb-3">
                About Us
            </h2>

<p class="text-stanjo-zinc text-[12px] md:text-[16px] font-light leading-relaxed max-w-xl">
                We provide expert Business Coaching to both individuals and businesses. With
                over 30 years of experience we’ll ensure that you’re always getting the best
                guidance from the top people in the entire industry.
            </p>

<div class="grid grid-cols-2 md:grid-cols-4 gap-8 mt-14">

<div>
                    <h3 class="text-4xl font-light counter" data-target="16">0</h3>
                    <p class="text-gray-500 text-[11px] tracking-widest mt-2">SPECIALISTS</p>
                </div>

<div>
                    <h3 class="text-4xl font-light counter" data-target="420">0</h3>
                    <p class="text-gray-500 text-[11px] tracking-widest mt-2">CLIENTS</p>
                </div>

<div>
                    <h3 class="text-4xl font-light counter" data-target="29">0</h3>
                    <p class="text-gray-500 text-[11px] tracking-widest mt-2">CASES</p>
                </div>

<div>
                    <h3 class="text-4xl font-light counter" data-target="40">0</h3>
                    <p class="text-gray-500 text-[11px] tracking-widest mt-2">AWARDS</p>
                </div>

</div>

</section>
    <script>
        document.addEventListener("DOMContentLoaded", function () {

const counters = document.querySelectorAll(".counter");
            let started = false;

function startCounting() {
                counters.forEach(counter => {
                    const target = +counter.getAttribute("data-target");
                    let count = 0;

const update = () => {
                        const increment = Math.ceil(target / 100);

if (count < target) {
                            count += increment;
                            counter.innerText = count > target ? target : count;
                            setTimeout(update, 20);
                        } else {
                            counter.innerText = target;
                        }
                    };

update();
                });
            }

function checkScroll() {
                const section = document.getElementById("counter-section");
                const position = section.getBoundingClientRect().top;
                const screenHeight = window.innerHeight;

if (!started && position < screenHeight - 100) {
                    startCounting();
                    started = true;
                }
            }

// Run on scroll
            window.addEventListener("scroll", checkScroll);

// ALSO run once in case already visible
            checkScroll();

});
    </script>
    
    <section class="py-8 bg-stanjo-bg">
        <div class="container-custom">

<div class="text-center mb-6 mx-auto flex flex-col items-center">

<h2 class="text-[16px] md:text-[26px] font-extralight tracking-[1px] text-white mb-2">
                    Our Products Categories
                </h2>

<p class="text-stanjo-zinc text-[12px] md:text-[16px] font-light leading-relaxed max-w-xl">
                    Bright, energy efficient LED bulbs delivering clear illumination, long life, reliable performance,
                    and comfortable lighting.
                </p>

</div>

<div class="grid grid-cols-2 lg:grid-cols-4 gap-3 md:gap-4">
                <?php if ($catResult && mysqli_num_rows($catResult) > 0) { ?>

<?php while ($cat = mysqli_fetch_assoc($catResult)) {
                        $image = (!empty($cat['image']) && file_exists('admin/uploads/' . $cat['image'])) 
                                 ? 'admin/uploads/' . $cat['image'] 
                                 : 'admin/uploads/default.png';
                        ?>

<div
                            class="group bg-black border border-[#333] text-center overflow-hidden hover:border-[#555] transition-all duration-300">

<div class="p-4 md:p-8 flex items-center justify-center h-[160px] md:h-[240px]">
                                <img src="<?php echo $image; ?>" loading="lazy"
                                    class="max-h-[120px] md:max-h-[180px] object-contain transition duration-500 group-hover:scale-110">
                            </div>

<h5 class="text-white text-[13px] md:text-[15px] font-light mb-3 md:mb-4 px-2">
                                <?php echo $cat['title']; ?>
                            </h5>

<div class="border-t border-[#333]">
                                <a href="shop.php?category=<?php echo $cat['slug']; ?>"
                                    class="text-gray-300 text-[11px] md:text-[12px] hover:bg-[#333] hover:text-white transition-all py-3 flex items-center justify-center w-full uppercase tracking-widest font-light">
                                    View More
                                </a>
                            </div>

</div>

<?php } ?>

<?php } else { ?>
                    <p class="text-gray-400 col-span-4 text-center">No categories found</p>
                <?php } ?>
            </div>

</div>
    </section>

<section class="relative h-[700px] flex items-start justify-center text-center text-white pt-10">

<div class="absolute inset-0 overflow-hidden">
            <img id="bg-natural" src="assets/images/natural.webp"
                class="absolute inset-0 w-full h-full object-cover transition-opacity duration-700 opacity-100">

<div class="absolute inset-0 "></div>
        </div>

<h2 class="text-[16px] md:text-[26px] font-extralight tracking-[1px] text-white mb-2">
                Experience Lighting Your Way
            </h2>

<p class="text-gray-300 text-[12px] md:text-[16px] font-light mb-4 leading-relaxed max-w-2xl mx-auto">
                Switch between warm, cool, and natural lighting to see how the same space transforms instantly.
            </p>

<div class="flex flex-wrap justify-center gap-6">

<button data-bg="natural"
                    class="lighting-btn active flex items-center gap-4 px-8 py-2 bg-white/10 backdrop-blur-md border border-white/20 ring-2 ring-white/60 transition-all duration-300">

<div class="text-left">
                        <p class="text-[13px] font-light">Natural Light</p>
                        <p class="text-[11px] text-gray-300 font-light">Balanced everyday illumination</p>
                    </div>
                </button>

<button data-bg="warm"
                    class="lighting-btn flex items-center gap-4 px-8 py-2 bg-white/10 backdrop-blur-md border border-white/20 transition-all duration-300">

<div class="text-left">
                        <p class="text-[13px] font-light">Warm Light</p>
                        <p class="text-[11px] text-gray-300 font-light">Cozy and relaxing ambience</p>
                    </div>
                </button>

<button data-bg="cool"
                    class="lighting-btn flex items-center gap-4 px-8 py-2 bg-white/10 backdrop-blur-md border border-white/20 transition-all duration-300">

<div class="text-left">
                        <p class="text-[13px] font-light">Cool Light</p>
                        <p class="text-[11px] text-gray-300 font-light">Bright and focused lighting</p>
                    </div>
                </button>

</div>
        </div>

</section>

<?php
    // ================= FETCH PRODUCTS =================
    $query = "SELECT * FROM products 
          WHERE status = 'Published' 
          AND FIND_IN_SET('top_selling', product_show)
          ORDER BY id DESC 
          LIMIT 8";

$result = mysqli_query($conn, $query);

// ================= IMAGE FUNCTION =================
    if (!function_exists('getProductImage')) {
        function getProductImage($conn, $product_id)
        {
            $imgQuery = "SELECT image_path FROM product_images 
                     WHERE product_id = '$product_id' 
                     ORDER BY is_primary DESC, id ASC 
                     LIMIT 1";

$imgResult = mysqli_query($conn, $imgQuery);
            $img = mysqli_fetch_assoc($imgResult);

return $img ? $img['image_path'] : 'default.png';
        }
    }
    ?>

<section class="py-10 bg-stanjo-gray text-white">
        <div class="max-w-7xl mx-auto px-6 text-center">

<h2 class="text-[26px] font-extralight tracking-[1px] mb-2">
                Top Selling LED Lights
            </h2>

<p class="text-gray-400 text-[16px] font-light mb-8 leading-relaxed max-w-2xl mx-auto">
                Explore our top selling LED bulbs offering bright illumination, energy efficiency,
                durability, and reliable lighting.
            </p>

<div class="grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-4 gap-6">

<?php if (mysqli_num_rows($result) > 0) { ?>

<?php while ($row = mysqli_fetch_assoc($result)) {
                        $image = getProductImage($conn, $row['id']);
                        ?>

<div
                            class="border border-[#333] bg-black group hover:shadow-xl hover:border-[#555] focus-within:ring-0 focus-within:border-[#555] outline-none transition-shadow duration-300 flex flex-col h-full">

<div class="flex-grow flex flex-col">
                                
                                <a href="product-details.php?id=<?php echo $row['id']; ?>"
                                    class="h-[260px] flex items-center justify-center overflow-hidden">
                                    <img src="admin/uploads/<?php echo $image; ?>"
                                        class="max-h-[200px] object-contain group-hover:scale-110 transition duration-500">
                                </a>

<h3 class="text-lg font-light mb-1 px-3 leading-tight">
                                    <?php echo $row['title']; ?>
                                </h3>

<div class="px-3 pb-4 mt-auto">
                                    <p class="text-sm text-gray-400">
                                        ₹<?php echo $row['discounted_price'] > 0 ? $row['discounted_price'] : $row['base_price']; ?>
                                        <?php if ($row['discounted_price'] > 0 && $row['discounted_price'] < $row['base_price']): ?>
                                            <span class="line-through text-gray-600 ml-2">
                                                ₹<?php echo $row['base_price']; ?>
                                            </span>
                                        <?php endif; ?>
                                    </p>
                                </div>
                            </div>

<div class="grid grid-cols-2 border-t border-[#333] w-full">
                                <a href="product-details.php?id=<?php echo $row['id']; ?>"
                                    class="py-4 text-[12px] uppercase tracking-wider border-r border-[#333] hover:bg-[#333] hover:text-white transition-all flex items-center justify-center">
                                    View Now
                                </a>

<button onclick="buyNow(<?php echo $row['id']; ?>)"
                                    class="py-4 text-[12px] uppercase tracking-wider hover:bg-[#333] hover:text-white transition-all flex items-center justify-center">
                                    Buy Now
                                </button>
                            </div>

</div>

<?php
                    } ?>

<?php
                } else { ?>

<p class="col-span-4 text-gray-400">No products found</p>

<?php
                } ?>

</div>

fetch('ajax/buy_now.php', {
                        method: 'POST',
                        body: formData
                    })
                        .then(res => res.json())
                        .then(data => {
                            if (data.success) {
                                window.location.href = data.redirect_url;
                            } else {
                                alert(data.message || 'Error processing request');
                            }
                        })
                        .catch(err => {
                            console.error(err);
                            alert('An error occurred.');
                        });
                }
            </script>

</div>
    </section>

<section class="py-10 text-white relative overflow-hidden">

<div class="max-w-[1200px] mx-auto px-6">

.scrollbar-hide {
                    -ms-overflow-style: none;
                    scrollbar-width: none;
                }

.swiper-pagination-bullet {
                    background-color: white !important;
                    opacity: 0.5;
                    width: 10px;
                    height: 10px;
                    transition: all 0.3s ease;
                }

.swiper-pagination-bullet-active {
                    background-color: white !important;
                    opacity: 1;
                    width: 25px;
                    border-radius: 10px;
                }
            </style>

<div class="text-center px-4">

<h2 class="text-[26px] font-extralight tracking-[1px] text-white mb-3">
                    Our Product Gallery
                </h2>

<p class="text-[#f2f2f2] text-[16px] max-w-2xl mx-auto mb-6 leading-relaxed">
                    Explore our top selling LED bulbs offering bright illumination,
                    energy efficiency, durability, and reliable lighting.
                </p>

</div>

<div class="swiper gallerySwiper py-10">
                <div class="swiper-wrapper">

<?php
                    $galleryRes = mysqli_query($conn, "SELECT * FROM gallery WHERE status = 1 ORDER BY id DESC");

if ($galleryRes && mysqli_num_rows($galleryRes) > 0):
                        while ($gallery = mysqli_fetch_assoc($galleryRes)):
                            ?>

<div class="swiper-slide">
                                <div class="gallery-card shadow-2xl border border-white/5">
                                    <?php if ($gallery['type'] === 'video'): ?>
                                        <video src="admin/uploads/<?= $gallery['image'] ?>" class="w-full h-full object-cover" muted
                                            loop autoplay></video>
                                    <?php else: ?>
                                        <img src="admin/uploads/<?= $gallery['image'] ?>" class="w-full h-full object-cover">
                                    <?php endif; ?>
                                </div>
                            </div>

<?php endwhile;
                    else:
                        $staticImages = [
                            "assets/images/1.jpg",
                            "assets/images/2.jpg",
                            "assets/images/3.jpg",
                            "assets/images/4.jpg",
                            "assets/images/5.png",
                            "assets/images/6.jpg",
                            "assets/images/7.png",
                            "assets/images/8.jpg",
                            "assets/images/9.jpg"
                        ];
                        foreach ($staticImages as $imgUrl):
                            ?>

<div class="swiper-slide">
                                <div class="gallery-card shadow-2xl border border-white/5">
                                    <img src="<?= $imgUrl ?>" class="w-full h-full object-cover">
                                </div>
                            </div>

<?php endforeach; endif; ?>

</div>

</div>

</div>
    </section>

<section class="py-14 bg-stanjo-gray">
        <div class="container-custom">

<div class="text-center mb-8">
                <h2 class="text-[26px] font-extralight text-white mb-3">
                    Customer Testimonials
                </h2>

<p class="text-stanjo-zinc text-[16px] font-light leading-relaxed max-w-xl mx-auto">
                    Hear what our customers say about our premium lighting solutions.
                </p>
            </div>

<div class="swiper mySwiper overflow-visible">
                <div class="swiper-wrapper py-10">

<div class="swiper-slide group">
                        <div
                            class="bg-[#111] rounded-xl p-6 border border-[#222] transition-all duration-500 transform scale-90 opacity-50 group-[.swiper-slide-active]:scale-105 group-[.swiper-slide-active]:opacity-100 group-[.swiper-slide-active]:border-transparent group-[.swiper-slide-active]:shadow-xl h-full mx-auto flex flex-col justify-between">
                            <div>
                                <div class="flex items-center space-x-4 mb-4">
                                    <div
                                        class="w-12 h-12 bg-[#333] rounded-full flex items-center justify-center text-white font-bold">
                                        RS</div>
                                    <div>
                                        <h5 class="font-light uppercase text-white">Rohan Sharma</h5>
                                        <div class="text-[#ebfa14] mb-4 text-sm">★★★★★</div>
                                    </div>
                                </div>
                            </div>
                            <p class="text-stanjo-zinc text-[12px] font-light leading-relaxed">
                                "The quality of lighting from STANJO is incredible. It transformed my home with a
                                premium feel."
                            </p>
                        </div>
                    </div>

<div class="swiper-slide group">
                        <div
                            class="bg-[#111] rounded-xl p-6 border border-[#222] transition-all duration-500 transform scale-90 opacity-50 group-[.swiper-slide-active]:scale-105 group-[.swiper-slide-active]:opacity-100 group-[.swiper-slide-active]:border-transparent group-[.swiper-slide-active]:shadow-xl h-full mx-auto flex flex-col justify-between">
                            <div>
                                <div class="flex items-center space-x-4 mb-4">
                                    <div
                                        class="w-12 h-12 bg-[#333] rounded-full flex items-center justify-center text-white font-bold">
                                        SV</div>
                                    <div>
                                        <h5 class="font-light uppercase text-white">Sohan Verma</h5>
                                        <div class="text-[#ebfa14] mb-4 text-sm">★★★★★</div>
                                    </div>
                                </div>
                            </div>
                            <p class="text-stanjo-zinc text-[12px] font-light leading-relaxed">
                                "Best customer service and high-performance lights. The durability is unmatched."
                            </p>
                        </div>
                    </div>

<div class="swiper-slide group">
                        <div
                            class="bg-[#111] rounded-none p-6 border border-[#222] transition-all duration-500 transform scale-90 opacity-50 group-[.swiper-slide-active]:scale-105 group-[.swiper-slide-active]:opacity-100 group-[.swiper-slide-active]:border-transparent group-[.swiper-slide-active]:shadow-xl h-full mx-auto flex flex-col justify-between">
                            <div>
                                <div class="flex items-center space-x-4 mb-4">
                                    <div
                                        class="w-12 h-12 bg-[#333] rounded-full flex items-center justify-center text-white font-bold">
                                        SG</div>
                                    <div>
                                        <h5 class="font-light uppercase text-white">Sachin Gupta</h5>
                                        <div class="text-[#ebfa14] mb-4 text-sm">★★★★★</div>
                                    </div>
                                </div>
                            </div>
                            <p class="text-stanjo-zinc text-[12px] font-light leading-relaxed">
                                "Amazing build quality. Highly recommended for premium lighting."
                            </p>
                        </div>
                    </div>

<div class="swiper-slide group">
                        <div
                            class="bg-[#111] rounded-none p-6 border border-[#222] transition-all duration-500 transform scale-90 opacity-50 group-[.swiper-slide-active]:scale-105 group-[.swiper-slide-active]:opacity-100 group-[.swiper-slide-active]:border-transparent group-[.swiper-slide-active]:shadow-xl h-full mx-auto flex flex-col justify-between">
                            <div>
                                <div class="flex items-center space-x-4 mb-4">
                                    <div
                                        class="w-12 h-12 bg-[#333] rounded-full flex items-center justify-center text-white font-bold">
                                        AK</div>
                                    <div>
                                        <h5 class="font-light uppercase text-white">Amit Kumar</h5>
                                        <div class="text-[#ebfa14] mb-4 text-sm">★★★★★</div>
                                    </div>
                                </div>
                            </div>
                            <p class="text-stanjo-zinc text-[12px] font-light leading-relaxed">
                                "Extremely satisfied with the service and the brightness of the bulbs. Unmatched
                                luminance!"
                            </p>
                        </div>
                    </div>

<div class="swiper-slide group">
                        <div
                            class="bg-[#111] rounded-none p-6 border border-[#222] transition-all duration-500 transform scale-90 opacity-50 group-[.swiper-slide-active]:scale-105 group-[.swiper-slide-active]:opacity-100 group-[.swiper-slide-active]:border-transparent group-[.swiper-slide-active]:shadow-xl h-full mx-auto flex flex-col justify-between">
                            <div>
                                <div class="flex items-center space-x-4 mb-4">
                                    <div
                                        class="w-12 h-12 bg-[#333] rounded-full flex items-center justify-center text-white font-bold">
                                        PJ</div>
                                    <div>
                                        <h5 class="font-light uppercase text-white">Priya Jain</h5>
                                        <div class="text-[#ebfa14] mb-4 text-sm">★★★★★</div>
                                    </div>
                                </div>
                            </div>
                            <p class="text-stanjo-zinc text-[12px] font-light leading-relaxed">
                                "Absolutely gorgeous design and efficient performance. Definitely going to buy again."
                            </p>
                        </div>
                    </div>

</div>
            </div>
        </div>
    </section>

<section class="py-10 md:py-24 bg-black overflow-hidden relative">

<div class="max-w-[1200px] mx-auto px-6">

<div class="flex flex-col items-center text-center mb-12 gap-4">

<h2 class="text-[26px] font-extralight text-white leading-tight">
                        Modern Lighting Inspiration
                    </h2>

<p class="text-[16px] text-gray-400 mt-3">
                        Explore the latest updates, ideas, and trends in modern lighting design.
                    </p>

</div>

<div>
                    <a href="blog.php" class="inline-block px-5 py-2 text-white border border-[#555] 
                    hover:bg-[#333] transition-all duration-300">
                        View All Articles
                    </a>
                </div>

</div>

<?php
            $blogQuery = "SELECT * FROM blogs WHERE status = 1 ORDER BY id DESC LIMIT 3";
            $blogResult = mysqli_query($conn, $blogQuery);
            ?>

<div class="grid grid-cols-1 sm:grid-cols-2 md:grid-cols-3 gap-6">

<?php if ($blogResult && mysqli_num_rows($blogResult) > 0): ?>

<?php while ($blog = mysqli_fetch_assoc($blogResult)): ?>

<div class="overflow-hidden">
                                <img src="admin/uploads/<?= $blog['image'] ?>"
                                    class="w-full h-[220px] object-cover group-hover:scale-110 transition duration-500">
                            </div>

<a href="blog-details.php?slug=<?= $blog['slug'] ?>"
                                    class="text-[10px] tracking-widest text-gray-300 hover:text-white transition uppercase">
                                    Read More →
                                </a>

</div>

<?php endwhile; ?>

<?php else: ?>

<div class="col-span-3 text-center text-gray-500">
                        No blogs found
                    </div>

<?php endif; ?>

</div>

</div>
    </section>
    
    <section class="py-10 md:py-24 bg-stanjo-gray  border-y border-white/5">
        <div class="container-custom">

<div class="text-center max-w-none mx-auto mb-10">
                <h2 class="text-[26px] font-extralight text-white mb-3">
                    Frequently Asked Questions
                </h2>

<p class="text-stanjo-zinc text-[16px] font-light leading-relaxed">
                    Find quick answers to common queries about our premium lighting solutions.
                </p>
            </div>

<div class="max-w-4xl mx-auto  space-y-3" id="faq-accordion">
                <?php
                $faqs = [
                    ["q" => "What makes Stanjo LED products energy efficient?", "a" => "Our LEDs use advanced semiconductor technology that converts up to 90% of energy into light, minimizing heat waste and significantly reducing electricity bills compared to traditional lighting."],
                    ["q" => "How long do Stanjo LED bulbs typically last?", "a" => "Stanjo LED bulbs are engineered for durability, offering a lifespan of up to 50,000 hours. This means if used for 8 hours daily, they can last over 15 years."],
                    ["q" => "Does Stanjo offer a warranty on its products?", "a" => "Yes, we offer a cumulative 10-year warranty trust on our premium LED solutions, covering manufacturing defects and performance consistency to ensure peace of mind."],
                    ["q" => "Can I use Stanjo LEDs with dimmer switches?", "a" => "Many of our models are dimmable. Please check the product specifications on the package or product details page for 'Dimmable' compatibility before purchase."],
                    ["q" => "Are Stanjo lights eco-friendly?", "a" => "Absolutely. Our products are 100% recyclable, free of toxic mercury, and designed to reduce carbon footprints through superior performance and longevity."]
                ];

foreach ($faqs as $i => $faq):
                    ?>
                    <div
                        class="border border-white/5 rounded-none overflow-hidden bg-[#0A0A0A] hover:border-white/20 transition-all duration-500">

<span class="text-[13px] md:text-[16px] font-light  pr-6 text-stanjo-zinc">
                                <?= $faq['q'] ?>
                            </span>

<div
                                class="w-8 h-8 rounded-full bg-white/5 flex items-center justify-center group-hover:bg-[#0A0A0A]/20 transition-colors">
                                <svg id="icon-<?= $i ?>" xmlns="http://www.w3.org/2000/svg"
                                    class="w-4 h-4 text-stanjo-zinc transition-transform duration-500" fill="none"
                                    viewBox="0 0 24 24" stroke="currentColor">
                                    <path stroke-linecap="round" stroke-linejoin="round" stroke-width="1.5"
                                        d="M12 4v16m8-8H4" />
                                </svg>
                            </div>
                        </button>

<div id="content-<?= $i ?>"
                            class="px-6 max-h-0 overflow-hidden transition-all duration-700 ease-[cubic-bezier(0.4,0,0.2,1)] opacity-0">

</div>
                    </div>
                <?php endforeach; ?>
            </div>

</div>
    </section>
    <script>
        function toggleFaq(index) {
            const content = document.getElementById(`content-${index}`);
            const icon = document.getElementById(`icon-${index}`);
            const allContents = document.querySelectorAll('[id^="content-"]');
            const allIcons = document.querySelectorAll('[id^="icon-"]');

allContents.forEach((c, i) => {
                if (i !== index) {
                    c.style.maxHeight = '0';
                    c.style.opacity = '0';
                    allIcons[i].style.transform = 'rotate(0deg)';
                }
            });

if (content.style.maxHeight === '0px' || content.style.maxHeight === '') {
                content.style.maxHeight = content.scrollHeight + 'px';
                content.style.opacity = '1';
                icon.style.transform = 'rotate(135deg)';
            } else {
                content.style.maxHeight = '0';
                content.style.opacity = '0';
                icon.style.transform = 'rotate(0deg)';
            }
        }
    </script>
</main>

<?php include 'footer.php'; ?>