ikan Uploader :
Directory : /home/ni05r7l36tus/public_html/sumangalamcaterers.com/
Upload File : |
| Current File : /home/ni05r7l36tus/public_html/sumangalamcaterers.com/venuedetail.php |
<?php
include 'connection/config.php';
// ✅ Fetch venue details using slug
if (isset($_GET['slug']) && !empty($_GET['slug'])) {
$slug = $mysqli->real_escape_string($_GET['slug']);
$venue_query = $mysqli->query("SELECT * FROM `venue` WHERE slug = '$slug' LIMIT 1");
if (!$venue_query || $venue_query->num_rows === 0) {
// ✅ Show 404 page if no venue found
header("HTTP/1.0 404 Not Found");
include "404.php";
exit;
}
$venue_row = mysqli_fetch_assoc($venue_query);
$venue_id = $venue_row['id'];
} else {
// ✅ Redirect to venue listing page if slug is missing
header("Location: /banquet-halls-for-haldi-mehendi-sangeet");
exit;
}
// ✅ Open Graph Image (default fallback)
$og_image = !empty($venue_row['image'])
? "https://www.sumangalamcaterers.com/upload/" . rawurlencode($venue_row['image'])
: "https://www.sumangalamcaterers.com/img/catlogo.png";
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta http-equiv="x-ua-compatible" content="ie=edge" />
<title><?php echo htmlspecialchars($venue_row['title']); ?> - Sumangalam Caters</title>
<meta name="author" content="Sumangalam Caters" />
<meta name="description" content="<?php echo htmlspecialchars($venue_row['seodescription']); ?>" />
<meta name="keywords" content="<?php echo htmlspecialchars($venue_row['keyword']); ?>" />
<meta name="robots" content="INDEX,FOLLOW" />
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
<link rel="icon" type="image/png" href="/img/catlogo.png" />
<!-- ✅ SEO Open Graph -->
<meta property="og:title" content="<?php echo htmlspecialchars($venue_row['title']); ?> - Sumangalam Caters" />
<meta property="og:description" content="<?php echo htmlspecialchars($venue_row['seodescription']); ?>" />
<meta property="og:image" content="<?php echo $og_image; ?>" />
<meta property="og:url" content="https://www.sumangalamcaterers.com/venue/<?php echo htmlspecialchars($slug); ?>" />
<meta property="og:type" content="website" />
<!-- ✅ Fonts -->
<link rel="preconnect" href="https://fonts.googleapis.com/" />
<link rel="preconnect" href="https://fonts.gstatic.com/" crossorigin />
<link href="https://fonts.googleapis.com/css2?family=Great+Vibes&family=Open+Sans:wght@300;400;600;700;800&family=ZCOOL+XiaoWei&display=swap" rel="stylesheet" />
<!-- ✅ Fixed CSS Paths -->
<link rel="stylesheet" href="/assets/css/app.min.css" />
<link rel="stylesheet" href="/assets/css/fontawesome.min.css" />
<link rel="stylesheet" href="/assets/css/style.css" />
<link rel="stylesheet" href="/whatsapp/whatsapp.css" />
<meta name="theme-color" content="#ffffff" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js"></script>
</head>
<body>
<?php include "common/navbarmobile.php"; ?>
<?php include "common/navbardesktop.php"; ?>
<div id="smooth-wrapper">
<div id="smooth-content">
<div class="breadcumb-wrapper" data-bg-src="/assets/img/bg/breadcumb-bg.jpg">
<div class="container">
<div class="breadcumb-content">
<h1 class="breadcumb-title">
<?php
include 'connection/config.php';
if (isset($_GET['slug']) && !empty($_GET['slug'])) {
$slug = $mysqli->real_escape_string($_GET['slug']);
$venue_query = $mysqli->query("SELECT * FROM `venue` WHERE slug = '$slug' LIMIT 1");
if ($venue_query && $venue_query->num_rows > 0) {
$venue_row = $venue_query->fetch_assoc();
echo htmlspecialchars($venue_row['title'], ENT_QUOTES, 'UTF-8');
} else {
echo "Venue Not Found";
}
} else {
echo "Venue Not Found";
}
?>
</h1>
<ul class="breadcumb-menu">
<li><a href="/">Home</a></li>
<li>
<?php
if (!empty($venue_row['title'])) {
echo htmlspecialchars($venue_row['title'], ENT_QUOTES, 'UTF-8');
}
?>
</li>
</ul>
</div>
</div>
</div>
<section class="space-top space-extra-bottom">
<div class="container">
<div class="row">
<!-- ✅ Left Column -->
<div class="col-xxl-8 col-lg-8">
<div class="page-single mb-30">
<?php
// ✅ Fetch venue details again if needed
$venue_query_again = $mysqli->query("SELECT * FROM `venue` WHERE id = '$venue_id' LIMIT 1");
$venue_row_again = mysqli_fetch_assoc($venue_query_again);
?>
<div class="page-img">
<img src="/upload/<?php echo htmlspecialchars($venue_row_again['image']); ?>"
alt="<?php echo htmlspecialchars($venue_row_again['title']); ?>"
onerror="this.src='/img/catlogo.png';" />
</div>
<div class="page-content">
<?php echo !empty($venue_row_again['description'])
? html_entity_decode($venue_row_again['description'])
: '<p>No description available.</p>'; ?>
<h3 class="mb-4">Frequently Asked Questions</h3>
<div class="accordion mt-40" id="faqAccordion">
<?php
$faq_sql = $mysqli->query("SELECT * FROM `venuefaq` WHERE venue_id = '$venue_id'");
$i = 0;
while ($faq_row = mysqli_fetch_assoc($faq_sql)) {
$i++;
$show_class = ($i == 1) ? 'show' : '';
$aria_expanded = ($i == 1) ? 'true' : 'false';
?>
<div class="accordion-card">
<div class="accordion-header" id="collapse-item-<?php echo $i; ?>">
<button class="accordion-button" type="button" data-bs-toggle="collapse" data-bs-target="#collapse-<?php echo $i; ?>" aria-expanded="<?php echo $aria_expanded; ?>" aria-controls="collapse-<?php echo $i; ?>">
<?php echo $i; ?>. <?php echo htmlspecialchars($faq_row['question']); ?>
</button>
</div>
<div id="collapse-<?php echo $i; ?>" class="accordion-collapse collapse <?php echo $show_class; ?>" aria-labelledby="collapse-item-<?php echo $i; ?>" data-bs-parent="#faqAccordion">
<div class="accordion-body">
<p class="faq-text"><?php echo htmlspecialchars($faq_row['answer']); ?></p>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
<!-- ✅ Sidebar -->
<div class="col-xxl-4 col-lg-4">
<aside class="sidebar-area">
<div class="widget widget_categories">
<h3 class="widget_title">Facilities</h3>
<ul>
<?php
$feature_sql = $mysqli->query("SELECT * FROM `venue_feature` WHERE venue_id = '$venue_id'");
while ($feature_row = mysqli_fetch_assoc($feature_sql)) { ?>
<li><a><?php echo htmlspecialchars($feature_row['feature']); ?></a></li>
<?php } ?>
</ul>
</div>
<div class="widget widget_banner" data-bg-src="/assets/img/bg/widget_banner.jpg">
<div class="widget-banner">
<h3 class="box-title"><a href="tel:+918984771790">+91 8984771790</a></h3>
<h3 class="box-title"><a href="tel:+917978006023">+91 7978006023</a></h3>
<p class="box-text">
Monday – Sunday: 7:00AM – 10:00PM<br />
24/7 Emergency Service
</p>
<a href="/contact.php" class="th-btn style3">Contact Now</a>
</div>
</div>
</aside>
</div>
</div>
</div>
</section>
<?php include "common/footer.php"; ?>
</body>
</html>
........