במ12[cvbnvbnvbnvbnnmnnmnmnnmnmnmnmnmnmmnnmnmnmqewv;'

]]jkjjgdjffksdkdxmnnnnnnnnnnnmnmmnmnmnmnmbnwqeqwewqskfgj במ12[cvbnvbnvbnvbnnmnnmnmnnmnmnmnmnmnmmnnmnmnmqewv;'

<?php
   error_reporting(0);
   
   include_once 'Config.php';
   
   // Helper function to get base URL
   function base_url() {
       $protocol = (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off' || $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";
       return $protocol . $_SERVER['HTTP_HOST'];
   }
   
   // Get the current URL path
   $request_uri = $_SERVER['REQUEST_URI'];
   
   // Check if the URL ends with a trailing slash
   if (substr($request_uri, -1) == '/') {
       // Remove the trailing slash
       $new_url = rtrim($request_uri, '/');
   
       // Redirect to the new URL without the trailing slash
       header("Location: " . $new_url, true, 301); // 301 Moved Permanently
       exit();
   }
   
   // Get parameters and sanitize them
   $city_slug = isset($_GET['city_slug']) ? htmlspecialchars($_GET['city_slug'], ENT_QUOTES, 'UTF-8') : '';
   $location_slug = isset($_GET['location_slug']) ? htmlspecialchars($_GET['location_slug'], ENT_QUOTES, 'UTF-8') : '';
   $listing_slug = isset($_GET['listing_slug']) ? htmlspecialchars($_GET['listing_slug'], ENT_QUOTES, 'UTF-8') : '';
   $listing_id = isset($_GET['listing_id']) ? intval($_GET['listing_id']) : '';
   
   // Check if $listing_slug is 40 characters or less
   if (strlen($listing_slug) > 40) {
       // Handle the case where $listing_slug is more than 40 characters
       
        header("Location: " . $base_url . "/404");
exit();
}
if ($stmt = $mysqli->prepare("SELECT * FROM listing 
LEFT JOIN state ON listing.state_id = state.state_id 
LEFT JOIN city ON listing.city_id = city.city_id 
LEFT JOIN location ON listing.location_id = location.location_id 
WHERE city.city_slug = ? 
AND location.location_slug = ? 
AND listing.slug LIKE CONCAT(CAST(? AS CHAR CHARACTER SET utf8mb4), '%')
AND listing.listing_id = ?")) {
// Bind parameters   AND listing.slug LIKE CONCAT(?, '%') COLLATE utf8mb4_general_ci 
$stmt->bind_param("sssi", $city_slug, $location_slug, $listing_slug, $listing_id);
// Execute statement
$stmt->execute();
// Get result
$result = $stmt->get_result();
$listing_res = $result->fetch_assoc();
// Close statement
$stmt->close();
} else {
// Handle error
error_log("Failed to prepare statement: (" . $mysqli->errno . ") " . $mysqli->error);
exit();
}
// Check if the query was successful and if a result was found
if ($listing_res) {
// Process your result here, for example, display the result
// echo json_encode($listing_res);
} else {
// Handle case where no result was found by redirecting to 404 page
 header("Location: " . $base_url . "/404");
exit();
}
?>
<!DOCTYPE html>
<html lang="en">
   <head>
      <title><?php echo substr($listing_res['ad_title'],0,60);?>...</title>
      <meta name="title" content="<?php echo substr($listing_res['ad_title'],0,60);?>...">
      <meta name="description" content="<?php echo substr($listing_res['about'],0,150);?>...">
      <meta name="robots" content="index, follow">
      <meta name="language" content="English">
      <link rel="canonical" href="<?php echo $base_url;?>/call-girls/<?php echo $listing_res['city_slug'];?>/<?php echo $listing_res['location_slug'];?>/<?php echo $listing_slug;?>-<?php echo $listing_id;?>" />
      <link rel="alternate" href="<?php echo $base_url;?>/call-girls/<?php echo $listing_res['city_slug'];?>/<?php echo $listing_res['location_slug'];?>/<?php echo $listing_slug;?>-<?php echo $listing_id;?>" hreflang="en-in" />
      <link rel="alternate" href="<?php echo $base_url;?>/call-girls/<?php echo $listing_res['city_slug'];?>/<?php echo $listing_res['location_slug'];?>/<?php echo $listing_slug;?>-<?php echo $listing_id;?>" hreflang="hi-in" />
      <script type="application/ld+json">
         {
           "@context": "https://schema.org",
           "@type": "WebSite",
           "name": "Call Girls In <?php echo $listing_res['location_name']; ?> Cash On Delivery Call Girl 24x7",
           "url": "<?php echo $base_url;?>/",
           "potentialAction": {
             "@type": "SearchAction",
             "target": "<?php echo $base_url;?>/search/?q={search_term_string}",
             "query-input": "required name=search_term_string"
           }
         }
      </script>
     
<script async src="https://www.googletagmanager.com/gtag/js?id=G-D2F2L2E3ZK"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

gtag('config', 'G-D2F2L2E3ZK');
</script>
     
     
<script async src="https://www.googletagmanager.com/gtag/js?id=G-87C5VH4C98"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

gtag('config', 'G-87C5VH4C98');
</script>
      <meta charset="utf-8">
      <meta content="IE=Edge" http-equiv="X-UA-Compatible">
      <meta name="viewport" content="width=device-width, initial-scale=1.0" />
      <link rel="icon" href="<?php echo $base_url;?>/images/favicon.png" type="image/png">
      <link href="<?= $base_url; ?>/css/all.min.css" rel="stylesheet">
      <link href="<?php echo $base_url;?>/css/bootstrap.min.css" rel="stylesheet">
      <link rel="stylesheet" href="<?php echo $base_url;?>/css/profilepage.css">
   </head>
   <body>
      <?php include_once('includes/header.php'); ?>
      <section>
         <div class="container">
            <div class="card card-profile p-4">
               <div class="row">
                  <div class="col-md-4 text-center">
                     <img src="<?php echo $base_url;?>/admin/uploads/<?php echo $listing_res['main_image'];?>" alt="<?php echo $listing_res['ad_title']; ?>" class="img-profile">
                     <h1 class="fw-bold mt-3"><?php echo $listing_res['ad_title']; ?></h1>
                     <p class="mt-1 mb-0 text-center">
                        <strong>Age:</strong> <?php echo $listing_res['age']; ?>  | 
                        <strong>Gender:</strong> <?php echo $listing_res['gender']; ?>                        
                     </p>
                     <p class="text-center">
                        <strong>City:</strong> <?php echo $listing_res['city_name']; ?> | 
                        <strong>Area:</strong> <?php echo $listing_res['location_name']; ?>                       
                     </p>
                  </div>
                  <div class="col-md-8">
                     <div class="row">
                        <div class="col-md-6">
                           <a href="tel:+91<?php echo $listing_res['contact'];?>" class="mb-2 btn btn-contact btn-lg d-flex align-items-center justify-content-center">
                           <i class="fas fa-phone-alt me-2"></i> Call Now
                           </a>
                        </div>
                        <div class="col-md-6">
                           <a href="https://api.whatsapp.com/send?phone=91<?php echo $listing_res['whatsapp'];?>&amp;text=Hi, I want a service in <?php echo $listing_res['location_name'];?> (<?php echo $listing_res['city_name'];?>), found you on Cgnight.net" class="mb-2 btn btn-contact-whatsapp btn-lg d-flex align-items-center justify-content-center">
                           <i class="fab fa-whatsapp me-2"></i> WhatsApp Now
                           </a>
                        </div>
                     </div>
                     
                     <div class="section-content mt-4">
                        <h2>About Me</h2>
                        <p>
                           <?php echo $listing_res['about']; ?>             
                        </p>
                     </div>
                     <div class="mt-2">
                        <?php $services= explode(',',$listing_res['services']);?>
                        <?php foreach ($services as $key => $service) { ?>
                        <span class="badge badge-custom me-1"><?php echo $service;?></span>
                        <?php } ?>
                     </div>
                  </div>
               </div>
            </div>
         </div>
      </section>
      <section>
         <div class="container">
            <h2 class="text-center mb-4 localities-heading">Gallery</h2>
            <div class="row">
               <?php if(!empty($listing_res['image1'])){?>
               <div class="col-md-3 mb-3">
                  <img src="<?php echo $base_url;?>/admin/uploads/<?php echo $listing_res['image1'];?>" alt="<?php echo $listing_res['ad_title']; ?>" class="mx-auto d-block gallery-image">
               </div>
               <?php } ?>
               <?php if(!empty($listing_res['image2'])){?>
               <div class="col-md-3 mb-3">
                  <img src="<?php echo $base_url;?>/admin/uploads/<?php echo $listing_res['image2'];?>" alt="<?php echo $listing_res['ad_title']; ?>" class="mx-auto d-block gallery-image">
               </div>
               <?php } ?>
               <?php if(!empty($listing_res['image3'])){?>
               <div class="col-md-3 mb-3">
                  <img src="<?php echo $base_url;?>/admin/uploads/<?php echo $listing_res['image3'];?>" alt="<?php echo $listing_res['ad_title']; ?>" class="mx-auto d-block gallery-image">
               </div>
               <?php } ?>
               <?php if(!empty($listing_res['image4'])){?>
               <div class="col-md-3 mb-3">
                  <img src="<?php echo $base_url;?>/admin/uploads/<?php echo $listing_res['image4'];?>" alt="<?php echo $listing_res['ad_title']; ?>" class="mx-auto d-block gallery-image">
               </div>
               <?php } ?>
            </div>
         </div>
      </section>
      <section class="ad-cards">
         <div class="container">
            <h2 class="text-center mb-4 localities-heading">Other Similar Profiles</h2>
            <div class="row">
               <?php
                  $listing2=$mysqli->query("SELECT * FROM listing left JOIN city ON listing.city_id = city.city_id left JOIN location ON listing.location_id = location.location_id WHERE listing.status='1' && listing.listing_id !='".$listing_res['listing_id']."' && listing.state_id ='".$listing_res['state_id']."' && listing.city_id ='".$listing_res['city_id']."' ORDER BY listing.listing_id DESC LIMIT 5");
                      if($listing2->num_rows > 0){
                      while($listing_res=$listing2->fetch_assoc()){
                  ?>       
               <div class="col-md-12">
                  <div class="ad-card">
                     <div class="d-flex align-items-center">
                        <a rel="alternate" hreflang="x-default" href="<?php echo $base_url;?>/call-girls/<?php echo $listing_res['city_slug'];?>/<?php echo $listing_res['location_slug'];?>/<?php echo substr($listing_res['slug'],0,40);?>-<?php echo $listing_res['listing_id'];?>">
                        <img src="<?php echo $base_url;?>/admin/uploads/<?php echo $listing_res['main_image'];?>" alt="<?php echo $listing_res['name']; ?>"  class="ad-img me-3">
                        </a>
                        <div style="width:100%">
                           <div class="ad-title">
                              <a rel="alternate" hreflang="x-default" href="<?php echo $base_url;?>/call-girls/<?php echo $listing_res['city_slug'];?>/<?php echo $listing_res['location_slug'];?>/<?php echo substr($listing_res['slug'],0,40);?>-<?php echo $listing_res['listing_id'];?>">
                              <?php echo $listing_res['ad_title']; ?>
                              </a>
                           </div>
                           <div class="hide-on-desktop">
                              <span class="badge ad-badge"><i class="fas fa-map-marker-alt"></i> <?php echo $listing_res['city_name']; ?></span>
                              <span class="badge ad-badge"><i class="fas fa-calendar-alt"></i> Age: <?php echo $listing_res['age']; ?></span>
                           </div>
                           <p class="ad-text"><?php echo $listing_res['about']; ?></p>
                           <div class="d-flex justify-content-between mt-3 hide-on-mobile">
                              <div>
                                 <span class="badge ad-badge"><i class="fas fa-map-marker-alt"></i> <?php echo $listing_res['city_name']; ?></span>
                                 <span class="badge ad-badge"><i class="fas fa-calendar-alt"></i> Age: <?php echo $listing_res['age']; ?></span>
                              </div>
                              <div>
                                 <a aria-label="whatsapp" href="https://api.whatsapp.com/send?phone=91<?php echo $listing_res['whatsapp'];?>&amp;text=Hi, I want a service in <?php echo $listing_res['city_name'];?>, found you on Cgnight.net" class="btn btn-whatsapp"><i class="fab fa-whatsapp"></i> WhatsApp</a>
                                 <a aria-label="phone" href="tel:+91<?php echo $listing_res['contact'];?>" class="btn btn-call"><i class="fas fa-phone-alt"></i> Call</a>
                              </div>
                           </div>
                           <div class="hide-on-desktop">
                              <a aria-label="whatsapp" href="https://api.whatsapp.com/send?phone=91<?php echo $listing_res['whatsapp'];?>&amp;text=Hi, I want a service in <?php echo $listing_res['city_name'];?>, found you on Cgnight.net" class="btn btn-whatsapp"><i class="fab fa-whatsapp"></i> WhatsApp</a>
                              <a aria-label="phone" href="tel:+91<?php echo $listing_res['contact'];?>" class="btn btn-call"><i class="fas fa-phone-alt"></i> Call</a>
                           </div>
                        </div>
                     </div>
                  </div>
               </div>
               <?php } }  else {  
                  echo "<p>" . 'Sorry! No Profile Found...You will get soon' . "</p>";
                  }?>
            </div>
         </div>
      </section>
     
      <?php include_once('includes/footer.php'); ?>
      <script src="<?= $base_url; ?>/js/bootstrap.bundle.min.js"></script>
      <script>
         document.addEventListener('DOMContentLoaded', () => {
         const scrollBtn = document.querySelector('.scroll-btn');
         
         // Smooth scroll to the top when the button is clicked
         scrollBtn.addEventListener('click', () => {
             window.scrollTo({
                 top: 0,
                 behavior: 'smooth'
             });
         });
         
         // Show or hide the button based on the scroll position
         window.addEventListener('scroll', () => {
             scrollBtn.style.display = window.scrollY > 20 ? 'block' : 'none';
         });
         });
         
      </script>
   </body>
</html>