|
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'];
$sqlpackage=mysqli_query($conn,"select * from tbl_package where url='$url' and status='1'")or die(mysqli_error($conn));
$rowpackage=mysqli_fetch_assoc($sqlpackage);
extract($rowpackage);
$rowpackageid=$rowpackage['id'];
$occasionidAry = explode(',',$occaison_id);
$sqlimages=mysqli_query($conn,"select * from tbl_package_image where packageid='$rowpackageid'")or die(mysqli_error());
$rowimages=mysqli_fetch_assoc($sqlimages);
$sqlCity=mysqli_query($conn,"select * from tbl_city") or die(mysqli_error($conn));
while($rowscity=mysqli_fetch_assoc($sqlCity)){
$cityNameAry[$rowscity['id']]=$rowscity['name'];
}
$sqlreview2=mysqli_query($conn,"select * from tbl_review where active_status='1' and vendorid='$rowpackageid'")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);
}
?>
<!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">
<link rel="stylesheet" href="assets/libs/magnific-popup/dist/magnific-popup.css">
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11.7.21/dist/sweetalert2.all.min.js"></script>
<link href="https://cdn.jsdelivr.net/npm/sweetalert2@11.7.21/dist/sweetalert2.min.css" rel="stylesheet">
<title><?php echo $rowpackage['name']; ?> | Wedding & Event by Shubhchintak</title>
<style>
.form-label{
font-size: 13px !important;
}
.hpp{
font-size: 12px !important;
text-align: center !important;
font-weight: 500 !important;
font-family: sans-serif !important;
color: black !important;
font-size: 14px !important;
text-align: center !important;
}
</style>
</head>
<body>
<!-- enquiry form -->
<div class="modal fade" id="enquiryButtonModal" tabindex="-1" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Hi <?php echo $rowpackage['name']; ?> ,</h4>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body p-4">
<!-- form -->
<form method="POST" enctype="multipart/form-data" action="">
<input type="hidden" name="txtvendorname" value="<?php echo $rowpackage['name']; ?>">
<input type="hidden" name="txtvendorid" value="<?php echo $rowpackage['id'];?>">
<div class="row">
<div class="col-md-6">
<div class="form-floating mb-3">
<input type="text" class="form-control" name="txtname" placeholder="Full Name *" required>
<label for="name" class="form-label">Full Name</label>
</div>
</div>
<div class="col-md-6">
<div class="form-floating mb-3">
<input type="text" class="form-control" name="txtmobile" placeholder="Mobile Nubmer" required>
<label for="name" class="form-label">Mobile Number</label>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-floating mb-3">
<input type="text" class="form-control" name="txtemail" placeholder="Email ID *" required>
<label for="name" class="form-label">Email ID</label>
</div>
</div>
<div class="col-md-6">
<div class="form-floating mb-3">
<input type="text" class="form-control flatpickr" id="selectdate" placeholder="Select vendor" name="txtdate">
<label for="selectdate" class="form-label">Function Date</label>
</div>
</div>
</div>
<div class="form-floating mb-3">
<input type="text" class="form-control" name="txtdesc" placeholder="Details about My Event" required>
<label for="desc" class="form-label">Details About My Event</label>
</div>
<!-- button -->
<div class="d-grid mb-3">
<button type="submit" class="btn btn-primary" name="sendEnquiry">Send Message</button>
</div>
</form>
<h1 class="h3 mb-3 hpp">Complete information ensures you get accurate and timely vendor responses</h1>
</div>
</div>
</div>
</div>
<!-- enquiry form close -->
<!-- enquiry form -->
<div class="modal fade" id="reviewButtonModal" tabindex="-1" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Please Review for <?php echo $rowpackage['name']; ?></h4>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body p-4">
<!-- form -->
<form method="POST" enctype="multipart/form-data" action="">
<input type="hidden" name="txtvendorname" value="<?php echo $rowpackage['name']; ?>">
<input type="hidden" name="txtvendorid" value="<?php echo $rowpackage['id'];?>">
<div class="row">
<div class="col-md-12">
<div class="form-floating mb-3">
<select class="form-select mt-3" name="radioGroup">
<option value="1">1 Star</option>
<option value="2">2 Star</option>
<option value="3">3 Star</option>
<option value="4">4 Star</option>
<option value="5">5 Star</option>
</select>
<label for="name" class="form-label">Rate Vendor *</label>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-floating mb-3">
<input type="text" class="form-control" name="txtname" placeholder="Full Name *" required>
<label for="name" class="form-label">Full Name *</label>
</div>
</div>
<div class="col-md-6">
<div class="form-floating mb-3">
<input type="text" class="form-control" name="txtmobile" placeholder="Mobile Nubmer" required>
<label for="name" class="form-label">Mobile Number *</label>
</div>
</div>
</div>
<div class="form-floating mb-3">
<textarea class="form-control" placeholder="Tell us about your experience" name="txtcomment" id="usercomments" required></textarea>
<label for="desc" class="form-label">Tell us about your experience *</label>
</div>
<!-- button -->
<div class="d-grid mb-3">
<button type="submit" class="btn btn-success" style="background: linear-gradient(90deg, rgba(2,0,36,1) 0%, rgb(0 68 99) 39%, #00659599 100%);" name="sendReview">Submit</button>
</div>
</form>
</div>
</div>
</div>
</div>
<!-- enquiry form close -->
<!-- navbar -->
<?php include 'includes/navbar.php'; ?>
<main>
<section class="py-6" style="padding-bottom: 0px !important;">
<div class="container">
<div class="row">
<div class="col-md-12 col-12">
<div class="d-md-flex justify-content-between align-items-end">
<!-- content -->
<div class="mb-3">
<small style="color: #6b7280 !important;"><a href="index.php">Home ></a> Package > <?php echo $rowpackage['name']; ?></small><br>
<h1 class="mb-0" style="font-size: 24px;margin-top: 17px;"><?php echo $rowpackage['name']; ?></h1>
<p class="mb-1">Shubhchintak's Package</p>
<div>
<!-- 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>
<!-- button -->
<div>
<a href="login.php" style="border: none;background-color: transparent;" class="me-4 text-muted text-hover-primary">
<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" 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>
<span class="align-middle ms-1" style="color: black;">Save</span></span> </a>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- content -->
<section class="pb-8">
<div class="container">
<div class="row">
<div class="col-lg-8 col-md-7 col-12">
<!-- top image -->
<div class="card mb-4 mb-md-0 ">
<div class="position-relative p-2">
<div class="img-hover">
<a href="#">
<img src="media/package/<?php echo $rowpackage['image']; ?>" alt="vendor1"
class="img-fluid w-100">
</a>
</div>
</div>
<div class="card-body venuetitle">
<h3 class="mb-1">
<a href="#" class="text-inherit"><?php echo $rowpackage['name']; ?></a>
</h3>
<span class="mb-0"><span class="ms-1">
<?php
$sqlcity=mysqli_query($conn,"select * from tbl_city where id='$city_id'")or die(mysqli_error());
$rowcity=mysqli_fetch_assoc($sqlcity);
echo $rowcity['name'];
?>
</span></span>
</div>
<div class="row g-0 border-top align-items-center">
<div class="col-4">
<div class="text-center pr-1">
<h5 class="mb-0">₹ <?php echo $rowpackage['price']; ?></h5>
<p class="mb-0 small">Start From</p>
</div>
</div>
<div class="col-4 border-start">
<div class="text-center pr-1">
<a href="login.php" style="border: none;background-color: transparent;" class="me-4 text-muted text-hover-primary">
<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" 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>
<span class="align-middle ms-1" style="color: black;">Shortlist</span></span> </a>
</div>
</div>
<div class="col-4 border-start">
<div class="text-center pr-1">
<div class="lh-1">
<svg xmlns="http://www.w3.org/2000/svg" width="12" height="12"
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>
</div>
<p class="mb-0 small"><?php echo $reviewcount; ?> Reviews</p>
</div>
</div>
</div>
</div>
<!-- top image close -->
</div>
<!-- sidebar -->
<div class="col-xl-4 col-lg-5 col-12">
<div class=" mt-6 mt-lg-0">
<div class="card mb-4 ">
<div class="card-header starprice">
<h3 class="mb-0" style="color: white;">For Occaisons</h3>
</div>
<div class="row" style="padding-right: 0px !important;">
<?php
foreach ($occasionidAry as $occasionId) {
$occasionId = mysqli_real_escape_string($conn, $occasionId);
$sqloccasion = mysqli_query($conn, "SELECT * FROM tbl_occasion WHERE id='$occasionId' AND status='1'") or die(mysqli_error($conn));
if ($rowoccasion = mysqli_fetch_assoc($sqloccasion)) {
extract($rowoccasion);
?>
<div class="col-12">
<div class="card-body" style="padding-top: 17px; padding-bottom: 0px;">
<h5 class="mb-1"><img src="assets/images/check-mark.png"> <?php echo $rowoccasion['name']; ?></h5>
</div>
</div>
<?php
}
}
?>
</div>
<div class="card-body listprice">
<div class="row">
<div class="col-lg-8 col-md-12">
<h5 class="mb-1 pprice" style="font-size: 15px !important;text-transform: capitalize;color: black"><img src="assets/images/people.png"> <?php echo $rowpackage['guestcapacity']; ?></h5>
</div>
</div>
</div>
<div class="card-body listprice" style="margin-top: 5px;">
<div class="row">
<div class="col-lg-8 col-md-12">
<h5 class="mb-1 pprice" style="font-size: 15px !important;text-transform: capitalize;color: black"><img src="assets/images/serving-dish.png"> ₹ <?php echo $rowpackage['plateprice']; ?></h5>
<p class="mb-0 small">Per Plate</p>
</div>
</div>
</div>
<div class="card-body listprice" style="margin-top: 5px;">
<div class="row">
<div class="col-lg-6 col-md-12">
<h5 class="mb-1 pprice" style="font-size: 20px !important;">₹ <?php echo $rowpackage['price']; ?></h5>
<p class="mb-0 small">Start From</p>
</div>
</div>
</div>
<div class="card-body ">
<div class="row">
<div class="col-lg-12 col-md-12">
<button type="submit" class="btn btn-sm" data-bs-toggle="modal" data-bs-target="#enquiryButtonModal" style="width: 100%;background: #004c6e !important;color: white;">Get Enquiry</button>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- /.sidebar -->
</div>
</div>
</section>
<!-- description -->
<!-- content -->
<section class="pb-8">
<div class="container">
<div class="row">
<div class="col-lg-12 col-md-12 col-12">
<div class="mb-6 border-bottom pb-6">
<h2 class="mb-3">About <?php echo $rowpackage['name']; ?></h2>
<p><?php echo $rowpackage['description']; ?> </p>
</div>
<!-- aminities -->
<div class="mb-6 border-bottom pb-6">
<h2 class="mb-3">Inclusion</h2>
<div class="row">
<div class="col-md-6 col-6">
<ul class="list-unstyled">
<?php
$packageidd=$rowpackage['id'];
$counter = 0; // Initialize a counter
$sqlinclusion = mysqli_query($conn, "SELECT * FROM tbl_inclusion WHERE packageid='$packageidd' AND status='1'") or die(mysqli_error($conn));
while ($rowinclusion = mysqli_fetch_assoc($sqlinclusion)) {
extract($rowinclusion);
// Check if the counter is a multiple of 5 (i.e., every 5 records)
if ($counter % 5 == 0) {
// Close the current div and open a new one
if ($counter > 0) {
echo '</ul></div><div class="col-md-6 col-6"><ul class="list-unstyled">';
}
}
?>
<li><img src="assets/images/checked.png" > <?php echo $name; ?></li>
<?php
$counter++; // Increment the counter
}
// Close the last div if it's open
if ($counter > 0) {
echo '</ul></div>';
}
?>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- description -->
<!-- gallery -->
<div class="pb-6">
<div class="container">
<div class="gallery row g-2">
<div class="col-md-12">
<div class="row g-2">
<?php $sqlpackagesimages=mysqli_query($conn,"select * from tbl_package_image where packageid='$id'")or die(mysqli_error($conn));
while($rowpackagesimages=mysqli_fetch_assoc($sqlpackagesimages))
{ extract($rowpackagesimages)?>
<div class="col-md-3">
<div class="galleryImg">
<a href="media/packageimage/<?php echo $rowpackagesimages['image'];?>">
<img src="media/packageimage/<?php echo $rowpackagesimages['image'];?>" class="w-100 rounded-3">
</a>
</div>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
<!-- image close -->
<!-- reviews -->
<section class="pb-8">
<div class="container">
<div class="row">
<div class="col-lg-12 col-md-12 col-12">
<div class="mb-6 border-bottom pb-6">
<h2 class="mb-3">Reviews</h2>
<div class="row">
<div class="col-md-12 col-12">
<div class="">
<div class="mb-3">
<span class="align-middle ms-1"><span
class="text-muted">(<?php echo $reviewcount; ?>
Reviews)</span></span>
<button type="submit" class="btn btn-sm" data-bs-toggle="modal" data-bs-target="#reviewButtonModal" style="float: right;background: white !important;color: #004c6e;border: 1px solid #004c6e;">Add Review</button>
</div>
</div>
</div>
</div>
<?php
if($reviewcount<0)
{
echo "No Reviews Found.";
}
?>
<?php
$sqlreview=mysqli_query($conn,"select * from tbl_review where active_status='1' and vendorid='$rowpackageid' ORDER BY id desc")or die(mysqli_error());
while($rowreview=mysqli_fetch_assoc($sqlreview))
{extract($rowreview)
?>
<!-- review 1 -->
<div class="mt-6">
<!-- comment one -->
<div class="d-md-flex align-items-center">
<img src="assets/images/user.gif" alt="" class="avatar-md rounded-circle mb-3 mb-md-0">
<div class="d-flex align-items-start">
<div class="ms-md-3 ">
<h4 class="mb-0"><?php echo $rowreview['name']; ?></h4>
<p class="fs-5 mb-0"><?php echo $rowreview['datee']; ?></p>
</div>
<div class="ms-3 d-flex align-items-start">
<div class="text-primary fs-5 me-1 ">
<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 class="align-middle fw-semi-bold"><?php echo $rowreview['rating']; ?></span>
</div>
<!-- dropdown -->
</div>
</div>
</div>
<p><?php echo $rowreview['usercomment']; ?></p>
</div>
<!-- comments -->
<div class="bg-light p-4 rounded-3">
<h5 class="fw-semi-bold">Shubhchintak’s Reply </h5>
<p class="mb-0"><?php echo $rowreview['reply']; ?></p>
</div>
<!-- review 1 -->
<?php }?>
</div>
</div>
</div>
</div>
</section>
<!-- reviews close -->
<!-- similar -->
<section class="pb-8 bg-light" style="padding-top: 83px;">
<div class="container">
<div class="row mb-6">
<!-- caption -->
<div class="col-md-12 col-12">
<h2 class="mb-0 fs-1">Explore Other Packages</h2>
</div>
</div>
<div class="row">
<?php $sqlpackages=mysqli_query($conn,"select * from tbl_package where status='1' order by order_number asc")or die(mysqli_error($conn));
while($rowpackages=mysqli_fetch_assoc($sqlpackages))
{ extract($rowpackages);
$sqlreview2=mysqli_query($conn,"select * from tbl_review where active_status='1' and vendorid='$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="package-detail.php?url=<?php echo $url; ?>"><img src="media/package/<?php echo $rowpackages['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 $rowpackages['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_id];?></p>
<h3 class="mb-0" style="margin-top: -3px;"><a href="#" class="text-inherit" style="font-size: 15px;">₹ <?php echo $rowpackages['price']; ?></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>
</main>
<!-- footer -->
<!-- footer -->
<?php include 'includes/footer.php'; ?>
<!-- Libs JS -->
<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>
<script src="assets/libs/magnific-popup/dist/jquery.magnific-popup.min.js"></script>
<script src="assets/js/vendors/popup.js"></script>
<script src="assets/libs/leaflet/dist/leaflet.js"></script>
<script src="assets/js/vendors/map.js"></script>
<script src="js/custom.js"></script>
</body>
</html>
<?php
if(isset($_POST['sendEnquiry']))
{
$vendorname=mysqli_real_escape_string($conn,$_POST['txtvendorname']);
$vendorid=mysqli_real_escape_string($conn,$_POST['txtvendorid']);
$vendorsubcateid=mysqli_real_escape_string($conn,$_POST['txtvendorsubcatid']);
$name=mysqli_real_escape_string($conn,$_POST['txtname']);
$mobile=mysqli_real_escape_string($conn,$_POST['txtmobile']);
$email=mysqli_real_escape_string($conn,$_POST['txtemail']);
$functiondate=mysqli_real_escape_string($conn,$_POST['txtdate']);
$descc=mysqli_real_escape_string($conn,$_POST['txtdesc']);
date_default_timezone_set("Asia/Kolkata");
$enquirydate=date("d-m-Y / h:i:s a");
$sql="insert into tbl_listing_enquiry(vendorid,vendorname,enquirydate,functiondate,status,name,mobile,email,descc,vendorsubcateid) values('$vendorid','$vendorname','$enquirydate','$functiondate','1','$name','$mobile','$email','$descc','$vendorsubcateid')";
if(mysqli_query($conn,$sql) or die (mysqli_error($conn)))
{ ?>
<script>
Swal.fire(
'Thank You !',
'We Will Contact You Soon.',
'success'
)
</script>
<?php }
else
{
echo "<script> alert('error');</script>";
}
}
?>
<?php
if(isset($_POST['sendReview']))
{
$vendorname=mysqli_real_escape_string($conn,$_POST['txtvendorname']);
$vendorid=mysqli_real_escape_string($conn,$_POST['txtvendorid']);
$name=mysqli_real_escape_string($conn,$_POST['txtname']);
$mobile=mysqli_real_escape_string($conn,$_POST['txtmobile']);
$descc=mysqli_real_escape_string($conn,$_POST['txtcomment']);
$rating=mysqli_real_escape_string($conn,$_POST['radioGroup']);
date_default_timezone_set("Asia/Kolkata");
$enquirydate=date("d-m-Y / h:i:s a");
$sql="insert into tbl_review(name,rating,usercomment,datee,active_status,vendorname,vendorid,status,mobile) values('$name','$rating','$descc','$enquirydate','0','$vendorname','$vendorid','1','$mobile')";
if(mysqli_query($conn,$sql) or die (mysqli_error($conn)))
{ ?>
<script>
Swal.fire(
'Thank You !',
'Thank you for your valuable feedback.',
'success'
)
</script>
<?php }
else
{
echo "<script> alert('error');</script>";
}
}
?>