<?php


session_start();

$name = $_SESSION['user_name'];



if (isset($_SESSION['user_name']) or !empty($_SESSION['user_name'])) {

 

}else{

   header("location:../index.php");

}



?>



<?php include_once __DIR__.'/config/header.php'; ?>

<br>

<br>

<br>

<?php include __DIR__.'/config/db_connect.php'; ?>

<?php

$sql = "select * from tbl_post";

$result_set = mysqli_query($con,$sql);

$count = @mysqli_num_rows($result_set);

?>

<section id="faq" class="faq section-bg">

  <div class="container">

    <div class="section-title" data-aos="fade-up">

      <h2>BLOG POST</h2>

      <p>MY BLOG POST</p>

    </div>

    <div class="faq-list">

      <ul>

        <?php

        if ($count>0) {

        while ($row = mysqli_fetch_assoc($result_set)) { ?>

       

        <li data-aos="fade-up">

          <i class="bx bx-help-circle icon-help"></i> <a style="color:#191c93;"  href="posts/<?php echo $row['slug']; ?>" target="_blank"> <?php echo $row['title']; ?></a>

          <a href=""><?php echo $row['name']; ?></a>

           <a  href="admin/posts/<?php echo $row['slug']; ?>" target="_blank" ><i class="fa fa-eye icon-close" style="color:#191c93;"></i></a>


           <a  href="admin/update/<?php echo $row['id']; ?>" target="_blank"><i class="fa fa-wrench icon-show" style="color:orange;"></i></a>

            <a  href="admin/post_del/<?php echo $row['id']; ?>" onclick="return confirm('Are you sure you want to delete this item?');"><i class="fa fa-trash icon-update" style="color:red;"></i></a>

       

          

        </li>

       

       

        <?php

        }

        }else{

        echo "No record found";

        }

        ?>

        <!-- ======= F.A.Q Section ======= -->

        

        

        

        

        

      </ul>

    </div>

  </div>

  </section><!-- End F.A.Q Section -->



  <!-- Vendor JS Files -->

  <script src="assets/vendor/jquery/jquery.min.js"></script>

  <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

  <script src="assets/vendor/jquery.easing/jquery.easing.min.js"></script>

  <script src="assets/vendor/php-email-form/validate.js"></script>

  <script src="assets/vendor/venobox/venobox.min.js"></script>

  <script src="assets/vendor/waypoints/jquery.waypoints.min.js"></script>

  <script src="assets/vendor/counterup/counterup.min.js"></script>

  <script src="assets/vendor/owl.carousel/owl.carousel.min.js"></script>

  <script src="assets/vendor/aos/aos.js"></script>


  <!-- Template Main JS File -->

  <script src="assets/js/main.js"></script>



 

All Post Show in Php