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

<head>
    <title>Ostad Group - <?php echo $blogRow['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 $blogRow['title']; ?></h1>
            <ul class="breadcumb-menu">
                <li><a href="index.php">Home</a></li>
                <li><?php echo $blogRow['title']; ?></li>
            </ul>
        </div>
    </div>
</div>

<!--============================== Blog Area ==============================-->
<section class="th-blog-wrapper blog-details space-top space-extra-bottom">
    <div class="container">
        <div class="row">
            <div class="col-xxl-8 col-lg-7">
                <div class="th-blog blog-single">
                    <div class="blog-img">
                        <img src="<?php echo $blogRow['image']; ?>" alt="<?php echo $blogRow['title']; ?>" width="100%">
                    </div>
                    <div class="blog-content">
                        <div class="blog-meta">
                            <a href="blog-details.php?id=<?php echo $id; ?>"><i class="fal fa-clock"></i><?php echo $blogRow['date']; ?></a>
                        </div>
                        <h2 class="blog-title"><?php echo $blogRow['title']; ?></h2>
                        <div>
                            <?php echo $blogRow['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" action="blog.php" method="get">
                            <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">Recent Posts</h3>
                        <div class="recent-post-wrap">
                            <?php
                            $blogSidebar = $connect -> prepare("select * from `tbl_blog` where `delete_flag` = 0 order by rand() limit 4");
                            $blogSidebar -> execute();
                            if($blogSidebar -> rowCount() > 0){
                                while ($blogSidebarRows = $blogSidebar -> fetch(PDO::FETCH_ASSOC)){
                                    ?>
                                    <div class="recent-post">
                                        <div class="media-img">
                                            <a href="blog-details.php?id=<?php echo $blogSidebarRows['id']; ?>">
                                                <img src="<?php echo $blogSidebarRows['image']; ?>" alt="<?php echo $blogSidebarRows['title']; ?>">
                                            </a>
                                        </div>
                                        <div class="media-body">
                                            <h4 class="post-title"><a class="text-inherit" href="blog-details.php?id=<?php echo $blogSidebarRows['id']; ?>"><?php echo $blogSidebarRows['title']; ?></a></h4>
                                            <div class="recent-post-meta">
                                                <a href="blog-details.php?id=<?php echo $blogSidebarRows['id']; ?>"><i class="far fa-calendar"></i><?php echo $blogSidebarRows['date']; ?></a>
                                            </div>
                                        </div>
                                    </div>
                                    <?php
                                }
                            }
                            ?>
                        </div>
                    </div>
                    <div class="widget widget_tag_cloud  ">
                        <h3 class="widget_title">Popular Tags</h3>
                        <div class="tagcloud">
                            <?php
                            $tags = explode("-",$blogRow['tag']);
                            foreach ($tags as $val){
                                echo '<a href="blog-details.php?id='.$id.'">'.$val.'</a>';
                            }
                            ?>
                        </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>