ikan Uploader :
Directory : /home/ni05r7l36tus/www/sabksolutions.com/
Upload File : |
| Current File : /home/ni05r7l36tus/www/sabksolutions.com/servicedetails.php |
<?php
include "common/header1.php";
include "connection/config.php"; // PDO DB connection
// Get ID from URL and validate it
$id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
try {
// Fetch service details
$stmt = $pdo->prepare("SELECT * FROM service WHERE id = ?");
$stmt->execute([$id]);
$service = $stmt->fetch(PDO::FETCH_ASSOC);
// Fallback if not found
if (!$service) {
echo "<h2 style='text-align:center; margin-top: 100px;'>Service not found.</h2>";
include "common/footer.php";
exit();
}
// Fetch all services for sidebar
$sidebar_stmt = $pdo->query("SELECT id, title FROM service");
$all_services = $sidebar_stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
echo "<p class='text-danger'>Database error: " . $e->getMessage() . "</p>";
include "common/footer.php";
exit();
}
?>
<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">Service 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">Service Details</li>
</ol>
</nav>
</div>
</div>
</div>
</div>
</section>
<!-- services-details -->
<section class="services__details-area">
<div class="container" style="margin-bottom:-100px">
<div class="services__details-wrap">
<div class="row">
<!-- Main Content -->
<div class="col-70 order-0 order-lg-2">
<div class="services__details-content services__details-content-two">
<div class="services__details-thumb">
<img height="420" width="850" src="admin/upload/<?php echo htmlspecialchars($service['image']); ?>" alt="<?php echo htmlspecialchars($service['title']); ?>" />
</div>
<h2 class="title"><?php echo htmlspecialchars($service['page_title']); ?></h2>
<p><?php echo $service['description']; ?></p>
</div>
</div>
<!-- Sidebar -->
<div class="col-30">
<aside class="services__sidebar">
<div class="sidebar__widget">
<div class="sidebar__cat-list-two sidebar__cat-list-three">
<ul class="list-wrap">
<style>
.list-wrap li.active {
background-color: #14176c;
border-radius: 5px;
}
.list-wrap li.active a,
.list-wrap li.active i {
color: #ffffff !important;
background-color: #14176c;
}
</style>
<?php
foreach ($all_services as $row) {
$active = ($row['id'] == $id) ? 'active' : '';
?>
<li class="<?= $active; ?>">
<a href="servicedetails.php?id=<?= $row['id']; ?>">
<?= htmlspecialchars($row['title']); ?>
<i class="flaticon-arrow-button"></i>
</a>
</li>
<?php } ?>
</ul>
</div>
</div>
<div class="sidebar__widget sidebar__widget-two">
<div class="sidebar__contact sidebar__contact-two" data-background="assets/img/services/sidebar_contact_bg.jpg">
<h2 class="title">If You Need Any Help Contact With Us</h2>
<a href="tel:+919810820369" class="btn"><i class="flaticon-phone-call"></i>+91 9810820369</a>
</div>
</div>
</aside>
</div>
</div>
</div>
</div>
</section>
</main>
<?php include "common/footer.php"; ?>
........