<?php 
  include "blog/admin/db_connection.php";
?>






<section class="advance-courses-area advance-courses-area-2 pb-120 pt-105 bg_cover" style="background-image: url(assets/images/counter-bg-3.png)">
        <div class="container">
            <div class="row courses-active">
           
            <?php $sql = "SELECT * from  bloggomtinagar";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)
{				?>	



                <div class="col-lg-6">
                    <div class="single-courses mt-30">
                        <div class="courses-thumb">
                        <img src="blog/admin/images/blog/<?php echo $view_post_image; ?>" alt="User Image" width="50" align="left" hspace="5">
                            <div class="courses-review">
                                <span><span><i class="fas fa-star"></i>5.6</span> (1200+)</span>
                            </div>
                            <div class="corses-thumb-title">
                                <span>Blog</span>
                            </div>
                        </div>
                        <div class="courses-content">
                        <a href="blog/post.php?postid=<?= $view_post_id; ?>"
                                <h4 class="title"><?php echo $view_post_title ?></h4>
                            </a>
                            <div class="courses-info d-flex justify-content-between">
                                <div class="item">
                                   <!-- <img src="assets/images/courses-info-thumb.png" alt="courses info">-->
                                    <p><?php  echo substr($view_post_text, 0, 50) . "..."; ?></p>
                                </div>
                              <!--  <span>$46</span>-->
                            </div>
                            <ul>
                                <li><i class="fal fa-users"></i><?php echo $view_post_visit_counter ?></li>
                                <li><i class="fal fa-clock"></i> <?php echo $view_post_date ?></li>
                                <li><i class="fal fa-comments"></i> 143</li>
                            </ul>
                        </div>
                    </div>
                </div>
                <?php }} ?>
               
            </div>
        </div>
    </section>