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/search-vendor.php
<?php include'includes/db-conn.inc.php';
$subcatid=$_GET['category'];
$city=$_GET['city'];

if($subcatid=="" & $city=="")
{
   echo "<script>window.location = 'vendor.php';</script>";
}
if($subcatid=="" & $city!=="")
{
   echo "<script>window.location = 'vendor.php';</script>";
}

if($subcatid!=="" & $city=="")
{
   $sqlsubcategory=mysqli_query($conn,"select * from tbl_subcategory where id='$subcatid' and status='1'")or die(mysqli_error());
   $rowsubcategory=mysqli_fetch_assoc($sqlsubcategory);
   $suburl=$rowsubcategory['url'];
  ?>
  <script>window.location.href='listing.php?url=<?php echo $suburl; ?>'</script>
  <?php
}

// city name
$sqlcity=mysqli_query($conn,"select * from tbl_city where id='$city' and status='1'")or die(mysqli_error($conn));
$rowcitynew=mysqli_fetch_assoc( $sqlcity);
$cityname=$rowcitynew['name'];

// sub category name
$sqlsubcategory=mysqli_query($conn,"select * from tbl_subcategory where id='$subcatid' and status='1'")or die(mysqli_error());
$rowsubcategory=mysqli_fetch_assoc($sqlsubcategory);
$subcatename=$rowsubcategory['name'];

$sqlistingcount=mysqli_query($conn,"select * from tbl_listing where subcategory_id='$subcatid' and city='$city' and status='1'")or die(mysqli_error($conn));
 $countlisitng=mysqli_num_rows($sqlistingcount);
 // $rowlistingg=mysqli_fetch_assoc($sqlistingcount);
 // $cateidd=$rowlistingg['category_id'];



