<!DOCTYPE html>
<html lang="en">
<head>
    <?php include_once("assets/include/head.php");
        $id=$_GET['slug'];
        $query=mysqli_query($con,"SELECT * from blogs where slug='$id'");
        $row=mysqli_fetch_array($query);
        $date  = $row['created_at']; 
        $time  = strtotime($date);
        $day   = date('d M Y', $time);
                                
    ?>
</head>
<body>
    <div id="main">
        <?php include_once("assets/include/header.php")?>
        <!-- sub-banner started... -->
        <section class="breadcrumb-area">
           <?php   
    	                $ru=mysqli_query($con,"SELECT * FROM banners where page_name='News details'");
            		    $r=mysqli_fetch_array($ru);
            		   ?>
                <source media="(max-width:767px)" srcset="<?php path(); ?>/assets/images/banner-image/<?php echo $r['mbanner']; ?>">
                <source media="(min-width:768px)" srcset="<?php path(); ?>/assets/images/banner-image/<?php echo $r['banners']; ?>">
                <img src="#" alt="banner-img">
            </picture>
            <div class="container">
                <div class="row">
                    <div class="col-md-12">
                        <div class="breadcrumb-content">
                            <ul class="breadcrumb-links">
                                <li><a href="<?php  path(); ?>">Home</a></li>
                                <li><a href="<?php  path(); ?>/blog-list">Blog List</a></li>
                                <li>Blog Single</li>
                            </ul>
                        </div>
                    </div>
                </div>
            </div>
        </section>
        <!-- sub-banner ended... -->
        <!-- single blog area start -->
        <div class="shop-category-area single-blog">
            <div class="container">
                <div class="row">
                    <div class="col-lg-9 order-lg-last col-md-12 order-md-first">
                        <div class="blog-posts">
                            <div class="single-blog-post blog-grid-post">
                                <div class="blog-post-media">
                                    <div class="blog-image single-blog">
                                        <a href="<?php  path(); ?>/"><img src="<?php  path(); ?>/assets/images/blog-image/<?php echo $row['banner'];?>" /></a>
                                    </div>
                                </div>
                                <div class="blog-post-content-inner">
                                    <h4 class="blog-title"><a href="#"><?php echo $row['name']; ?></a></h4>
                                    <ul class="blog-page-meta">
                                        <li>
                                            <a href="#"><i class="ion-person"></i> Admin</a>
                                        </li>
                                        <li>
                                            <a href="#"><i class="ion-calendar"></i> <?php echo $day; ?></a>
                                        </li>
                                    </ul>
                                   
                                </div>
                                <div class="single-post-content"><?php echo $row['description']; ?></div>
                            </div>
                            <!-- single blog post -->
                        </div>
                        
                    </div>
                    <!-- Sidebar Area Start -->
                    <div class="col-lg-3 order-lg-first col-md-12 order-md-last mb-res-md-60px mb-res-sm-60px">
                        <div class="left-sidebar">
                            <!-- Sidebar single item -->
                            
                            <!-- Sidebar single item -->
                            <div class="sidebar-widget mt-40">
                                <div class="main-heading">
                                    <h2>Recent Post</h2>
                                </div>
                                <?php 
                                    $query1=mysqli_query($con,"SELECT * from blogs order by id desc limit 10");
                                    while($row1=mysqli_fetch_array($query1)){
                                    $date  = $row1['created_at']; 
	                                $time  = strtotime($date);
	                                $day   = date('d M Y', $time);
                                ?>
                                <div class="recent-post-widget">
                                    <div class="recent-single-post d-flex">
                                        <div class="thumb-side">
                                            <a href="<?php  path(); ?>/blog/<?php echo $row1['slug'];?>"><img src="<?php path();?>/assets/images/blog-image/<?php echo $row1['banner'];?>" alt="<?php echo $row1['banner'];?>" /></a>
                                        </div>
                                        <div class="media-side">
                                            <h5><a href="<?php  path(); ?>/blog/<?php echo $row1['slug'];?>"><?php echo $row1['name'];?></a></h5>
                                            <span class="date"><?php echo $day;?></span>
                                        </div>
                                    </div>
                                </div>
                               <?php } ?>
                            </div>
                           
                        </div>
                    </div>
                    <!-- Sidebar Area End -->
                </div>
            </div>
        </div>
        <!-- single blog area end -->
        <?php include_once("assets/include/footer.php")?>
    </div>
</body>
</html>