<?php
include_once "admin/php/functions.php";

$id = intval($_GET['id']);
$sqlBlogDetail = $connect->query("select * from `tbl_taturial_blog` where `delete_flag`=0 and `id`=" . $id);
$blogDetail = $sqlBlogDetail->fetch(PDO::FETCH_ASSOC);
?>
<!doctype html>
<html class="no-js" lang="en">
<head>
    <title><?php echo $blogDetail['title']; ?></title>
    <?php include "head.php"; ?>
</head>
<body>

<!-- Wrapper -->
<div class="wrap push">

    <?php
    include_once "page-header.php";
    ?>

    <!-- Page Heading & Breadcrumbs  -->
    <div class="page-heading-breadcrumbs">
        <div class="container">
            <h2><?php echo $blogDetail['title']; ?></h2>
            <ul class="breadcrumbs">
                <li><a href="index.php">خانه</a></li>
                <li><?php echo $blogDetail['title']; ?></li>
            </ul>
        </div>
    </div>
    <!-- Page Heading & Breadcrumbs  -->

    <!-- Main Content -->
    <main class="main-content">

        <!-- Blog Detail -->
        <div class="theme-padding white-bg">
            <div class="container">
                <div class="row">

                    <!-- Blog Content -->
                    <div class="col-lg-9 col-md-9 col-sm-7 col-xs-12">

                        <!-- Blog detail -->
                        <div class="blog-detail-holder">
                            <div class="author-header">
                                <h2><?php echo $blogDetail['title']; ?></h2>
                            </div>
                            <article>
                                <p><?php echo $blogDetail['short_desc']; ?></p>
                            </article>
                            <div class="blog-detail">
                                <figure>
                                    <img src="<?php echo $blogDetail['image']; ?>"
                                         alt="<?php echo $blogDetail['title']; ?>" width="100%">
                                </figure>
                                <article class="blog-content">
                                    <?php echo $blogDetail['description']; ?>
                                </article>
                            </div>
                        </div>
                        <!-- Blog Detail -->
                    </div>
                    <!-- Blog Content -->

                    <!-- Aside -->
                    <div class="col-lg-3 col-md-3 col-sm-5 col-xs-12">

                        <!-- Aside Widget -->
                        <div class="aside-widget">
                            <h3><span>توضیحات دیگر</span></h3>
                            <div class="top-categories">
                                <ul>
                                    <?php
                                    $sqlGroup2 = $connect->query("select * from `tbl_taturial_blog` where `delete_flag`=0 and `id` <> ".$id." order by `id` desc");
                                    while ($group2 = $sqlGroup2->fetch(PDO::FETCH_ASSOC)) {
                                        ?>
                                        <li><a href="taturial-detail.php?id=<?php echo $group2['id']; ?>"><?php echo $group2['title']; ?></a></li>
                                        <?php
                                    }
                                    ?>
                                </ul>
                            </div>
                        </div>
                        <!-- Aside Widget -->

                    </div>
                    <!-- Aside -->
                </div>
            </div>
        </div>
        <!-- Blog Detail -->

    </main>
    <!-- Main Content -->

    <?php
    include_once "footer.php";
    ?>

    <!-- Java Script -->
    <script src="js/vendor/jquery.js"></script>
    <script src="js/vendor/bootstrap.min.js"></script>
    <script src="http://maps.google.com/maps/api/js?sensor=false"></script>
    <script src="js/gmap3.min.js"></script>
    <script src="js/bigslide.js"></script>
    <script src="js/slick.js"></script>
    <script src="js/waterwheelCarousel.js"></script>
    <script src="js/contact-form.js"></script>
    <script src="js/countTo.js"></script>
    <script src="js/datepicker.js"></script>
    <script src="js/rating-star.js"></script>
    <script src="js/range-slider.js"></script>
    <script src="js/spinner.js"></script>
    <script src="js/parallax.js"></script>
    <script src="js/countdown.js"></script>
    <script src="js/appear.js"></script>
    <script src="js/prettyPhoto.js"></script>
    <script src="js/wow-min.js"></script>
    <script src="js/main.js"></script>
</body>
</html>