$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>All <?php echo $subcatename; ?> | 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> >
                     <a href="vendor.php">Vendor</a> > 
                     <a href="listing.php?url=<?php echo  $rowsubcategory['url']; ?>"><?php echo $subcatename; ?> </a> >
                      <?php echo $cityname; ?>
                      </small><br>

                  <h4 class="display-5 fw-semi-bold mb-0" style="font-size: 24px;margin-top: 13px;"><?php echo $subcatename; ?> in <?php echo $cityname; ?> </h4>
                   <small>Showing <b><?php echo $countlisitng; ?></b> results as per your search criteria</small>
               </div>
            </div>
         </div>
      </div>
   </section>
 <section class="pb-6">
      <div class="container">
         <div class="row">
          <?php $sqlisting=mysqli_query($conn,"select * from tbl_listing where subcategory_id='$subcatid' and city='$city' and status='1'")or die(mysqli_error($conn));
                                while($rowlisting=mysqli_fetch_assoc($sqlisting))
                                { extract($rowlisting)?>  
            <!-- col -->
            <div class="col-lg-4 col-md-4 col-12">
               <div class="mb-6">
                  <!-- img -->
                  <div class="position-relative">
                     <a href="listing-detail.php?url=<?php echo $url; ?>"><img src="media/lisitngprofile/<?php echo $rowlisting['image']; ?>" alt="" class="img-fluid rounded-3"></a>
                     <!-- like -->
                     <div class="position-absolute top-0 pe-2 pt-2 end-0">
                        <a href="#" class="text-white text-hover-primary" data-bs-toggle="modal"
                           data-bs-target="#favouriteIcon">
                           <svg xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="currentColor"
                              class="bi bi-heart" viewBox="0 0 16 16">
                              <path
                                 d="m8 2.748-.717-.737C5.6.281 2.514.878 1.4 3.053c-.523 1.023-.641 2.5.314 4.385.92 1.815 2.834 3.989 6.286 6.357 3.452-2.368 5.365-4.542 6.286-6.357.955-1.886.838-3.362.314-4.385C13.486.878 10.4.28 8.717 2.01L8 2.748zM8 15C-7.333 4.868 3.279-3.04 7.824 1.143c.06.055.119.112.176.171a3.12 3.12 0 0 1 .176-.17C12.72-3.042 23.333 4.867 8 15z" />
                           </svg>
                        </a>
                     </div>
                  </div>
                  <!-- content -->
                  <div class="mt-3">
                     <h3 class="mb-0" style="margin-top: -15px;"><a href="#" class="text-inherit" style="font-size: 16px;"><?php echo $rowlisting['name']; ?></a></h3>
                     <p class="mb-1"><img src="assets/images/icon/maps-and-flags.png" style="width: 12px;margin-top: -3px;"> <?php echo $cityNameAry[$city];?></p>
                     <h3 class="mb-0" style="margin-top: -3px;"><a href="#" class="text-inherit" style="font-size: 15px;">₹ <?php echo $rowlisting['startingprice']; ?> <span style="font-size: 13px;color: grey;"><?php echo $rowlisting['pricetitle']; ?></span></a></h3>
                     <div style="float: right;position: relative;margin-top: -51px;">
                        <!-- rating -->
                        <span class="fs-5 lh-1 text-primary">
                           <svg xmlns="http://www.w3.org/2000/svg" width="14" height="14" fill="var(--rw-warning)"
                              class="bi bi-star-fill" viewBox="0 0 16 16">
                              <path
                                 d="M3.612 15.443c-.386.198-.824-.149-.746-.592l.83-4.73L.173 6.765c-.329-.314-.158-.888.283-.95l4.898-.696L7.538.792c.197-.39.73-.39.927 0l2.184 4.327 4.898.696c.441.062.612.636.282.95l-3.522 3.356.83 4.73c.078.443-.36.79-.746.592L8 13.187l-4.389 2.256z" />
                           </svg>
                           <svg xmlns="http://www.w3.org/2000/svg" width="14" height="14" fill="var(--rw-warning)"
                              class="bi bi-star-fill" viewBox="0 0 16 16">
                              <path
                                 d="M3.612 15.443c-.386.198-.824-.149-.746-.592l.83-4.73L.173 6.765c-.329-.314-.158-.888.283-.95l4.898-.696L7.538.792c.197-.39.73-.39.927 0l2.184 4.327 4.898.696c.441.062.612.636.282.95l-3.522 3.356.83 4.73c.078.443-.36.79-.746.592L8 13.187l-4.389 2.256z" />
                           </svg>
                           <svg xmlns="http://www.w3.org/2000/svg" width="14" height="14" fill="var(--rw-warning)"
                              class="bi bi-star-fill" viewBox="0 0 16 16">
                              <path
                                 d="M3.612 15.443c-.386.198-.824-.149-.746-.592l.83-4.73L.173 6.765c-.329-.314-.158-.888.283-.95l4.898-.696L7.538.792c.197-.39.73-.39.927 0l2.184 4.327 4.898.696c.441.062.612.636.282.95l-3.522 3.356.83 4.73c.078.443-.36.79-.746.592L8 13.187l-4.389 2.256z" />
                           </svg>
                           <svg xmlns="http://www.w3.org/2000/svg" width="14" height="14" fill="var(--rw-warning)"
                              class="bi bi-star-fill" viewBox="0 0 16 16">
                              <path
                                 d="M3.612 15.443c-.386.198-.824-.149-.746-.592l.83-4.73L.173 6.765c-.329-.314-.158-.888.283-.95l4.898-.696L7.538.792c.197-.39.73-.39.927 0l2.184 4.327 4.898.696c.441.062.612.636.282.95l-3.522 3.356.83 4.73c.078.443-.36.79-.746.592L8 13.187l-4.389 2.256z" />
                           </svg>
                           <svg xmlns="http://www.w3.org/2000/svg" width="14" height="14" fill="var(--rw-gray-400)"
                              class="bi bi-star-fill" viewBox="0 0 16 16">
                              <path
                                 d="M3.612 15.443c-.386.198-.824-.149-.746-.592l.83-4.73L.173 6.765c-.329-.314-.158-.888.283-.95l4.898-.696L7.538.792c.197-.39.73-.39.927 0l2.184 4.327 4.898.696c.441.062.612.636.282.95l-3.522 3.356.83 4.73c.078.443-.36.79-.746.592L8 13.187l-4.389 2.256z" />
                           </svg>
                        </span>
                        <span class="fs-5 ms-1 lh-1 align-middle"><span class="text-dark fw-semi-bold">4.7</span>
                           (18)</span>
                     </div>
                  </div>
               </div>
            </div>
            <!-- col -->
             <?php }?>
         </div>
      </div>
   </section>



      <!-- 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