MMCT TEAM
Server IP : 103.53.40.154  /  Your IP : 3.21.12.88
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/rajwadahouse.com/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home2/ppcad7no/rajwadahouse.com/handloom.php
<?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>

MMCT - 2023