| Server IP : 66.29.137.217 / Your IP : 3.139.64.42 Web Server : LiteSpeed System : Linux premium294.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : gltevjme ( 1095) PHP Version : 7.0.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/gltevjme/greatlifehub.ng/fir/ |
Upload File : |
<?php require_once('header.php'); ?>
<?php
// Preventing the direct access of this page.
if(!isset($_REQUEST['slug']))
{
header('location: '.BASE_URL);
exit;
}
else
{
// Check the page slug is valid or not.
$statement = $pdo->prepare("SELECT * FROM tbl_service WHERE slug=?");
$statement->execute(array($_REQUEST['slug']));
$total = $statement->rowCount();
if( $total == 0 )
{
header('location: '.BASE_URL);
exit;
}
}
// Getting the detailed data of a service from slug
$statement = $pdo->prepare("SELECT * FROM tbl_service WHERE slug=?");
$statement->execute(array($_REQUEST['slug']));
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
foreach ($result as $row)
{
$name = $row['name'];
$slug = $row['slug'];
$short_description = $row['short_description'];
$description = $row['description'];
$photo = $row['photo'];
$banner = $row['banner'];
}
?>
<div class="search-overlay">
<div class="d-table">
<div class="d-table-cell">
<div class="search-overlay-layer"></div>
<div class="search-overlay-layer"></div>
<div class="search-overlay-layer"></div>
<div class="search-overlay-close">
<span class="search-overlay-close-line"></span>
<span class="search-overlay-close-line"></span>
</div>
<div class="search-overlay-form">
<form>
<input type="text" class="input-search" placeholder="Search here...">
<button type="submit"><i class='las la-search'></i></button>
</form>
</div>
</div>
</div>
</div>
<div class="page-banner bg-1">
<div class="d-table">
<div class="d-table-cell">
<div class="container">
<div class="page-content">
<h2>Services Details</h2>
<ul>
<li><a href="<?php echo BASE_URL; ?>">Home <i class="las la-angle-right"></i></a></li>
<li>Services Details</li>
</ul>
</div>
</div>
</div>
</div>
</div>
<div class="services-details-area ptb-100">
<div class="container">
<div class="row">
<div class="col-lg-8 col-md-7 col-sm-12">
<div class="services-details">
<div class="img">
<img src="<?php echo BASE_URL; ?>assets/uploads/<?php echo $banner; ?>" alt="Image">
</div>
<div class="services-details-content">
<h3> <?php echo $name; ?></h3>
<p><b><i>"<?php echo $short_description; ?>"</i></b></p>
<p><?php echo $description; ?></p>
<div class="faq-area">
<div class="faq-accordion">
</div>
</div>
</div>
</div>
</div>
<div class="col-lg-4 col-md-5 col-sm-12">
<div class="side-bar">
<div class="side-bar-box search-box">
<form>
<input type="text" class="form-control" name="search" id="search-input" placeholder="Search">
<button type="submit"><i class="las la-search"></i></button>
</form>
</div>
<div class="side-bar-box categories-box">
<h3 class="title">Services</h3>
<ul>
<?php
$statement = $pdo->prepare("SELECT * FROM tbl_service ORDER BY name ASC");
$statement->execute();
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
foreach ($result as $row) {
?>
<li><a href="<?php echo BASE_URL.URL_SERVICE.$row['slug']; ?>"><i class="las la-angle-double-right"></i></i><?php echo $row['name']; ?></a></li>
<?php
}
?>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
<?php require_once('footer.php'); ?>