<?php
include "admin/php/functions.php";
$id = intval($_GET['id']);
if(!isset($_GET['id'])){
    header("location:services.php");
    exit();
}
$service = $connect -> prepare("select * from `tbl_service` where `delete_flag` = 0 and `id` = ".$id);
$service -> execute();
if($service -> rowCount() == 0){
    header("location:services.php");
    exit();
}
$serviceRow = $service -> fetch(PDO::FETCH_ASSOC);
?>
<!doctype html>
<html class="no-js" lang="en">

<head>
    <title>Ostad Group - <?php echo $serviceRow['title']; ?></title>
    <meta name="description" content="">
    <?php include "head.php"; ?>
</head>

<body>

<!--============================== Preloader ==============================-->
<?php include "preloader.php"; ?>

<?php include "menu.php"; ?>

<!--============================== Breadcumb ============================== -->
<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 $serviceRow['title']; ?></h1>
            <ul class="breadcumb-menu">
                <li><a href="index.php">Home</a></li>
                <li><a href="services.php">Service</a></li>
                <li><?php echo $serviceRow['title']; ?></li>
            </ul>
        </div>
    </div>
</div>
<!--============================== Service Area ==============================-->
<section class="space-top space-extra-bottom">
    <div class="container">
        <div class="row">
            <div class="col-xxl-8 col-lg-7">
                <div class="page-single mb-30">
                    <div class="page-img">
                        <img src="<?php echo $serviceRow['image']; ?>" alt="<?php echo $serviceRow['title']; ?>">
                    </div>
                    <div class="page-content">
                        <h2 class="h3 sec-title page-title"><?php echo $serviceRow['title']; ?></h2>
                        <div>
                            <?php echo $serviceRow['description']; ?>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-xxl-4 col-lg-5">
                <aside class="sidebar-area">
                    <div class="widget widget_search  ">
                        <form class="search-form" method="get" action="services.php">
                            <input type="text" name="search" placeholder="Enter Keyword">
                            <button type="submit"><i class="far fa-search"></i></button>
                        </form>
                    </div>
                    <div class="widget  ">
                        <h3 class="widget_title">Other services</h3>
                        <div class="recent-post-wrap">
                            <?php
                            $serviceSidebar = $connect -> prepare("select * from `tbl_service` where `delete_flag` = 0 order by rand() limit 4");
                            $serviceSidebar -> execute();
                            if($serviceSidebar -> rowCount() > 0){
                                while ($serviceSidebarRows = $serviceSidebar -> fetch(PDO::FETCH_ASSOC)){
                            ?>
                            <div class="recent-post">
                                <div class="media-img">
                                    <a href="service-details.php?id=<?php echo $serviceSidebarRows['id']; ?>"><img src="<?php echo $serviceSidebarRows['image']; ?>"
                                                                     alt="<?php echo $serviceSidebarRows['title']; ?>"></a>
                                </div>
                                <div class="media-body">
                                    <h4 class="post-title"><a class="text-inherit" href="service-details.php?id=<?php echo $serviceSidebarRows['id']; ?>"><?php echo $serviceSidebarRows['title']; ?></a></h4>
                                </div>
                            </div>
                            <?php
                                }
                            }
                            ?>
                        </div>
                    </div>
                </aside>
            </div>
        </div>
    </div>
</section>

<!--============================== Footer Area ==============================-->
<?php include "footer.php"; ?>

<!-- Scroll To Top -->
<div class="scroll-top">
    <svg class="progress-circle svg-content" width="100%" height="100%" viewBox="-1 -1 102 102">
        <path d="M50,1 a49,49 0 0,1 0,98 a49,49 0 0,1 0,-98"
              style="transition: stroke-dashoffset 10ms linear 0s; stroke-dasharray: 307.919, 307.919; stroke-dashoffset: 307.919;"></path>
    </svg>
</div>


<script src="<?php echo $url; ?>assets/js/vendor/jquery-3.7.1.min.js"></script>
<script src="<?php echo $url; ?>assets/js/swiper-bundle.min.js"></script>
<script src="<?php echo $url; ?>assets/js/bootstrap.min.js"></script>
<script src="<?php echo $url; ?>assets/js/jquery.magnific-popup.min.js"></script>
<script src="<?php echo $url; ?>assets/js/jquery.counterup.min.js"></script>
<script src="<?php echo $url; ?>assets/js/tilt.jquery.min.js"></script>
<script src="<?php echo $url; ?>assets/js/imagesloaded.pkgd.min.js"></script>
<script src="<?php echo $url; ?>assets/js/isotope.pkgd.min.js"></script>
<script src="<?php echo $url; ?>assets/js/main.js"></script>
</body>

</html>