<?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);
@extract($_REQUEST);
   $loc_url=$_REQUEST['cid'];
      $sql_locas=mysqli_query($GLOBALS['dbconn'], "select locationID,locationName,loc_url from location_tbl where loc_url='$loc_url' and status='Y'");
      $location = mysqli_fetch_array($sql_locas);
      $location_id = $location['locationID']; 
      $locationName= $location['locationName'];
      $category_sub_general=mysqli_query($GLOBALS['dbconn'],"select location_ids,meta_title,meta_keyword,meta_description,description,description2,short_description from location_content_tbl where category_id='0' AND location_id='0'");
      $content_count = mysqli_num_rows($category_sub_general);
      if($content_count > 0){
          while($categorysubdomain=mysqli_fetch_array($category_sub_general)){
              $locati = explode(",", $categorysubdomain['location_ids']);
              if(in_array($location_id, $locati)){
                  if($categorysubdomain['meta_title'] != ''){
                      $page_metatitle=$categorysubdomain['meta_title'];
                  }
                  if($categorysubdomain['meta_keyword'] != ''){
                      $page_metakey=$categorysubdomain['meta_keyword'];
                  }
                  if($categorysubdomain['meta_description']){
                      $page_metadesc=$categorysubdomain['meta_description'];
                  }
                  $page_desc=html_entity_decode($categorysubdomain['description']);
                  $page_desc1=html_entity_decode($categorysubdomain['description2']);
              }
          }
      //    specific location content
      }
      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', $locationName,str_replace('country', $locationName, $m_title))));
        $m_keyword="hotkeyword1 Manufacturers in state, hotkeyword2 Manufacturers in state, hotkeyword1 Suppliers in state, hotkeyword2 Suppliers in state, hotkeyword1 Exporters in state, hotkeyword2 Exporters in state, hotkeyword1, hotkeyword2";
        $page_metakey = str_replace('hotkeyword1',$home_res['keyword1'],str_replace('hotkeyword2', $home_res['keyword2'],  str_replace('state', $locationName, $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', $locationName,str_replace('country', $locationName,$m_desc))))));
    }
   $page_desc = str_replace('countryname',$locationName, $page_desc);
   $page_desc = str_replace('{location}',$locationName, $page_desc);
   $page_desc = str_replace('catname',$pid, $page_desc);
   $page_desc = str_ireplace('{companyName}',$admin_res['companyName'],$page_desc);
   $page_desc1 = str_replace('countryname',$locationName, $page_desc1);
   $page_desc1 = str_replace('{location}',$locationName, $page_desc1);
   $page_desc1 = str_replace('catname',$pid, $page_desc1);
   $page_desc1 = str_ireplace('{companyName}',$admin_res['companyName'],$page_desc1);
   $page_metatitle = str_replace('{location}',$locationName,$page_metatitle);
   $page_metakey = str_replace('{location}',$locationName,$page_metakey);
   $page_metadesc = str_replace('{location}',$locationName,$page_metadesc);
   $home_sub_uncheck_loc=mysqli_query($GLOBALS['dbconn'],"select description,description2,short_description,meta_title,meta_description,meta_keyword from location_content_tbl where category_id='0' AND location_id='0'");
   $home_sub_uncheck_res=mysqli_fetch_array($home_sub_uncheck_loc);
   $unchk_desc=$home_sub_uncheck_res['description'];
   $unchk_desc1=$home_sub_uncheck_res['description2'];
   $page_metatitle1=$home_sub_uncheck_res['meta_title'];
   $page_metakey1=$home_sub_uncheck_res['meta_keyword'];
   $page_metadesc1=$home_sub_uncheck_res['meta_description'];
   $unchk_desc = str_replace('{location}',$locationName,  $unchk_desc);
   $unchk_desc = str_ireplace('{companyName}',$admin_res['companyName'],$unchk_desc);
   $unchk_desc1 = str_replace('{location}',$locationName,  $unchk_desc1);
   $unchk_desc1 = str_ireplace('{companyName}',$admin_res['companyName'],$unchk_desc1);
   $page_metatitle1 = str_replace('{location}',$locationName,$page_metatitle1);
   $page_metakey1 = str_replace('{location}',$locationName,$page_metakey1);
   $page_metadesc1 = str_replace('{location}',$locationName,$page_metadesc1);
   $page_metatitle=($page_metatitle!='')?$page_metatitle:$page_metatitle1;
   $page_metakey=($page_metakey!='')? $page_metakey: $page_metakey1;
   $page_metadesc=($page_metadesc!='')?$page_metadesc:$page_metadesc1;
   if(mysqli_num_rows($sql_locas) > 0)
   {
   }else 
       {
       header("Location: ".site_url);
                   exit;
   }
   $page_metadesc=str_ireplace('{companyName}',$admin_res['companyName'],$page_metadesc);
   $page_desc2nd=$page_desc1!=''?$page_desc1:$unchk_desc1;
$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,4"); 
?>
<!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_sub.php'; ?>
  <main>
    <div id="carouselExampleAutoplaying" class="carousel slide carousel-fade" data-bs-ride="carousel" data-bs-interval="3000" 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' : ''; ?>">
          <img src="<?= site_url; ?>/uploaded-files/banner-image/<?= $res_banner['bannerImage']; ?>" alt="<?= $res_banner['personName']; ?> in <?=$locationName;?>" title="<?= $res_banner['personName']; ?> in <?=$locationName;?>" 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 <?=$locationName;?></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 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 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 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 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 You Navigate <span> Love, Energy, and Emotions?</span></div>
        <div class="img">
          <!-- <img src="<?= site_url; ?>/designer/images/abt/abt.jpg" alt="abcd in <?=$locationName;?>" title="abcd in <?=$locationName;?>"> -->
          <img src="<?=getImage($home_res['pageImage'], 800, 800, $home_res['pageTitle'], "/uploaded-files/page-images/");?>" alt="Love Problem Solution Astrologer in <?=$locationName;?>" title="Love Problem Solution Astrologer in <?=$locationName;?>">

        </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($loc_url); ?>/<?= getValidFileName($caturls); ?>.htm" title="<?= $home_cat_res2['displayName']; ?> in <?=$locationName;?>"><?= $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($loc_url); ?>/<?= getValidFileName($caturls); ?>.htm" title="<?= $home_cat_res2['displayName']; ?> in <?=$locationName;?>"><?= $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($loc_url); ?>/<?= getValidFileName($caturls); ?>.htm" title="<?= $home_cat_res2['displayName']; ?> in <?=$locationName;?>"><?= $home_cat_res2['displayName']; ?></a></li>
              <?php } ?>
            
            </ul>
          </div>
        </div>
      </div>
    </div>
  </div>
  <img src="<?= site_url; ?>/designer/images/body-bg.jpg" alt="Love Marriage Problem Solution in <?=$locationName;?>" title="Love Marriage Problem Solution in <?=$locationName;?>" class="d-block w-100">
  <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($loc_url); ?>/<?= getValidFileName($home_cat_res2['catName']); ?>.htm" title="<?= $home_cat_res2['displayName']; ?> in <?=$locationName;?>" class="img">
              <img src="<?= $imglink; ?>" alt="<?= $home_cat_res2['displayName']; ?> in <?=$locationName;?>"
                title="<?= $home_cat_res2['displayName']; ?> in <?=$locationName;?>">
            </a>
            <div class="tx-bx">
              <div class="tt"><?= $home_cat_res2['displayName']; ?></div>
              <a href="<?= site_url; ?>/<?= getValidFileName($loc_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>Lorem ipsum dolor sit amet consectetur adipisicing elit. Sit quae doloribus deserunt ipsum nulla quasi!</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 src="<?=$blog_img;?>" alt="<?= $blog_res['blogDname']; ?>" title="<?= $blog_res['blogDname']; ?>">
            </a>
            <div class="tx-bx">
              <div class="tt"><a href="<?= site_url; ?>/blog/<?= getValidFileName($blog_res['catName']); ?>.htm"
                                    title="<?= $blog_res['blogDname']; ?>"><?= $blog_res['blogDname']; ?></a></div>
                                    <p><?= substr($blog_shortdesc,0,200);?>...</p>
              <a href="<?= site_url; ?>/blog/<?= getValidFileName($blog_res['catName']); ?>.htm" title="<?= $blog_res['blogDname']; ?>" class="read-mr">Read 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_footer_sub.php'; ?>
  <?php include 'app_bottom.php'; ?>
</body>

</html>