<?php include_once'include/head.php'; ?>
<?php include_once'connection.php'; ?>
<?php 
$slug = $_GET['slug'];

$blog = mysqli_query($con, "SELECT * FROM `blogs` where slug='$slug'");
$num=mysqli_num_rows($blog);
while($row = mysqli_fetch_array($blog))
{
    $name = $row['name'];
    $banner = $row['banner'];
    $short = $row['short_description'];
    $slug = $row['slug'];
    $desc = $row['description'];
}
if($num == 0)
{
    ?>
   <script>window.location.href = "https://fmbmachinery.com/<?php echo 404 ?>";
</script>  
    
 <?php   
}
?>
<!-- oncontextmenu='return false' -->
<body class='snippet-body'>
    <link rel='stylesheet' href='https://sachinchoolur.github.io/lightslider/dist/css/lightslider.css'>
<!-- Top Bar Start -->
<?php include_once'include/header.php'; ?>

            <!-- Page Header Start -->
            <div class="page-header">
                <div class="container">
                    <div class="row">
                        <div class="col-12">
                            <h2>Single Page</h2>
                        </div>
                        <div class="col-12">
                            <a href="">Home</a>
                            <a href="">Single Page</a>
                        </div>
                    </div>
                </div>
            </div>
            <!-- Page Header End -->


            <!-- Single Post Start-->
            <div class="single">
                <div class="container">
                    <div class="row">
                        <div class="col-lg-8">
                            <div class="single-content wow fadeInUp">
                                <img src="images/blog-image/<?php echo $banner; ?>" />
                                <h2><?php echo $name; ?></h2>
                                <p>
                                    <?php echo $short; ?>
                                </p>
                                <p>
                                    <?php echo $desc; ?>
                                </p>
                               
                            </div>
                           
                        </div>

                        <div class="col-lg-4">
                            <div class="sidebar">
                                
                                <div class="sidebar-widget wow fadeInUp">
                                    <h2 class="widget-title">Recent Post</h2>
                                    <div class="recent-post">
                                        <?php
                                            $blog = mysqli_query($con, "SELECT * FROM `blogs`");
                                            while($row = mysqli_fetch_array($blog))
                                            {
                                                $name = $row['name'];
                                                $banner = $row['banner'];
                                                $short = $row['short_description'];
                                                $slug = $row['slug'];
                                        ?>
                                        <div class="post-item">
                                            <div class="post-img">
                                                <img src="images/blog-image/<?php echo $banner; ?>" />
                                            </div>
                                            <div class="post-text">
                                                <a href="single.php?slug=<?php echo $slug; ?>"><?php echo $name; ?></a>
                                                <div class="post-meta">
                                                    <p>By<a href="">Admin</a></p>
                                                    <p>In<a href="">Design</a></p>
                                                </div>
                                            </div>
                                        </div>
                                        <?php 
                                            }
                                        ?>
                                    </div>
                                </div>

                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!-- Single Post End-->   

<?php include_once('include/footer.php'); ?></body>