<?php
include("admin/connection.php");
include('include/header.php');
$query = "SELECT * FROM `slider` ORDER BY id DESC";
$sql = mysqli_query($con, $query);
?>
<!--==============================
    Hero Area
==============================-->
<div id="carouselExampleControls" class="carousel slide carousel-fade fade-gallery-wrapper" data-bs-ride="carousel" data-bs-interval="1500">
    <div class="carousel-inner fade-gallery-slider">
        <?php
        $i = 0; // counter to set active class on first slide
        while ($row = mysqli_fetch_assoc($sql)) {
            $active = ($i == 0) ? 'active' : '';
        ?>
            <div class="carousel-item <?php echo $active; ?>">
                <img src="<?php path(); ?>/admin/assets/images/slider/<?php echo $row['Image']; ?>"
                    class="d-block w-100 fade-gallery-img"
                    alt="Slide <?php echo $i + 1; ?>">
            </div>
        <?php
            $i++;
        }
        ?>
    </div>

    <!-- Carousel Controls -->
    <button class="carousel-control-prev" type="button" data-bs-target="#carouselExampleControls" data-bs-slide="prev">
        <span class="carousel-control-prev-icon" aria-hidden="true"></span>
        <span class="visually-hidden">Previous</span>
    </button>

    <button class="carousel-control-next" type="button" data-bs-target="#carouselExampleControls" data-bs-slide="next">
        <span class="carousel-control-next-icon" aria-hidden="true"></span>
        <span class="visually-hidden">Next</span>
    </button>
</div>

<!--======== / Hero Section ========-->
<!--==============================
    About Area 2 
==============================-->
<section class="about-area2 space overflow-hidden">
    <div class="container">
        <div class="row">
            <div class="col-lg-6">
                <div class="about-thumb-wrap2 mb-lg-0 mb-5">

                    <div class="thumb-1"><img src="assets/img/about/about.jpg" alt="img"></div>

                </div>
            </div>
            <div class="col-lg-6">
                <div class="title-area mb-0">
                    <h3 class="sub-title">ABOUT OUR COMPANY</h3>
                    <h2 class="sec-title">NM Advertiser Pvt. Ltd.</h2>
                    <p class="content">At NM Advertiser Pvt. Ltd., we believe
                        that a well-designed space goes beyond aesthetics—it’s about
                        crafting environments that inspire, comfort, and elevate the
                        lives of those who experience them. Our mission is to transform
                        your spaces into true reflections of your individuality and brand
                        identity, ensuring that every element resonates with your vision
                        and purpose.</p>
                    <p class="content">With nearly five decades of expertise, we have built
                        a strong reputation as a trusted name in professional branding and innovative
                        manufacturing solutions. From our modest beginnings in Bhandup, Mumbai,
                        we have grown into a nationwide presence, operating from our state-of-the-art
                        facility in Bhiwandi. Today, we proudly deliver end-to-end Turnkey Retail Solutions,
                        offering unmatched quality, creativity, and reliability. At NM Advertiser Pvt. Ltd.,
                        we are committed to turning ideas into impactful realities—helping you create spaces
                        that speak, connect, and leave a lasting impression.</p>

                </div>
            </div>
        </div>
    </div>
</section>
<!--==============================
    Product Area  
==============================-->
<div class="product-area space text-center bg">
    <div class="container">
        <div class="title-area text-center mb-35">
            <h3 class="sub-title"><span class="double-line"></span> Our Services</h3>
            <h2 class="sec-title mb-0">Innovative Turnkey solutions Crafted </h2>

        </div>

        <div class="row">
            <div class="col-lg-12">
                <div class="tab-content">
                    <div class="tab-pane fade show active">
                        <div class="row as-carousel product-slider g-0" data-slide-show="3" data-lg-slide-show="3"
                            data-md-slide-show="2" data-sm-slide-show="2" data-xs-slide-show="1" data-arrows="true"
                            data-xl-arrows="true" data-ml-arrows="true">
                            <?php
                            $ser = mysqli_query($con, "SELECT * FROM `upvc_door`");
                            while ($row = mysqli_fetch_array($ser)) {
                                $title = $row['title'];
                                $description = $row['description'];
                                $slug = $row['slug'];
                                $Image = $row['Image'];
                            ?>
                                <div class="col-xl-3 col-lg-4 col-sm-6">
                                    <div class="as-product">


                                        <div class="product-img">
                                            <a href="<?php path(); ?>/service-details.php?slug=<?php echo $slug; ?>">
                                                <img src="<?php path(); ?>/admin/assets/images/service/<?php echo $Image; ?>" alt="product image"></a>
                                        </div>
                                        <div class="product-content">

                                            <h4 class="product-title h5">
                                                <a href="<?php path(); ?>/service-details.php?slug=<?php echo $slug; ?>"><?php echo $title; ?></a>
                                            </h4>
                                            <p class="service-card_text">
                                                <?php echo htmlspecialchars(strip_tags($description)); ?></p>

                                            <a class="as-btn style4 " href="<?php path(); ?>/service-details.php?slug=<?php echo $slug; ?>"><i
                                                    class="fas fa-arrow-right ms-1 me-2"></i> Read More</a>
                                        </div>
                                    </div>
                                </div>
                            <?php } ?>


                        </div>
                    </div>

                </div>
            </div>
        </div>
    </div>
