|
Server IP : 103.53.40.154 / Your IP : 18.118.193.223 Web Server : Apache System : Linux md-in-35.webhostbox.net 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : ppcad7no ( 715) PHP Version : 8.2.25 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home2/ppcad7no/thewebshop.co.in/../aircraftelevators.in/../rajwadahouse.com/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
include_once('admin/config.php');
$slug_name = $_REQUEST['slug'] ?? null;
if (isset($_SERVER['PATH_INFO'])) {
$slug_name = $_SERVER['PATH_INFO'];
$querydt = "SELECT * FROM `tbl_main_cat` WHERE `slug`='$slug_name'";
$rundt = mysqli_query($db, $querydt) or die("Query Not run");
$datadt = mysqli_fetch_assoc($rundt);
}
?>
<!doctype html>
<html class="no-js" lang="zxx">
<head>
<meta charset="utf-8">
<meta http-equiv="x-ua-compatible" content="ie=edge">
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1">
<?php include "top-links.php"; ?>
<title><?php
if (isset($datadt["meta_title"]) && !empty($datadt["meta_title"])) {
echo $datadt["meta_title"];
} else {
echo $datadt["cat_name"];
}
?> </title>
<meta name="description" content="<?php echo $datadt["meta_desc"]; ?>">
<style>
.content-hand {
padding:10px;
background:#cccccc57;
border-radius:10px;
box-shadow: 0 3px 6px rgba(0,0,0,0.16), 0 3px 6px rgba(0,0,0,0.23);
margin-bottom:20px;
}
.content-hand .thumb-image img{
border-radius:10px;
}
</style>
</head>
<body>
<div id="main-wrapper">
<?php include "header.php"; ?>
<!-- Page Banner Section Start -->
<div class="page-banner-section section bg-image" data-bg="<?php echo $wspath ?>assets/images/bg/breadcrumb.jpg">
<div class="container">
<div class="row">
<div class="col">
<div class="page-banner text-center">
<h1><?php echo $datadt["cat_name"]?></h1>
<ul class="page-breadcrumb">
<li><a href="<?php echo $wspath?>">Home</a></li>
<li><?php echo $datadt["cat_name"]?></li>
</ul>
</div>
</div>
</div>
</div>
</div>
<!-- Page Banner Section End -->
<div class="container pt-50 pb-50">
<div class="row">
<?php
$maincat = $datadt['c_id'];
$sqlsubcat = "SELECT * FROM `tbl_tourspots` WHERE main_cat_id='$maincat' AND `spots_status`='Active' ORDER BY subcat_order_by ASC";
$runsubcat = mysqli_query($db, $sqlsubcat) or die("Query Not run");
$product_counts = array();
while ($datasubcat = mysqli_fetch_assoc($runsubcat)) {
$spot_id = $datasubcat['spots_id'];
$sqlProductCount = "SELECT COUNT(*) as count FROM `tbl_services` WHERE m_id='$spot_id'";
$runProductCount = mysqli_query($db, $sqlProductCount) or die("Count Query Not run");
$productCount = mysqli_fetch_assoc($runProductCount);
$product_counts[$spot_id] = $productCount['count'];
}
mysqli_data_seek($runsubcat, 0);
while ($datasubcat = mysqli_fetch_assoc($runsubcat)) {
$spot_id = $datasubcat['spots_id'];
?>
<div class="col-lg-3">
<div class="content-hand">
<div class="thumb-image">
<a href="<?php echo $wspath ?>category<?php echo $datasubcat['spots_url'];?>.html">
<img src="<?php echo $wspath?>admin/images/places/<?php echo $datasubcat['spots_image']?>" alt="<?php echo $site_name?>" title="<?php echo $site_name?>" width="100%">
</a>
</div>
<div class="cat-details pt-20">
<a href="<?php echo $wspath ?>category<?php echo $datasubcat['spots_url'];?>.html">
<h4>
<?php echo $datasubcat['spots_name'];?>
</h4>
</a>
<br>
<span>
<a href="<?php echo $wspath ?>category<?php echo $datasubcat['spots_url'];?>.html">
<?php echo $product_counts[$spot_id]; ?> products
</a>
</span>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
<?php include "footer.php"; ?>
</div>
</body>
</html>