MMCT TEAM
Server IP : 162.214.80.37  /  Your IP : 216.73.216.83
Web Server : Apache
System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64
User : imyrqtmy ( 2189)
PHP Version : 8.2.18
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0750) :  /home2/imyrqtmy/public_html/eventsbyshubhchintak/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home2/imyrqtmy/public_html/eventsbyshubhchintak/venues.php
<?php include'includes/db-conn.inc.php';
 $sqlsubcategory=mysqli_query($conn,"select * from tbl_subcategory where category_id='1' and status='1'")or die(mysqli_error());

$rowsubcategory=mysqli_fetch_assoc( $sqlsubcategory);
$cateid=$rowsubcategory['category_id'];
$subcatename=$rowsubcategory['name'];
$subcateid=$rowsubcategory['id'];
$countvenuecat=mysqli_num_rows($sqlsubcategory);

$sqlistingcount=mysqli_query($conn,"select * from tbl_listing where category_id='$cateid' and subcategory_id='$subcateid' and status='1'")or die(mysqli_error($conn));
//  $countlisitng=mysqli_num_rows($sqlistingcount);

$sqlCity=mysqli_query($conn,"select * from tbl_city") or die(mysqli_error($conn));
while($rowscity=mysqli_fetch_assoc($sqlCity)){
    $cityNameAry[$rowscity['id']]=$rowscity['name'];
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
   <link rel="stylesheet" href="assets/libs/leaflet/dist/leaflet.css">
   <meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- Libs -->
<link rel="stylesheet" href="assets/libs/bootstrap-icons/font/bootstrap-icons.css">
<link rel="stylesheet" href="assets/fonts/wedding-icon-font/flaticon.css">
<link rel="stylesheet" href="assets/fonts/fontello/css/fontello.css">
<!-- Theme CSS -->
<?php include 'includes/head.php'; ?>
<link rel="stylesheet" href="assets/css/theme.min.css">
  <title>Venues | Wedding & Event by Shubhchintak</title>
</head>

<body>
   <!-- navbar -->
<?php include 'includes/navbar.php'; ?>
   <main>
   <section class="pt-6 pb-4">
      <div class="container">
         <div class="row">
            <div class="col-lg-12 col-md-12 col-12">
               <div>
                  <small style="color: #6b7280 !important;"><a href="index.php">Home ></a> Venues</small><br>
                  <h4 class="display-5 fw-semi-bold mb-0" style="font-size: 24px;margin-top: 13px;">Shubhchintak's Venues</h4>
                   <small>Showing <b><?php echo $countvenuecat; ?></b> results as per your search criteria</small>
               </div>
            </div>
         </div>
      </div>
   </section>

     <!-- venues -->
        <section class="pb-10 py-lg-10">
            <div class="container-fluid">
                 <div class="row">
                  <?php  
                       $sql=mysqli_query($conn,"select * from tbl_subcategory where category_id='1' and status='1' order by order_number asc")or die(mysqli_error());
                       while($row=mysqli_fetch_assoc($sql))
                       {extract($row);
                       $sqlistingcount=mysqli_query($conn,"select * from tbl_listing where category_id='1' and subcategory_id='$id' and status='1'")or die(mysqli_error($conn));
                       $countlisitng=mysqli_num_rows($sqlistingcount);
                  ?>           
                        <div class="col-xl-3 col-md-6 col-12">
                            <div class="card border-0 mb-4 mb-xl-0">
                                <div class="position-relative">
                                    <div class="img-hover">
                                        <a href="listing.php?url=<?php echo $url; ?>">
                                            <img src="media/subcategory/<?php echo $image;?>" alt="<?php echo $name;?>"
                                                class="img-fluid w-100">
                                        </a>
                                    </div>
                                    <!--<div class="text-center position-absolute top-50 start-50 translate-middle ">-->
                                    <!--    <div class="border rounded-circle icon-shape icon-xxl">-->
                                    <!--        <i class="flaticon-025-wedding-cake fs-1 text-white"></i>-->
                                    <!--    </div>-->
 
                                    <!--</div>-->
                                    <div class="text-center position-absolute bottom-0 start-50 translate-middle">
                                        <h3>
                                            <a href="listing.php?url=<?php echo $url; ?>" class="text-white"><?php echo $name;?></a>
                                        </h3>
                                    </div>
                                    <div class="position-absolute top-100 start-50 translate-middle">
                                        <span
                                            class="border rounded-circle icon-shape icon-sm text-white bg-success border-2 border-white wps"><?php echo $countlisitng; ?></span>
                                    </div>

                                </div>
                            </div>
                        </div>
                     <?php } ?>  
                    </div>
            </div>
        </section>
        <!-- vanues -->
      <!-- get app -->
        <section class="py-14"
            style="background-image: url(assets/images/banner/cta-img-2.jpg); background-position: center; background-size: cover;">
            <div class="container">
                <div class="row">
                    <div class="col-lg-6">
                        <h2 class="display-6 text-white">Are you Vendor ?</h2>
                        <p class="text-white mb-4">Shubhchintak is a Best Place for you. Grow your Business with Shubhchintak Now ! <br> Sign Up to access your Dashboard</p>
                        <a href="vendor-register.php">
                              <button type="submit" class="btn" style="width: 50%;background: linear-gradient(90deg, #b02a37 0%, #b02a37 39%, #dc3545f2 100%);color: white;">Sign Up Now</button>
                        </a>
                    </div>
                </div>
            </div>
        </section>
        <!-- get app -->
</main>
    <!-- footer -->
<?php include 'includes/footer.php'; ?>
<script src="assets/libs/jquery/dist/jquery.min.js"></script>
<script src="assets/libs/bootstrap/dist/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/flatpickr/dist/flatpickr.min.js"></script>

<!-- Theme JS -->
<script src="assets/js/theme.min.js"></script>

</body>
</html>

MMCT - 2023