ikan Uploader :
Directory : /home/ni05r7l36tus/www/sabksolutions.com/
Upload File : |
| Current File : /home/ni05r7l36tus/www/sabksolutions.com/blogdetails.php |
<?php
include "common/header1.php";
include "connection/config.php"; // DB connection
$id = isset($_GET['id']) ? intval($_GET['id']) : 0;
// Fetch blog details
$stmt = $pdo->prepare("SELECT * FROM blog WHERE id = :id");
$stmt->execute([':id' => $id]);
$service = $stmt->fetch(PDO::FETCH_ASSOC);
// Fallback if blog not found
if (!$service) {
echo "<h2 style='text-align:center; margin-top: 100px;'>Blog not found.</h2>";
include "common/footer.php";
exit();
}
// Fetch category name
$categoryName = '';
if (!empty($service['cat_id'])) {
$cat_stmt = $pdo->prepare("SELECT blog_category FROM blog_category WHERE id = :cat_id");
$cat_stmt->execute([':cat_id' => $service['cat_id']]);
$cat = $cat_stmt->fetch(PDO::FETCH_ASSOC);
if ($cat) {
$categoryName = $cat['blog_category'];
}
}
// Fetch all blogs for sidebar if needed (optional, not shown in this HTML)
?>
<!-- main-area -->
<main class="fix">
<!-- breadcrumb-area -->
<section class="breadcrumb__area breadcrumb__bg">
<div class="bg-img position-absolute top-0 bottom-0 start-0 w-100 h-100" data-background="assets/img/bg/breadcrumb.jpg"></div>
<div class="container">
<div class="row">
<div class="col-lg-6">
<div class="breadcrumb__content">
<h2 class="title">Blog Details</h2>
<nav aria-label="breadcrumb">
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="index.php">Home</a></li>
<li class="breadcrumb-item active" aria-current="page">Blog Details</li>
</ol>
</nav>
</div>
</div>
</div>
</div>
<div class="breadcrumb__shape">
<img src="assets/img/images/breadcrumb_shape01.png" alt="Apexa" class="dark-opacity" />
<img src="assets/img/images/breadcrumb_shape02.png" alt="Apexa" class="rightToLeft dark-opacity" />
<img src="assets/img/images/breadcrumb_shape03.png" alt="Apexa" class="dark-opacity" />
<img src="assets/img/images/breadcrumb_shape04.png" alt="Apexa" class="dark-opacity" />
<img src="assets/img/images/breadcrumb_shape05.png" alt="Apexa" class="alltuchtopdown dark-opacity" />
</div>
</section>
<!-- breadcrumb-area-end -->
<!-- blog-details-area -->
<section class="blog__details-area d">
<div class="container">
<div class="blog__inner-wrap">
<div class="row d-flex justify-content-center align-items-center">
<div class="col-70">
<div class="blog__details-wrap">
<div class="blog__details-thumb">
<img height="420" width="850" src="admin/upload/<?php echo htmlspecialchars($service['image']); ?>" alt="<?php echo htmlspecialchars($service['title']); ?>" />
</div>
<div class="blog__details-content">
<h2 class="title"><?php echo htmlspecialchars($service['pagetitle']); ?></h2>
<div class="blog-post-meta">
<ul class="list-wrap">
<li><a href="#" class="blog__post-tag-two"><?php echo htmlspecialchars($service['type1']); ?></a></li>
<li><a href="#" class="blog__post-tag-two"><?php echo htmlspecialchars($service['type2']); ?></a></li>
<li>
<div class="blog-avatar">
<div class="avatar-content">
<p>By <a href="#"><?php echo htmlspecialchars($service['author']); ?></a></p>
</div>
</div>
</li>
<li><i class="fas fa-calendar-alt"></i><?php echo htmlspecialchars($service['date']); ?></li>
</ul>
</div>
<p><?php echo htmlspecialchars($service['description']); ?></p>
<div class="blog-post-meta d-flex justify-content-center align-items-center mt-5">
<ul class="list-wrap">
<li>
<a href="view_doc.php?file=<?php echo urlencode($service['file']); ?>" class="btn btn-two" target="_blank">View</a>
</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- blog-details-area-end -->
</main>
<!-- main-area-end -->
<?php include "common/footer.php"; ?>
........