<?php
include_once('include/main.inc.php');
$hover = "home";
$homepage = mysqli_query($GLOBALS['dbconn'], "select pageDesc,pageDesc1,pageDesc2,pageTitle, pageImage, page_keyword, page_metadesc, page_metatitle, pageBanner,keyword1,keyword2 from static_pages where pageID='1' and status='Y'");
$home_res = mysqli_fetch_array($homepage);
if ($home_res['keyword1'] != '' && $home_res['keyword2'] != '') {
  $m_title = "hotkeyword1 Manufacturers in state, Wholesale hotkeyword2 Suppliers, Exporters country";
  $page_metatitle = str_replace('hotkeyword1', $home_res['keyword1'], str_replace('hotkeyword2', $home_res['keyword2'],  str_replace('state', $admin_res['targetlocation'], str_replace('country', $admin_res['country'], $m_title))));
  $m_keyword = "hotkeyword1 Manufacturers, hotkeyword2 Manufacturers, hotkeyword1 Suppliers, hotkeyword2 Suppliers, hotkeyword1 Exporters, hotkeyword2 Exporters, hotkeyword1, hotkeyword2";
  $page_metakey = str_replace('hotkeyword1', $home_res['keyword1'], str_replace('hotkeyword2', $home_res['keyword2'],  str_replace('state', $admin_res['targetlocation'], $m_keyword)));
  $m_desc = "companyName leading hotkeyword1 Manufacturers in state. Best Quality hotkeyword2 Suppliers and Exporters in country at Factory Price. Call phone";
  $page_metadesc = str_replace('hotkeyword1', $home_res['keyword1'], str_replace('hotkeyword2', $home_res['keyword2'], str_replace('companyName', $admin_res['companyName'], str_replace('phone', $admin_res['mobile_meta'], str_replace('state', $admin_res['targetlocation'], str_replace('country', $admin_res['country'], $m_desc))))));
} else {
  $page_metatitle = $home_res['page_metatitle'];
  $page_metakey = $home_res['page_keyword'];
  $page_metadesc = $home_res['page_metadesc'];
}
$page_desc = $home_res['pageDesc1'];
$page_desc = str_ireplace('{companyName}', $admin_res['companyName'], $page_desc);
$page_desc2nd = $home_res['pageDesc2'];
$page_desc2nd = str_ireplace('{companyName}', $admin_res['companyName'], $page_desc2nd);
$page_metadesc = str_ireplace('{companyName}', $admin_res['companyName'], $page_metadesc);
$video_sql = mysqli_query($dbconn, "select * from video_tbl  limit 0,2");
$blog = mysqli_query($GLOBALS['dbconn'], "select blogDate,catImage,catName,blogDname,catDesc,blog_written from blog_tbl order by catID DESC  limit 0,2");
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">

    <?php include 'app_top.php'; ?>
</head>