</div>
<!-- client -->
<?php
$query = "SELECT * FROM `client`";
$sql = mysqli_query($con, $query);
?>
<div class="product-area mt-5 mb-5 text-center">
    <div class="container">
        <div class="title-area text-center mb-35">
            <h2 class="sec-title mb-0">Our Client</h2>
        </div>

        <div class="row">
            <div class="logos">
                <div class="logo_items" id="logoItems">
                    <?php while ($row = mysqli_fetch_assoc($sql)) { ?>
                        <img src="<?php echo path(); ?>/admin/assets/images/client/<?php echo htmlspecialchars($row['Image']); ?>" alt="Client Logo">
                    <?php } ?>
                </div>
            </div>
        </div>
    </div>
</div>

<!--==============================
    Testimonial Area 3  
==============================-->
<?php
// testimonial
$queryt = "SELECT * FROM `testimonial` ORDER BY id DESC";
$sqlt = mysqli_query($con, $queryt);
// end testimonial
?>
<section class="testiomonial-area3 space bg-title">
    <div class="container">
        <div class="title-area">
            <span class="sub-title">TESTIMONIALS</span>
            <h2 class="sec-title text-white">What Our Client Say?</h2>
        </div>
        <div class="row testimonial-slider3 as-carousel arrow-style-2"
            data-slide-show="3"
            data-lg-slide-show="2"
            data-md-slide-show="2"
            data-sm-slide-show="1"
            data-xs-slide-show="1"
            data-arrows="true"
            data-xl-arrows="true"
            data-ml-arrows="true"
            data-lg-arrows="true"
            data-md-arrows="true">

            <?php while ($rowt = mysqli_fetch_assoc($sqlt)) { ?>
                <div class="col">
                    <div class="testi-box3">
                        <!-- Quote Icon -->
                        <div class="quote-icon">
                            <img src="assets/img/about/download.svg" alt="Quote Icon">
                        </div>

                        <!-- Testimonial Content -->
                        <p class="testi_content">
                            <?php echo $rowt['para']; ?>
                        </p>

                        <!-- Profile Section -->
                        <div class="testi-box_profile">
                            <div class="details">
                                <h4 class="testi-box_name">
                                    <?php echo $rowt['cus_name']; ?>
                                </h4>
                            </div>
                        </div>
                    </div>
                </div>
            <?php } ?>

        </div>

    </div>
</section>

<!--==============================
    Counter Area  
==============================-->
<section>
    <div class="counter-area ">
        <div class="container">
            <div class="row gy-25 justify-content-center">
                <div class="col-6 col-sm-6 col-lg-3">
                    <div class="counter-card">
                        <div class="counter-card_icon">
                            <img src="assets/img/icon/icon1.png" alt="img">
                        </div>
                        <h2 class="counter-card_number"><span class="counter-number">3000</span>+</h2>
                        <p class="counter-card_text text-center">Projects Complete</p>
                    </div>
                </div>
                <div class="col-6 col-sm-6 col-lg-3">
                    <div class="counter-card">
                        <div class="counter-card_icon">
                            <img src="assets/img/icon/icon2.png" alt="img">
                        </div>
                        <h2 class="counter-card_number"><span class="counter-number">200</span>+</h2>
                        <p class="counter-card_text text-center">Team Members</p>
                    </div>
                </div>
                <div class="col-6 col-sm-6 col-lg-3">
                    <div class="counter-card">
                        <div class="counter-card_icon">
                            <img src="assets/img/icon/icon3.png" alt="img">
                        </div>
                        <h2 class="counter-card_number"><span class="counter-number">2500</span>+</h2>
                        <p class="counter-card_text text-center">Clients Are Happy</p>
                    </div>
                </div>
                <div class="col-6 col-sm-6 col-lg-3">
                    <div class="counter-card">
                        <div class="counter-card_icon">
                            <img src="assets/img/icon/icon4.png" alt="img">
                        </div>
                        <h2 class="counter-card_number"><span class="counter-number">20</span>+</h2>
                        <p class="counter-card_text text-center">Expertise</p>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
<!--==============================
    Why-choose-us Area  
