<?php

include_once("include/main.inc.php");

$page_metatitle = "Astrologer Arjun Shastri – Black Magic Remedy Astrologers in India, Available in Your Area";

$page_metakey = "Black Magic Remedy Astrologers in India, Black Magic Removal Expert, Astrologer Arjun Shastri, Black Magic Solutions India, Best Black Magic Astrologer, Black Magic Problem Solution, Online Black Magic Remedy, Astrologer for Black Magic in India, Vashikaran and Black Magic Expert, Remove Negative Energy Astrologer";

$page_metadesc = "Astrologer Arjun Shastri, a trusted Black Magic Remedy Astrologer in India, offers effective solutions for black magic problems in your area. Get in touch today!";

?>
<!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'; ?>
  <div class="img-breadcum" style="background-image: url(designer/images/market.jpg);">
    <div class="container">
      <div class="tt">Market - Astrologer Arjun Shastri</div>
    </div>
  </div>
  <div class="breadcum-sec">
    <div class="container">
      <ul>
        <li><a href="<?=site_url;?>">Home</a></li>
        <li>Market Area</li>
      </ul>
    </div>
  </div>

  <div class="market-sec">
    <div class="container">
      <div class="head-sec mb-4">
        <div class="tt">Market <span>Area</span></div>
      </div>
      <?php 
            $sql_loc=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID,loc_url from location_tbl where parentID='0' and status='Y' order by locationName asc");
            if(mysqli_num_rows($sql_loc)>'1'){
                ?>   
      <h1 class="main-tt">Countries</h1>
      <?php }else{ ?>
      <h1 class="main-tt">Market Area</h1>
      <?php } ?>
      <div class="row g-2 row-cols-2 row-cols-md-4 row-cols-lg-5">
  
      <?php
while($res_loc=mysqli_fetch_array($sql_loc)) {  
    $loc_url=$res_loc['loc_url']?$res_loc['loc_url']:$res_loc['locationName'];
    ?>
        <div class="col">
       
          <a href="<?=site_url;?>/<?php echo getValidFileName($loc_url); ?>/" title="<?php echo $res_loc['locationName'];?>" class="market-bx"><?php echo $res_loc['locationName'];?></a>
          
        </div>
        <?php } ?>
       
      </div>
  
      <h2>States of India</h2>
      <div class="row g-2 row-cols-2 row-cols-md-4 row-cols-lg-5">
      <?php
$sql_locsss=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID,loc_url from location_tbl where parentID='1' and status='Y' order by locationName asc");
while($res_locsss=mysqli_fetch_array($sql_locsss)) { 
    $loc_url1=$res_locsss['loc_url']?$res_locsss['loc_url']:$res_locsss['locationName'];
    ?>
        <div class="col">
          <a href="<?=site_url;?>/<?php echo getValidFileName(strtolower($loc_url1)); ?>/"  title="<?php echo $res_locsss['locationName'];?>" class="market-bx"><?php echo $res_locsss['locationName'];?></a>
        </div>
        <?php } ?>
       

      </div>

      <?php
$sql_loccc=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID,loc_url from location_tbl where parentID ='1' order by locationName asc");
while($res_loccc=mysqli_fetch_array($sql_loccc))
{
$locationID=$res_loccc['locationID'];
$sql_loc1=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID,loc_url from location_tbl where parentID ='$locationID' and status='Y' order by locationName asc");
if (mysqli_num_rows($sql_loc1) > 0)
{
?>
      <h3>Cities of <?php echo $res_loccc['locationName']; ?></h3>
      <div class="row g-2 row-cols-2 row-cols-md-4 row-cols-lg-5">
      <?php while($res_locfinal=mysqli_fetch_array($sql_loc1))  {
                       $loc_url2=$res_locfinal['loc_url']?$res_locfinal['loc_url']:$res_locfinal['locationName'];
                       ?>
        <div class="col">
          <a href="<?=site_url;?>/<?php echo getValidFileName(strtolower($loc_url2)); ?>/" title="<?php echo $res_locfinal['locationName']; ?>" class="market-bx"><?php echo $res_locfinal['locationName']; ?></a>
        </div>
        <?php } ?>
      </div>
      <?php } } ?>

      <?php
$sql_loccc=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID,loc_url from location_tbl where parentID ='0' && locationID != '1' order by locationName asc");
while($res_loccc=mysqli_fetch_array($sql_loccc))
{
$locationID=$res_loccc['locationID'];
$sql_loc1=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID,loc_url from location_tbl where parentID ='$locationID' and status='Y' order by locationName asc");
if (mysqli_num_rows($sql_loc1) > 0)
{
?>
      <h2>Cities of <?php echo $res_loccc['locationName']; ?></h2>
      <div class="row g-2 row-cols-2 row-cols-md-4 row-cols-lg-5">
      <?php while($res_locfinal=mysqli_fetch_array($sql_loc1))  {
                       $loc_url2=$res_locfinal['loc_url']?$res_locfinal['loc_url']:$res_locfinal['locationName'];
                       ?>
        <div class="col">
          <a href="<?=site_url;?>/<?php echo getValidFileName(strtolower($loc_url2)); ?>/" title="<?php echo $res_locfinal['locationName']; ?>" class="market-bx"><?php echo $res_locfinal['locationName']; ?></a>
        </div>
        <?php } ?>
      </div>
      <?php } } ?>

    </div>
  </div>

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

</html>