<?php
include('include/main.inc.php');


if (strpos($_SERVER['REQUEST_URI'], ".php") !== false) {

    header("Location: ".site_url);
                  exit;
}


$res_home = $dbconn->query("select pageDesc,pageDesc1,pageImage,page_metatitle,page_metadesc,page_keyword from static_pages where pageID ='1'");
$home_details = $res_home->fetch_assoc();

$res_web = $dbconn->query("Select * from admin_details where slno = '1'");
$web_details = $res_web->fetch_assoc();

$page_metatitle = ($home_details['page_metatitle']) ? $home_details['page_metatitle'] : $web_details['companyName'];
$page_metadesc = ($home_details['page_metadesc']) ? $home_details['page_metadesc'] : $web_details['companyName'];
$page_metakey = ($home_details['page_keyword']) ? $home_details['page_keyword'] : $web_details['companyName'];
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title><?= $page_metatitle ?></title>
    <meta name="description" content="<?= $page_metadesc ?>">
    <meta name="keywords" content="<?= $page_metakey ?>">
    <?php include 'app_top.php';?>
</head>

<body>
    <?php include 'app_header.php';?>

    <div class="home_slider">
    <div id="slider2" class="carousel slide  carousel-fade" data-bs-ride="carousel">

    <div class="carousel-indicators">
    <button type="button" data-bs-target="#slider2" data-bs-slide-to="0" class="active" aria-current="true" aria-label="Slide 1"></button>
    <button type="button" data-bs-target="#slider2" data-bs-slide-to="1" aria-label="Slide 2"></button>
    <button type="button" data-bs-target="#slider2" data-bs-slide-to="2" aria-label="Slide 3"></button>
  </div>

            <div class="carousel-inner">
                <?php
                 $banners_query = $dbconn->query("select bannerImage, personName from banner_tbl order by bannerorder");
                  $sno = 0;
                  while($banners = $banners_query->fetch_assoc()){
                     $sno++;
                  ?>
                    <div class="carousel-item <?= $sno == 1 ? 'active' : ''; ?>">
                    <div class="slide"><img fetchpriority="auto" src="<?= site_url; ?>/uploaded-files/banner-image/<?= $banners['bannerImage']; ?>" alt="<?= $banners['personName']; ?> Manufacturers in Surat" title="<?= $banners['personName']; ?> Manufacturers in Surat" width="1350" height="450"></div>
                    </div>
                <?php } ?>
            </div>
            <button class="carousel-control-prev owl-prev" type="button" data-bs-target="#slider2"
                data-bs-slide="prev">
                <svg xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="currentColor" viewBox="0 0 16 16">
                    <path fill-rule="evenodd"
                        d="M11.354 1.646a.5.5 0 0 1 0 .708L5.707 8l5.647 5.646a.5.5 0 0 1-.708.708l-6-6a.5.5 0 0 1 0-.708l6-6a.5.5 0 0 1 .708 0z">
                    </path>
                </svg>
                <span class="visually-hidden">Previous</span>
            </button>
            <button class="carousel-control-next owl-next" type="button" data-bs-target="#slider2"
                data-bs-slide="next">
                <svg xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="currentColor" viewBox="0 0 16 16">
                    <path fill-rule="evenodd"
                        d="M4.646 1.646a.5.5 0 0 1 .708 0l6 6a.5.5 0 0 1 0 .708l-6 6a.5.5 0 0 1-.708-.708L10.293 8 4.646 2.354a.5.5 0 0 1 0-.708z">
                    </path>
                </svg>
                <span class="visually-hidden">Next</span>
            </button>
        </div>

    </div>
    <section class="about_cotent_home">
        <div class="container">
            <h1 class="title">Best Rings Manufacturers in Surat</h1>
            <?= $home_details['pageDesc']; ?>

        </div>
    </section>
    <div class="collection_1">

        <div class="container">
            <?php
                    $res_cat1 = $dbconn->query("select catName,displayName,catImage,catDesc from category_tbl where catID='1'");
                    $category1 = $res_cat1->fetch_assoc();
                        $cate_href1 = str_ireplace(" ", "-", $category1['catName']);
                    $res_cat2 = $dbconn->query("select catName,displayName,catImage,catDesc from category_tbl where catID='9'");
                    $category2 = $res_cat2->fetch_assoc();
                        $cate_href2 = str_ireplace(" ", "-", $category2['catName']);
                    $res_cat3 = $dbconn->query("select catName,displayName,catImage,catDesc from category_tbl where catID='12'");
                    $category3 = $res_cat3->fetch_assoc();
                        $cate_href3 = str_ireplace(" ", "-", $category3['catName']);
                    $res_cat4 = $dbconn->query("select catName,displayName,catImage,catDesc from category_tbl where catID='11'");
                    $category4 = $res_cat4->fetch_assoc();
                        $cate_href4 = str_ireplace(" ", "-", $category4['catName']);
                ?>
            <div class="row">
                <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-12 col-12">
                    <div class="item-adv2 banner-adv zoom-image fade-out-in">
                        <a href="<?= site_url.'/'.strtolower($cate_href1); ?>.htm" title="<?= $category1['displayName']; ?> Manufacturers in Surat"><img src="<?= site_url; ?>/uploaded-files/category/images/<?= $category1['catImage']; ?>" alt="<?= $category1['displayName']; ?> Manufacturers in Surat" title="<?= $category1['displayName']; ?> Manufacturers in Surat" width="700" height="700"></a>
                        <div class="banner-info text-center">
                            <div class="title2"><a class="text-white" href="<?= site_url.'/'.strtolower($cate_href1); ?>.htm" title="<?= $category1['displayName']; ?> Manufacturers in Surat"><?= $category1['displayName']; ?></a></div>
                            <p><?= substr_replace($category1['catDesc'], '...', '100'); ?></p>
                            <a href="<?= site_url.'/'.strtolower($cate_href1); ?>.htm" title="View More" class="shop_btn">View More <i class="fa fa-long-arrow-right"></i></a>
                        </div>
                    </div>
                </div>
                <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-12 col-12">
                    <div class="item-adv2 banner-adv zoom-image">
                        <a href="<?= site_url.'/'.strtolower($cate_href2); ?>.htm" title="<?= $category2['displayName']; ?> Manufacturers in Surat"><img src="<?= site_url; ?>/uploaded-files/category/images/<?= $category2['catImage']; ?>" alt="<?= $category2['displayName']; ?> Manufacturers in Surat" title="<?= $category2['displayName']; ?> Manufacturers in Surat" width="700" height="700"></a>
                        <div class="banner-info text-center">
                            <div class="title2"><a class="text-white" href="<?= site_url.'/'.strtolower($cate_href2); ?>.htm" title="<?= $category2['displayName']; ?> Manufacturers in Surat"><?= $category2['displayName']; ?></a></div>
                            <p><?= substr_replace($category2['catDesc'], '...', '100'); ?></p>
                            <a href="<?= site_url.'/'.strtolower($cate_href2); ?>.htm" title="View More" class="shop_btn">View More <i class="fa fa-long-arrow-right"></i></a>
                        </div>
                    </div>
                </div>
                <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-12 col-12">
                    <div class="item-adv2 banner-adv zoom-image fade-out-in">
                        <a href="<?= site_url.'/'.strtolower($cate_href3); ?>.htm" title="<?= $category3['displayName']; ?> Manufacturers in Surat"><img src="<?= site_url; ?>/uploaded-files/category/images/<?= $category3['catImage']; ?>" alt="<?= $category3['displayName']; ?> Manufacturers in Surat" title="<?= $category3['displayName']; ?> Manufacturers in Surat" width="700" height="700"></a>
                        <div class="banner-info text-center">
                            <div class="title2"><a class="text-white" href="<?= site_url.'/'.strtolower($cate_href3); ?>.htm" title="<?= $category3['displayName']; ?> Manufacturers in Surat"><?= $category3['displayName']; ?></a></div>
                            <p><?= substr_replace($category3['catDesc'], '...', '100'); ?></p>
                            <a href="<?= site_url.'/'.strtolower($cate_href3); ?>.htm" title="View More" class="shop_btn">View More <i class="fa fa-long-arrow-right"></i></a>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="clearfix"></div>
    <section class="popular_product">
        <div class="container">
            <div class="title">Popular Collections</div>
              <p class="text-center mx-auto mb-3 w-75">
              Indulge in our captivating collections, showcasing exquisite rings from timeless solitaires to stunning three-stone designs, ideal for engagements and anniversaries. Celebrate love with elegant wedding rings and eternity bands. Adorn your wrists with luxurious tennis and Cuban link bracelets, and complete your look with sparkling necklaces, pendants, and earrings that radiate sophistication and style.
              </p>
            <div class="row">
                <?php
                    $res_popcat = $dbconn->query("select catName,displayName,catImage from category_tbl where parentID='0'");
                    if($res_popcat->num_rows > 0){

                ?>
                <div class="col-xxl-12 col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
                    <div id="popular" class="owl-carousel">
                        <?php
                            while($pop_category = $res_popcat->fetch_assoc()){
                                $pop_cate_href = str_ireplace(" ", "-", $pop_category['catName']);

                        ?>
                        <div class="product">
                            <a href="<?= site_url.'/'.strtolower($pop_cate_href); ?>.htm" title="<?= $pop_category['displayName']; ?> Manufacturers in Surat">
                                <div class="off_label">20%off</div>
                                <div class="image01">
                                    <img src="<?= getImage($pop_category['catImage'], 280, 280, $pop_category['catName'], "/uploaded-files/category/images/"); ?>" alt="<?= $pop_category['displayName']; ?> Manufacturers in Surat" title="<?= $pop_category['displayName']; ?> Manufacturers in Surat" width="700" height="700">
                                </div>
                            </a>
                            <div class="new_desc">
                                <h4 class="title3"><a href="<?= site_url.'/'.strtolower($pop_cate_href); ?>.htm" title="<?= $pop_category['displayName']; ?> Manufacturers in Surat"><?= $pop_category['displayName']; ?></a></h4>
                                <span>See the Collection</span>
                            </div>
                        </div>
                        <?php } ?>
                    </div>
                </div>
                <?php } ?>
            </div>
        </div>
    </section>

    <div class="banners banners2">
        <div class="container">
            <div class="row">
                <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-12 col-12">
                    <div class="banner">
                        <a href="<?= site_url.'/'.strtolower($cate_href3); ?>.htm" title="<?= $category3['displayName']; ?> Manufacturers in Surat">
                            <img src="<?= site_url; ?>/designer/images/new/earings.jpg" alt="<?= $category3['displayName']; ?> Manufacturers in Surat" title="<?= $category3['displayName']; ?> Manufacturers in Surat" width="600" height="316">
                        </a>
                    </div>
                </div>
                <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-12 col-12">
                    <div class="banner">
                        <a href="<?= site_url.'/'.strtolower($cate_href4); ?>.htm" title="<?= $category4['displayName']; ?> Manufacturers in Surat">
                            <img src="<?= site_url; ?>/designer/images/new/pendents.jpg" alt="<?= $category4['displayName']; ?> Manufacturers in Surat" title="<?= $category4['displayName']; ?> Manufacturers in Surat" width="600" height="316">
                        </a>
                    </div>
                </div>
                <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-12 col-12">
                    <div class="banner">
                        <a href="<?= site_url.'/'.strtolower($cate_href1); ?>.htm" title="<?= $category1['displayName']; ?> Manufacturers in Surat">
                            <img src="<?= site_url; ?>/designer/images/new/rings.jpg" alt="<?= $category1['displayName']; ?> Manufacturers in Surat" title="<?= $category1['displayName']; ?> Manufacturers in Surat" width="600" height="316">
                        </a>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <section class="featured_products">
        <div class="container">
            <div class="title">Featured Products</div>
             <p class="text-center mx-auto mb-3 w-75">
             Enhance your style with a stunning collection of exquisite jewelry. Choose from timeless solitaire and three-stone rings perfect for engagements and anniversaries. Adorn your wrist with dazzling tennis or Cuban link bracelets. Transform your look with an elegant diamond halo and solitaire pendants. Complete your ensemble with captivating studs and halo earrings for every occasion!
              </p>
            <?php
                $res_feacat = $dbconn->query("select catID,catName,displayName,catImage from category_tbl where parentID='0' limit 4");
                if($res_feacat->num_rows > 0){

            ?>
            <div class="row">
                <?php
                    while($pop_category = $res_feacat->fetch_assoc()){
                        $res_sub = $dbconn->query("select catName,displayName,catImage from category_tbl where parentID = '".$pop_category['catID']."' limit 2");
                        if($res_sub->num_rows > 0){
                        while($sub_cates = $res_sub->fetch_assoc()){
                            $sub_cat_href = str_ireplace(" ", "-", $sub_cates['catName']);
                ?>
                <div class="col-xxl-3 col-xl-3 col-lg-3 col-md-3 col-sm-12 col-12">
                    <div class="product1">
                        <a href="<?= site_url.'/'.strtolower($sub_cat_href); ?>.htm" title="<?= $sub_cates['displayName']; ?> Manufacturers in Surat">
                            <div class="image01">
                                <img src="<?= getImage($sub_cates['catImage'], 250, 250, $sub_cates['catName'], "/uploaded-files/category/images/"); ?>" alt="<?= $sub_cates['displayName']; ?> Manufacturers in Surat" title="<?= $sub_cates['displayName']; ?> Manufacturers in Surat" width="700" height="700">
                            </div>
                        </a>
                        <div class="new_desc">
                            <h4><a href="<?= site_url.'/'.strtolower($sub_cat_href); ?>.htm" title="<?= $sub_cates['displayName']; ?> Manufacturers in Surat"><?= $sub_cates['displayName']; ?></a></h4>

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


    <div class="advertisement_banner">
        <div class="container">
            <div class="row">
                <div class="col-lg-12">
                    <div class="advertisement-text">
                        <div class="title4">SALE <span>25%</span>OFF</div>
                        <p>Applying For All Products & Watches and Upto 40% Off Special Promo Stay Cosy With Extra 10%
                            to 20% Off Special Offer</p>
                        <a href="<?= site_url; ?>/contact.htm" class="shop_btn" title="Contact Us">Contact Us <i class="fa fa-long-arrow-right"></i></a>
                    </div>
                </div>
            </div>
        </div>
    </div>


    <div class="top_collection">
        <div class="container">
            <div class="title">TRENDING PRODUCTS</div>
             <p class="text-center mx-auto mb-3 w-75">
             Ignite your inner sparkle with the latest trends in jewelry. Shine with breathtaking halo rings and eternity bands, perfect for any celebration. Adorn your wrist with chic bangle bracelets or a sleek Cuban link bracelet. Make a statement with bold hip hop jewelry and eye-catching diamond pendants that elevate every outfit effortlessly!
             </p>
            <div class="row">
                <div class="col-lg-12 col-md-12">
                    <div id="shop_look" class="owl-carousel">
                        <?php
                        $res_popcat = $dbconn->query("select catName,displayName,catImage from category_tbl where catID='14' || catID='20' || catID='22' || catID='15' || catID='18' || catID='16' || catID='23'");
                        if($res_popcat->num_rows > 0){
                            while($pop_category = $res_popcat->fetch_assoc()){
                            $pop_cate_href = str_ireplace(" ", "-", $pop_category['catName']);

                    ?>
                        <div class="content-box">
                            <div class="image-cat">
                                <a href="<?= site_url.'/'.strtolower($pop_cate_href); ?>.htm" title="<?= $pop_category['displayName']; ?> Manufacturers in Surat">
                                    <img src="<?= getImage($pop_category['catImage'], 215, 215, $pop_category['catName'], "/uploaded-files/category/images/"); ?>" alt="<?= $pop_category['displayName']; ?> Manufacturers in Surat" title="<?= $pop_category['displayName']; ?> Manufacturers in Surat" width="700" height="700">
                                </a>
                            </div>
                            <div class="cat-title">
                                <a href="<?= site_url.'/'.strtolower($pop_cate_href); ?>.htm" title="<?= $pop_category['displayName']; ?> Manufacturers in Surat"><?= $pop_category['displayName']; ?></a>
                            </div>
                        </div>
                        <?php } } ?>

                    </div>

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

    <section class="trending_products">
        <div class="container">
            <div class="title">Rings Collections</div>
             <p class="text-center mx-auto mb-3 w-75">
             Celebrate love with an exquisite selection of rings. Timeless solitaire and stunning three-stone rings symbolize your unique journey. Elegant engagement, anniversary, and wedding rings honor special milestones. Adorn your finger with a radiant halo ring or an everlasting eternity band—each piece crafted to capture moments that last a lifetime, perfect for every occasion.
                </p>
            <div class="row justify-content-center">
                <?php
                    $res_ringcat = $dbconn->query("select catName,displayName,catImage from category_tbl where parentID='1'");
                    if($res_ringcat->num_rows > 0){
                        while($pop_category = $res_ringcat->fetch_assoc()){
                        $pop_cate_href = str_ireplace(" ", "-", $pop_category['catName']);

                ?>
                <div class="col-lg-3 col-md-3">
                    <div class="product1">
                        <a href="<?= site_url.'/'.strtolower($pop_cate_href); ?>.htm" title="<?= $pop_category['displayName']; ?> Manufacturers in Surat">
                            <div class="image01">
                                <img src="<?= getImage($pop_category['catImage'], 280, 280, $pop_category['catName'], "/uploaded-files/category/images/"); ?>" alt="<?= $pop_category['displayName']; ?> Manufacturers in Surat" title="<?= $pop_category['displayName']; ?> Manufacturers in Surat" width="700" height="700">
                            </div>
                        </a>
                        <div class="new_desc">
                            <h4><a href="<?= site_url.'/'.strtolower($pop_cate_href); ?>.htm" title="<?= $pop_category['displayName']; ?> Manufacturers in Surat"><?= $pop_category['displayName']; ?></a></h4>
                        </div>
                    </div>
                </div>
                <?php } } ?>
            </div>
        </div>
    </section>

    <?php
        $res_blog = $dbconn->query("select catID,catName,blogDname,catImage,blogDate,catDesc from blog_tbl order by catID desc limit 3");
        if($res_blog->num_rows > 0){
    ?>
    <section class="home_blog1">
        <div class="container">
            <div class="title">Latest Blogs</div>
             <p class="text-center mx-auto mb-3 w-75">
             Stay updated with the latest trends and tips in the world of jewelry. Explore insightful articles on choosing the perfect engagement ring, caring for your precious pieces, and styling statement accessories. From the significance of birthstones to the art of layering necklaces, these blogs offer inspiration and guidance for every jewelry lover's journey.
                 </p>
            <div class="row">
                <?php
                    $sno = 1;
                    while($blogs = $res_blog->fetch_assoc()){
                    $blog_href = str_ireplace(" ", "-", $blogs['catName']);
                    $sno++;
                ?>
                <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-12 col-12">
                    <div class="home_blog">

                        <div class="image">
                            <a href="<?= site_url; ?>/blog/<?= strtolower($blog_href); ?>.htm" title="<?= $blogs['blogDname']; ?>">
                                <img src="<?= site_url; ?>/uploaded-files/blog/images/<?= $blogs['catImage']; ?>" alt="<?= $blogs['blogDname']; ?>" title="<?= $blogs['blogDname']; ?>" width="1200" height="800">
                            </a>
                        </div>

                        <div class="blog-discp">
                            <h5><a href="<?= site_url; ?>/blog/<?= strtolower($blog_href); ?>.htm" title="<?= $blogs['blogDname']; ?>"><?= $blogs['blogDname']; ?></a></h5>
                            <p><?= substr_replace($blogs['catDesc'], '...', '100'); ?></p>
                        </div>

                    </div>
                </div>
                <?php } ?>
            </div>
        </div>
    </section>
    <?php } ?>
    <div class="clearfix"></div>
    <div class="videoSection">
        <div class="container">
            <div class="title">Check Out Our Latest Jewelry Creations</div>
             <p class="text-center mx-auto mb-3 w-75">
             Immerse yourself in elegance with our latest jewelry creations! Discover stunning designs featuring exquisite rings, necklaces, and bracelets that elevate any outfit. Watch as we unveil unique pieces crafted with precision and care. Join us for styling tips, behind-the-scenes insights, and the inspiration that brings each piece to life!
             </p>
            <div class="row">

            <?php
                                        $video_sql = mysqli_query($GLOBALS['dbconn'], "select slink_title, slink_url from video_tbl");
                                        while ($video_res = mysqli_fetch_array($video_sql)) { ?>
                <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-12 col-12 text-center">
                     <div class="videoFeedback">
                        <a data-fancybox="" href="https://youtu.be/<?=$video_res['slink_url'];?>?si=O4CdwhK3_I7m7uOa" title="<?=$video_res['slink_title'];?>">
                            <div class="image">
                                <img src="https://img.youtube.com/vi/<?=$video_res['slink_url'];?>/hqdefault.jpg" alt="<?=$video_res['slink_title'];?>" title="<?=$video_res['slink_title'];?>">
                                <span>
                                    <svg viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg">
                                        <path d="M17.13 7.9799C20.96 10.1899 20.96 13.8099 17.13 16.0199L14.04 17.7999L10.95 19.5799C7.13 21.7899 4 19.9799 4 15.5599V11.9999V8.43989C4 4.01989 7.13 2.2099 10.96 4.4199L13.21 5.7199" stroke="currentColor" stroke-width="1.5" stroke-miterlimit="10" stroke-linecap="round" stroke-linejoin="round"></path>
                                    </svg>
                                </span>
                            </div>
                            <div class="videoTitle">
                                <div class="videoName"> <?=$video_res['slink_title'];?> </div>
                            </div>
                        </a>
                    </div>

                </div>
                <?php } ?>

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




    <?php include 'app_footer.php';?>
    <?php include 'app_bottom.php';?>
</body>

</html>
