<!-- ======= Hero Slider Section ======= -->
    <section id="hero-slider" class="hero-slider">
      <div class="container-md" data-aos="fade-in">
        <div class="row">
          <div class="col-12">
            <div class="swiper sliderFeaturedPosts">
              <div class="swiper-wrapper">
                <!--BEGIN LEFT 2 BLOCK-->
                <?php
                    

                    $news = $conn->query("SELECT p.*, c.category FROM post_list p INNER JOIN category_list c ON c.id = p.category_id WHERE  c.id = 5 ORDER BY unix_timestamp(date_published) DESC LIMIT 6");

                    if ($news->num_rows > 0):
                      while($row = $news->fetch_assoc()):
                        // Format date_published to display only the date part (YYYY-MM-DD)
                        $date_published = date('F j, Y', strtotime($row['date_published']));

                        $trans = get_html_translation_table(HTML_ENTITIES, ENT_QUOTES);
                        unset($trans["\""], $trans["<"], $trans[">"], $trans["<h2"]);
                        $desc = strtr(html_entity_decode($row['content']), $trans);
                        $desc = str_replace(array("<li>", "</li>"), array("", ", "), $desc);
                        ?>
                        <div class="swiper-slide">
                      <a href="#" class="img-bg d-flex align-items-end" style="background-image: url('assets/uploads/content_images/<?php echo $row['cover_img'] ?>');">
                            <div class="img-bg-inner">
                              <h2><?php echo $row['title'] ?></h2>
                              <p><?php echo strip_tags($desc) ?>.</p>
                            </div>
                          </a>
                        </div>
                        <?php  endwhile; endif;?>
                 <!--END BLOCK-->
              
               

              </div>
              <div class="custom-swiper-button-next">
                <span class="bi-chevron-right"></span>
              </div>
              <div class="custom-swiper-button-prev">
                <span class="bi-chevron-left"></span>
              </div>

              <div class="swiper-pagination"></div>
            </div>
          </div>
        </div>
      </div>
    </section><!-- End Hero Slider Section -->