==============================-->
<div class="wcu-area">
    <div class="as-container2 position-relative bg-title">
        <!-- bg animated image -->
        <div class="anime-img-1 shape-mockup jump d-none d-lg-block" data-bottom="0%" data-right="0"><img
                src="assets/img/wcu/wcu_shape.png" alt="img"></div>

        <div class="row gx-0">
            <div class="col-xl-6 col-lg-5">
                <div class="wcu-thumb" data-bg-src="assets/img/about/why.jpg">
                </div>
            </div>
            <div class="col-xl-6 col-lg-7">
                <div class="wcu-box">
                    <div class="title-area">
                        <!-- <span class="sub-title">Why Choose Us</span> -->
                        <h2 class="sec-title text-white">Why Choose Us</h2>
                    </div>
                    <div class="info-media-wrap">
                        <div class="info-media">
                            <div class="info-media_icon">
                                <img class="icon-bg" src="assets/img/wcu/wcu_icon_bg_ylw.svg" alt="img">
                                <img class="icon-hover" src="assets/img/wcu/wcu_icon_bg_red.svg" alt="img">
                                1
                            </div>
                            <div class="media-body">
                                <h3 class="h4 info-media_title">Expertise</h3>
                                <p class="info-media_text">Our team of experienced designers brings a wealth
                                    of knowledge and creativity to every project. </p>
                            </div>
                        </div>
                        <div class="info-media">
                            <div class="info-media_icon">
                                <img class="icon-bg" src="assets/img/wcu/wcu_icon_bg_ylw.svg" alt="img">
                                <img class="icon-hover" src="assets/img/wcu/wcu_icon_bg_red.svg" alt="img">
                                2
                            </div>
                            <div class="media-body">
                                <h3 class="h4 info-media_title">Customization</h3>
                                <p class="info-media_text">We believe in creating personalized designs that
                                    reflect your individual style and needs.</p>
                            </div>
                        </div>
                        <div class="info-media mb-0">
                            <div class="info-media_icon">
                                <img class="icon-bg" src="assets/img/wcu/wcu_icon_bg_ylw.svg" alt="img">
                                <img class="icon-hover" src="assets/img/wcu/wcu_icon_bg_red.svg" alt="img">
                                3
                            </div>
                            <div class="media-body">
                                <h3 class="h4 info-media_title">Quality</h3>
                                <p class="info-media_text">We use only the highest quality materials and work
                                    with trusted contractors to ensure superior results.</p>
                            </div>
                        </div>
                        <div class="info-media mb-0">
                            <div class="info-media_icon">
                                <img class="icon-bg" src="assets/img/wcu/wcu_icon_bg_ylw.svg" alt="img">
                                <img class="icon-hover" src="assets/img/wcu/wcu_icon_bg_red.svg" alt="img">
                                4
                            </div>
                            <div class="media-body">
                                <h3 class="h4 info-media_title">Sustainability</h3>
                                <p class="info-media_text">We prioritize eco-friendly materials and
                                    practices to create sustainable and healthy environments.</p>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

</div>

<!--==============================
    Blog Area  
==============================-->
<section class="blog-area space-bottom mt-5" id="blog-sec" data-bg-src="assets/img/bg/blog_bg_1.png">
    <div class="container">
        <div class="title-area text-center">
            <span class="sub-title"><span class="double-line"></span> Blog & News</span>
            <h2 class="sec-title">Latest News & Blogs</h2>
        </div>
        <div class="blog-slider row as-carousel" data-slide-show="3" data-lg-slide-show="2" data-md-slide-show="2"
            data-sm-slide-show="1" data-xs-slide-show="1" data-arrows="true" data-xl-arrows="true"
            data-ml-arrows="true">
            <?php
            $blogs = mysqli_query($con, "SELECT * FROM `blog` ORDER BY id DESC LIMIT 3");
            while ($row = mysqli_fetch_array($blogs)) {
                $title = $row['title'];
                $description = $row['description'];
                $slug = $row['slug'];
                $Image = $row['Image'];
            ?>
                <div class="col-md-6 col-xl-4">
                    <div class="blog-card">
                        <div class="blog-img">
                            <a href="<?php path(); ?>/blog-details.php?slug=<?php echo $slug; ?>">
                                <img src="<?php path(); ?>/admin/assets/images/blog/<?php echo htmlspecialchars($Image); ?>" alt="<?php echo htmlspecialchars($title); ?>">
                            </a>
                        </div>
                        <div class="blog-content">

                            <h3 class="blog-title box-title">
                                <a href="<?php path(); ?>/blog-details.php?slug=<?php echo $slug; ?>">
                                    <?php echo htmlspecialchars($title); ?>
                                </a>
                            </h3>
                            <p class="blog-text"><?php echo htmlspecialchars(strip_tags($description)); ?></p>
                            <a href="<?php path(); ?>/blog-details.php?slug=<?php echo $slug; ?>" class="line-btn">Read More</a>
                        </div>
                    </div>
                </div>

            <?php
            } ?>
        </div>
    </div>
</section>

<?php
include("include/footer.php");
?>