<body>
    <?php include 'app_header.php'; ?>
    <main>
        <div id="carouselExampleAutoplaying" class="carousel slide carousel-fade" data-bs-ride="carousel"
            data-bs-interval="4000" data-bs-pause="false">
            <div class="carousel-inner">
                <?php
        $i = 1;
        $sql_banner = mysqli_query($GLOBALS['dbconn'], "Select bannerImage, personName from banner_tbl where status='Y'");
        while ($res_banner = mysqli_fetch_array($sql_banner)) { ?>
                <div class="carousel-item <?= $i == '1' ? 'active' : ''; ?>">

                    <picture>
                        <source media="(max-width:650px)"
                            srcset="<?= getImage($res_banner['bannerImage'], 700, 346, $res_banner['personName'], "/uploaded-files/banner-image/"); ?>"
                            title="<?= $res_banner['personName']; ?> in <?= $admin_res['targetlocation']; ?>">
                        <img width="1920" height="950" fetchpriority="high"
                            src="<?= site_url; ?>/uploaded-files/banner-image/<?= $res_banner['bannerImage']; ?>"
                            alt="<?= $res_banner['personName']; ?> in <?= $admin_res['targetlocation']; ?>"
                            title="<?= $res_banner['personName']; ?> in <?= $admin_res['targetlocation']; ?>"
                            class="d-block w-100">
                    </picture>
                    <!-- <img <?= $i == '1' ? '' : 'loading="lazy"'; ?>  src="<?= site_url; ?>/uploaded-files/banner-image/<?= $res_banner['bannerImage']; ?>" alt="<?= $res_banner['personName']; ?> in <?= $admin_res['targetlocation']; ?>" title="<?= $res_banner['personName']; ?> in <?= $admin_res['targetlocation']; ?>" class="d-block w-100"> -->
                </div>
                <?php $i++;
        } ?>

            </div>
            <button class="carousel-control-prev" type="button" data-bs-target="#carouselExampleAutoplaying"
                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="#carouselExampleAutoplaying"
                data-bs-slide="next">
                <span class="carousel-control-next-icon" aria-hidden="true"></span>
                <span class="visually-hidden">Next</span>
            </button>
        </div>
    </main>
    <div class="add-banner">
        <div class="container">
            <div class="row g-2 align-items-center">
                <div class="col-lg-5 col-12">
                    <h1 class="tt">Love Problem Solution Astrologer in India</h1>
                </div>
                <div class="col-lg-7 col-12">
                    <div class="tt2 justify-content-md-end">
                        <span>
                            <svg height="35px" width="35px" version="1.1" id="_x32_" xmlns="http://www.w3.org/2000/svg"
                                xmlns:xlink="http://www.w3.org/1999/xlink" viewBox="0 0 512 512" xml:space="preserve"
                                fill="#fff">
                                <g stroke-width="0"></g>
                                <g stroke-linecap="round" stroke-linejoin="round"></g>
                                <g>
                                    <style type="text/css">
                                    .st0 {
                                        fill: currentColor;
                                    }
                                    </style>
                                    <g>
                                        <path class="st0"
                                            d="M337.168,289.578c-5.129-5.133-13.457-5.133-18.598,0l-16.031,16.038c-4.68,4.68-12.122,5.149-17.352,1.102 c0,0-15.332-10.109-40.402-35.179c-25.07-25.07-35.175-40.414-35.175-40.414c-4.055-5.226-3.578-12.656,1.102-17.343l16.031-16.031 c5.141-5.134,5.141-13.462,0-18.594l-35.34-35.343c-5.133-5.133-13.453-5.133-18.594,0c-0.122,0.125-1.906,1.906-21.309,21.32 c-22.602,22.594,7.293,91.82,57.574,142.118c50.289,50.281,119.527,80.164,142.121,57.578 c19.394-19.406,21.184-21.203,21.305-21.32c5.141-5.133,5.141-13.461,0-18.586L337.168,289.578z">
                                        </path>
                                        <path class="st0"
                                            d="M256,0C114.614,0,0,114.617,0,256s114.614,256,256,256s256-114.617,256-256S397.386,0,256,0z M256,472 c-119.102,0-216-96.898-216-216S136.898,40,256,40s216,96.898,216,216S375.102,472,256,472z">
                                        </path>
                                    </g>
                                </g>
                            </svg> Call Us: <a href="tel:<?= $admin_res['mobile']; ?>"
                                title="Call us"><?= $admin_res['mobile']; ?></a></span>
                        <span>or</span>
                        <button data-bs-toggle="modal" data-bs-target="#sendEnquiry" class="main-btn dark">Consult With
                            Astrologer</button>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="section">
        <div class="container">
            <div class="row row-cols-2 row-cols-lg-4 g-4 mb-5">
                <div class="col">
                    <div class="feature-bx">
                        <div class="icon">
                            <img loading="lazy" src="<?= site_url; ?>/designer/images/icon/Experienced-Astrologers.png"
                                alt="Experienced Astrologer" title="Experienced Astrologer">
                        </div>
                        <div class="tt">Experienced Astrologer</div>
                    </div>
                </div>
                <div class="col">
                    <div class="feature-bx">
                        <div class="icon">
                            <img loading="lazy" src="<?= site_url; ?>/designer/images/icon/Confidential-&-Secure.png"
                                alt="100% Confidential & Secure" title="100% Confidential & Secure">
                        </div>
                        <div class="tt">100% Confidential & Secure</div>
                    </div>
                </div>
                <div class="col">
                    <div class="feature-bx">
                        <div class="icon">
                            <img loading="lazy"
                                src="<?= site_url; ?>/designer/images/icon/Convenient-Online-Consultations.png"
                                alt="Online Consultations" title="Online Consultations">
                        </div>
                        <div class="tt">Online Consultations</div>
                    </div>
                </div>
                <div class="col">
                    <div class="feature-bx">
                        <div class="icon">
                            <img loading="lazy" src="<?= site_url; ?>/designer/images/icon/Proven-Results.png"
                                alt="Proven Results" title="Proven Results">
                        </div>
                        <div class="tt">Proven Results</div>
                    </div>
                </div>
            </div>
            <div class="abt-sec">
                <div class="main-tt">How Can Astrologer Arjun Shastri Help in <span> Regaining Lost Love?</span></div>
                <div class="img">
                    <!-- <img src="<?= site_url; ?>/designer/images/abt/abt.jpg" alt="abcd in <?= $admin_res['targetlocation']; ?>" title="abcd in <?= $admin_res['targetlocation']; ?>"> -->
                    <img loading="lazy"
                        src="<?= getImage($home_res['pageImage'], 800, 800, $home_res['pageTitle'], "/uploaded-files/page-images/"); ?>"
                        alt="Love Problem Solution Astrologer in <?= $admin_res['targetlocation']; ?>"
                        title="Love Problem Solution Astrologer in <?= $admin_res['targetlocation']; ?>" width="800" height="800">

                </div>
                <div class="content-sec">
                    <?= html_entity_decode($page_desc); ?>
                </div>
                <div class="clearfix"></div>
            </div>
        </div>
    </div>
    <div class="section services-sec">
        <div class="container">
            <div class="heading-sec">
                <div class="subtt">we have one of the best services for you</div>
                <div class="main-tt">Swift Guidance for Life's Challenges</div>
                <p>When life’s challenges feel overwhelming, Astrologer Arjun Shastri offers swift, insightful guidance.
                    His expert solutions provide clarity and direction, empowering you to make confident decisions. With
                    timely support, confusion transforms into confidence, guiding you toward a brighter, more peaceful
                    future. Trust in the wisdom that leads to lasting harmony and fulfillment.</p>
            </div>
            <div class="row g-4 row-cols-1 row-cols-md-2 row-cols-lg-3">
                <div class="col">
                    <div class="services-column">
                        <div class="tt"><span class="icon"><svg xmlns="http://www.w3.org/2000/svg" width="16"
                                    height="16" fill="currentColor" class="bi bi-star-fill" viewBox="0 0 16 16">
                                    <path
                                        d="M3.612 15.443c-.386.198-.824-.149-.746-.592l.83-4.73L.173 6.765c-.329-.314-.158-.888.283-.95l4.898-.696L7.538.792c.197-.39.73-.39.927 0l2.184 4.327 4.898.696c.441.062.612.636.282.95l-3.522 3.356.83 4.73c.078.443-.36.79-.746.592L8 13.187l-4.389 2.256z" />
                                </svg></span> Astrology Services</div>
                        <ul class="service-list">
                            <?php
              $home_cat11 = mysqli_query($GLOBALS['dbconn'], "select catImage, catName, displayName,catDesc,catUrl from category_tbl where parentID='1' and status='Y' order by catOrder asc limit 0,8");
              while ($home_cat_res2 = mysqli_fetch_assoc($home_cat11)) {
                if ($home_cat_res2['catImage'] != '') {
                  $imglink = getImage($home_cat_res2['catImage'], 500, 500, $home_cat_res2['catName'], "/uploaded-files/category/images/");
                } else {
                  $imglink = site_url . "/uploaded-files/category/images/noimage(1).jpg";
                }
                $caturls = $home_cat_res2['catUrl'] != '' ? $home_cat_res2['catUrl'] : $home_cat_res2['catName'];
                $short_desc = str_ireplace('{companyName}', $admin_res['companyName'], $home_cat_res2['catDesc']);
              ?>
                            <li><a href="<?= site_url; ?>/<?= getValidFileName($caturls); ?>.htm"
                                    title="<?= $home_cat_res2['displayName']; ?> in <?= $admin_res['targetlocation']; ?>"><?= $home_cat_res2['displayName']; ?></a>
                            </li>
                            <?php } ?>

                        </ul>
                        <button class="read-more-btn">View More</button>
                    </div>
                </div>
                <div class="col">
                    <div class="services-column">
                        <div class="tt"><span class="icon"><svg xmlns="http://www.w3.org/2000/svg" width="16"
                                    height="16" fill="currentColor" class="bi bi-star-fill" viewBox="0 0 16 16">
                                    <path
                                        d="M3.612 15.443c-.386.198-.824-.149-.746-.592l.83-4.73L.173 6.765c-.329-.314-.158-.888.283-.95l4.898-.696L7.538.792c.197-.39.73-.39.927 0l2.184 4.327 4.898.696c.441.062.612.636.282.95l-3.522 3.356.83 4.73c.078.443-.36.79-.746.592L8 13.187l-4.389 2.256z" />
                                </svg></span> Astrology Remedies</div>
                        <ul class="service-list">
                            <?php
              $home_cat11 = mysqli_query($GLOBALS['dbconn'], "select catImage, catName, displayName,catDesc,catUrl from category_tbl where parentID='2' and status='Y' order by catOrder asc limit 0,8");
              while ($home_cat_res2 = mysqli_fetch_assoc($home_cat11)) {
                if ($home_cat_res2['catImage'] != '') {
                  $imglink = getImage($home_cat_res2['catImage'], 500, 500, $home_cat_res2['catName'], "/uploaded-files/category/images/");
                } else {
                  $imglink = site_url . "/uploaded-files/category/images/noimage(1).jpg";
                }
                $caturls = $home_cat_res2['catUrl'] != '' ? $home_cat_res2['catUrl'] : $home_cat_res2['catName'];
                $short_desc = str_ireplace('{companyName}', $admin_res['companyName'], $home_cat_res2['catDesc']);
              ?>
                            <li><a href="<?= site_url; ?>/<?= getValidFileName($caturls); ?>.htm"
                                    title="<?= $home_cat_res2['displayName']; ?> in <?= $admin_res['targetlocation']; ?>"><?= $home_cat_res2['displayName']; ?></a>
                            </li>
                            <?php } ?>
                        </ul>
                        <button class="read-more-btn">View More</button>
                    </div>

                </div>
                <div class="col">
                    <div class="services-column">
                        <div class="tt"><span class="icon"><svg xmlns="http://www.w3.org/2000/svg" width="16"
                                    height="16" fill="currentColor" class="bi bi-star-fill" viewBox="0 0 16 16">
                                    <path
                                        d="M3.612 15.443c-.386.198-.824-.149-.746-.592l.83-4.73L.173 6.765c-.329-.314-.158-.888.283-.95l4.898-.696L7.538.792c.197-.39.73-.39.927 0l2.184 4.327 4.898.696c.441.062.612.636.282.95l-3.522 3.356.83 4.73c.078.443-.36.79-.746.592L8 13.187l-4.389 2.256z" />
                                </svg></span> More Services</div>
                        <ul class="service-list">
                            <?php
              $home_cat11 = mysqli_query($GLOBALS['dbconn'], "select catImage, catName, displayName,catDesc,catUrl from category_tbl where parentID='3' and status='Y' order by catOrder asc limit 0,8");
              while ($home_cat_res2 = mysqli_fetch_assoc($home_cat11)) {
                if ($home_cat_res2['catImage'] != '') {
                  $imglink = getImage($home_cat_res2['catImage'], 500, 500, $home_cat_res2['catName'], "/uploaded-files/category/images/");
                } else {
                  $imglink = site_url . "/uploaded-files/category/images/noimage(1).jpg";
                }
                $caturls = $home_cat_res2['catUrl'] != '' ? $home_cat_res2['catUrl'] : $home_cat_res2['catName'];
                $short_desc = str_ireplace('{companyName}', $admin_res['companyName'], $home_cat_res2['catDesc']);
              ?>
                            <li><a href="<?= site_url; ?>/<?= getValidFileName($caturls); ?>.htm"
                                    title="<?= $home_cat_res2['displayName']; ?> in <?= $admin_res['targetlocation']; ?>"><?= $home_cat_res2['displayName']; ?></a>
                            </li>
                            <?php } ?>

                        </ul>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="section py-0">
        <picture>
      <source media="(max-width:650px)" srcset="<?= site_url; ?>/designer/images/body-bg-mob.jpg" 
         title="Love Marriage Problem Solution in <?= $admin_res['targetlocation']; ?>">
         <img loading="lazy" src="<?= site_url; ?>/designer/images/body-bg.jpg"
            alt="Love Marriage Problem Solution in <?= $admin_res['targetlocation']; ?>"
            title="Love Marriage Problem Solution in <?= $admin_res['targetlocation']; ?>" class="d-block w-100" width="1920" height="801">
   </picture>

  

    </div>
    <div class="section">
        <div class="container">
            <div class="head-sec text-start">
                <div class="tt">What <span>We Offer</span></div>
                <p>Step into a realm of celestial guidance where your life's challenges find clarity. Specializing in
                    love, marriage, family, career, and health, we provide personalized solutions that bring
                    transformation. Combining ancient wisdom with modern insights, we help restore balance, overcome
                    obstacles, and unlock your true potential for a fulfilled and harmonious life.
                </p>
            </div>
            <div class="row g-4 row-cols-1 row-cols-lg-3">
                <?php
        $home_cat11 = mysqli_query($GLOBALS['dbconn'], "select catImage, catName, displayName, catDesc, catID,catBanner from category_tbl where parentID='2'  and status='Y' order by catOrder asc limit 0,8");
        while ($home_cat_res2 = mysqli_fetch_assoc($home_cat11)) {
          if ($home_cat_res2['catImage'] != '') {
            $imglink = getImage($home_cat_res2[catImage], 500, 500, $home_cat_res2[catName], "/uploaded-files/category/images/");
          } else {
            $imglink = site_url . "/uploaded-files/category/images/noimage.jpg";
          }
          $short_desc = str_ireplace('{companyName}', $admin_res['companyName'], $home_cat_res2['catDesc']);
        ?>
                <div class="col">
                    <div class="ser-bx">
                        <a href="<?= site_url; ?>/<?= getValidFileName($home_cat_res2['catName']); ?>.htm"
                            title="<?= $home_cat_res2['displayName']; ?> in <?= $admin_res['targetlocation']; ?>"
                            class="img">
                            <img loading="lazy" src="<?= $imglink; ?>"
                                alt="<?= $home_cat_res2['displayName']; ?> in <?= $admin_res['targetlocation']; ?>"
                                title="<?= $home_cat_res2['displayName']; ?> in <?= $admin_res['targetlocation']; ?>" width="500" height="500">
                        </a>
                        <div class="tx-bx">
                            <h4 class="tt"><?= $home_cat_res2['displayName']; ?></h4>
                            <a href="<?= site_url; ?>/<?= getValidFileName($home_cat_res2['catName']); ?>.htm"
                                title="View More">View More <svg fill="currentColor" width="20" height="20"
                                    viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg" class="icon line">
                                    <path d="M3,12H21m-3,3,3-3L18,9"
                                        style="fill: none; stroke: currentColor; stroke-linecap: round; stroke-linejoin: round; stroke-width: 1;">
                                    </path>
                                </svg></a>
                        </div>
                    </div>
                </div>
                <?php } ?>

            </div>
        </div>
    </div>
    <?php include 'app_videos.php'; ?>
    <?php include 'app_testimonial.php'; ?>
    <div class="section bg-light">
        <div class="container">
            <div class="head-sec">
                <div class="tt">Our <span>Blogs</span></div>
                <p>Tap into a wealth of astrological wisdom with our thoughtfully written blogs. Covering everything
                    from love and relationships to career and personal growth, each post delivers practical insights and
                    transformative solutions. Gain the knowledge to navigate life's challenges and make empowered
                    choices that lead to a more fulfilled and harmonious life.</p>
            </div>
            <div class="row g-4 row-cols-1 row-cols-md-2 row-cols-lg-2">
                <?php while ($blog_res = mysqli_fetch_array($blog)) {
          if ($blog_res['catImage'] != '') {
            $blog_img =  getImage($blog_res['catImage'], 400, 225, $blog_res['catName'], "/uploaded-files/blog/images/");
            $blog_img1 =  getImage($blog_res['catImage'], 400, 225, $blog_res['catName'], "/uploaded-files/blog/images/");
          } else {
            $blog_img = NO_IMG_URL;
            $blog_img1 = NO_IMG_URL;
          }
          $blog_shortdesc = str_ireplace('{companyName}', $admin_res['companyName'], $blog_res['catDesc']); ?>
                <div class="col">
                    <div class="blog-bx">
                        <a href="<?= site_url; ?>/blog/<?= getValidFileName($blog_res['catName']); ?>.htm"
                            title="<?= $blog_res['blogDname']; ?>" class="img-bx">
                            <img loading="lazy" src="<?= $blog_img; ?>" alt="<?= $blog_res['blogDname']; ?>"
                                title="<?= $blog_res['blogDname']; ?>" width="400" height="225">
                        </a>
                        <div class="tx-bx">
                            <h5 class="tt"><a
                                    href="<?= site_url; ?>/blog/<?= getValidFileName($blog_res['catName']); ?>.htm"
                                    title="<?= $blog_res['blogDname']; ?>"><?= $blog_res['blogDname']; ?></a></h5>
                            <p><?= substr($blog_shortdesc, 0, 200); ?>...</p>
                            <a href="<?= site_url; ?>/blog/<?= getValidFileName($blog_res['catName']); ?>.htm"
                                title="<?= $blog_res['blogDname']; ?>" class="read-mr">View More <svg
                                    fill="currentColor" width="20" height="20" viewBox="0 0 24 24"
                                    xmlns="http://www.w3.org/2000/svg" class="icon line">
                                    <path d="M3,12H21m-3,3,3-3L18,9"
                                        style="fill: none; stroke: currentColor; stroke-linecap: round; stroke-linejoin: round; stroke-width: 1;">
                                    </path>
                                </svg></a>
                        </div>
                    </div>
                </div>
                <?php } ?>

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

</html>