ikan Uploader :
Directory : /home/ni05r7l36tus/public_html/sumangalamcaterers.com/
Upload File : |
| Current File : /home/ni05r7l36tus/public_html/sumangalamcaterers.com/blogdetail.php |
<?php
include 'connection/config.php';
// ✅ Validate & Secure the slug
if (!isset($_GET['slug']) || empty($_GET['slug'])) {
header("Location: /blog"); // Redirect if no slug
exit;
}
$slug = htmlspecialchars($_GET['slug'], ENT_QUOTES, 'UTF-8');
// ✅ Fetch blog details
$stmt = $mysqli->prepare("SELECT * FROM `blog` WHERE `slug` = ?");
$stmt->bind_param("s", $slug);
$stmt->execute();
$blog = $stmt->get_result()->fetch_assoc();
if (!$blog) {
header("HTTP/1.0 404 Not Found");
echo "<h1>404 Blog Not Found</h1>";
exit;
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta http-equiv="x-ua-compatible" content="ie=edge" />
<title><?php echo htmlspecialchars($blog['title']); ?> - Sumangalam Caters</title>
<meta name="author" content="Sumangalam Caters" />
<meta name="description" content="<?php echo htmlspecialchars(substr(strip_tags($blog['seodescription']), 0, 160)); ?>" />
<meta name="keywords" content="<?php echo htmlspecialchars($blog['title']); ?>, Catering Services" />
<meta name="robots" content="INDEX,FOLLOW" />
<meta name="viewport" content="width=device-width,initial-scale=1,shrink-to-fit=no" />
<!-- ✅ Open Graph SEO -->
<meta property="og:title" content="<?php echo htmlspecialchars($blog['title']); ?>">
<meta property="og:description" content="<?php echo htmlspecialchars(substr(strip_tags($blog['seodescription']), 0, 160)); ?>">
<meta property="og:image" content="/upload/<?php echo $blog['image']; ?>">
<meta property="og:url" content="https://www.sumangalamcaterers.com/blog/<?php echo $slug; ?>">
<!-- ✅ Favicon -->
<link rel="icon" type="image/png" href="/img/catlogo.png" />
<!-- ✅ Google 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" />
<!-- ✅ Stylesheets -->
<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" type="text/css" href="/whatsapp/whatsapp.css" />
</head>
<body>
<?php include "common/navbarmobile.php"; ?>
<?php include "common/navbardesktop.php"; ?>
<div id="smooth-wrapper">
<div id="smooth-content">
<!-- ✅ Breadcrumb -->
<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 echo htmlspecialchars($blog['title']); ?></h1>
<ul class="breadcumb-menu">
<li><a href="/">Home</a></li>
<li><?php echo htmlspecialchars($blog['title']); ?></li>
</ul>
</div>
</div>
</div>
<!-- ✅ Blog Details -->
<section class="th-blog-wrapper blog-details space-top space-extra-bottom">
<div class="container">
<div class="row">
<!-- ✅ Left Column (Main Blog) -->
<div class="col-xxl-8 col-lg-7">
<div class="th-blog blog-single">
<div class="blog-img">
<img src="/upload/<?php echo $blog['image']; ?>" alt="<?php echo htmlspecialchars($blog['title']); ?>"
onerror="this.src='/img/catlogo.png';" />
</div>
<div class="blog-content">
<div class="blog-meta">
<a class="author" href="#"><i class="fal fa-calendar"></i>
<?php echo date("d M, Y", strtotime($blog['date'])); ?></a>
<a href="#"><i class="fal fa-user"></i>Admin</a>
</div>
<h3 class="sec-title title-ani page-title"><?php echo htmlspecialchars($blog['title']); ?></h3>
<?php echo html_entity_decode($blog['description']); ?>
</div>
</div>
</div>
<!-- ✅ Right Column (Sidebar) -->
<div class="col-xxl-4 col-lg-5">
<aside class="sidebar-area">
<!-- ✅ Services Widget -->
<div class="widget widget_categories">
<h3 class="widget_title">Services</h3>
<ul>
<?php
$service_sql = $mysqli->query("SELECT title, slug FROM `service` LIMIT 8");
while ($service = $service_sql->fetch_assoc()) { ?>
<li><a href="/service/<?php echo $service['slug']; ?>">
<?php echo htmlspecialchars($service['title']); ?>
</a></li>
<?php } ?>
</ul>
</div>
<!-- ✅ Recent Posts Widget -->
<div class="widget">
<h3 class="widget_title">Recent Posts</h3>
<div class="recent-post-wrap">
<?php
$recent_sql = $mysqli->query("SELECT title, slug, image, date FROM `blog` WHERE `slug` != '$slug' ORDER BY id DESC LIMIT 5");
while ($recent = $recent_sql->fetch_assoc()) { ?>
<div class="recent-post">
<div class="media-img">
<a href="/blog/<?php echo $recent['slug']; ?>">
<img src="/upload/<?php echo $recent['image']; ?>"
alt="<?php echo htmlspecialchars($recent['title']); ?>"
onerror="this.src='/img/catlogo.png';" />
</a>
</div>
<div class="media-body">
<h4 class="post-title">
<a class="text-inherit" href="/blog/<?php echo $recent['slug']; ?>">
<?php echo htmlspecialchars($recent['title']); ?>
</a>
</h4>
<div class="recent-post-meta">
<i class="fal fa-calendar-days"></i>
<?php echo date("d M, Y", strtotime($recent['date'])); ?>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
</aside>
</div>
</div>
</div>
</section>
<?php include "common/footer.php"; ?>
</div>
</div>
</body>
</html>
........