<!-- ======= Hero Slider Section ======= -->
   <section id="hero-slider" class="hero-slider">
      <div class="">
        <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 -->

    <!-- recent match Section -->
    <section class="recent-match">
      <div class="container">
      <div class="row mb-2">
  <div class="col-12 d-flex justify-content-between align-items-center">
    <div class="text-left">
      <h6 class="" style="color:#14662e; font-size:12px">MATOKEO</h6>
    </div>
    <div class="text-right">
    <a href="./index.php?page=matokeo" class="more"><h6 class="" style="color:#14662e; font-size:12px">MATOKEO ZAIDI</h6></a>
    </div>
  </div>
</div>

      <div class="row">   
      <?php  include 'updates.php' ?>  
           
      </div>
    </section><!-- End recent match Section -->


    <!-- ======= Post Grid Section ======= -->
    <section id="posts" class="posts">
      <div class="container">
        <div class="row g-5">
        <?php include 'main_news.php' ?>         

          <div class="col-lg-8">
            <div class="row g-5">

            <?php include 'recommended.php' ?>

              <!-- Trending Section -->
              <div class="col-lg-4">

                <?php include 'trending.php' ?>

              </div> <!-- End Trending Section -->
            </div>
          </div>

        </div> <!-- End .row -->
      </div>
    </section> <!-- End Post Grid Section -->

      <!-- Tournament Section -->
      <section class="" style="background-color:#f1f1f1">
      <div class="container">
      <div class="row mb-2">
  <div class="col-12 d-flex justify-content-between align-items-center">
    <div class="text-left">
      <h6 class="" style="color:#14662e; font-size:12px">MASHINDANO YAJAYO</h6>
    </div>
    <div class="text-right">
    <a href="./index.php?page=tournaments" class="more"><h6 class="" style="color:#14662e; font-size:12px">ZAIDI</h6></a>
    </div>
  </div>
</div>
        <div class="row" style="font-size: 12px;">         
          <div class="col-lg-3 text-center ">
            <img src="assets/img/ndondo-dodoma.png" alt="" class="img-fluid tournament-image mb-4">
             <p>Ndondo Cup Dodoma | September 12 - 25, 2024</p> 
          </div>
          <div class="col-lg-3 text-center mb-5">
            <img src="assets/img/ndondo-mbeya.png" alt="" class="img-fluid tournament-image mb-4">
            <p>Ndondo Cup Mbeya | October 12 - 25, 2024</p>  
          </div>
          <div class="col-lg-3 text-center mb-5">
            <img src="assets/img/ndondo-arusha.png" alt="" class="img-fluid tournament-image mb-4">
            <p>Ndondo Cup Arusha | November 12 - 25, 2024</p>  
          </div>
            <div class="col-lg-3 text-center mb-5">
            <img src="assets/img/ndondo-mwanza.png" alt="" class="img-fluid tournament-image mb-4">
            <p>Ndondo Cup Mwanza | December 12 - 25, 2024</p>  
          </div>
            </div>
          
      </div>
    </section><!-- End Tournament Section -->


<!-- ======= Testimony Section ======= -->
    <section class="testimony-section py-5" style="margin-top:0px;">
      <div class="container">
        <div class="row justify-content-between align-items-lg-center">
        <?php include 'testimony.php' ?>
              </div>
      </div>
    </section><!-- ======= end Testimony Section ======= -->

    


    <!-- ======= Culture Category Section ======= -->
    <section class="category-section">
      <div class="container">

        <div class="section-header d-flex justify-content-between align-items-center mb-5">
          <h2>Mastori ya Ndondo Cup</h2>
          <div><a href="./index.php?page=category" class="more">Tazama zaidi</a></div>
        </div>

        <?php include 'stories.php' ?>
      </div>
    </section><!-- End Culture Category Section -->

   

    <!-- ======= Inside-Ndondo Section ======= -->
    <section class="inside-ndondo-section py-5">
    <div class="container">
  <div class="row align-items-center">
    <div class="col-lg-6 text-left">
      <h2 class="section-title">Explore What's Inside Ndondo Cup</h2>
      <p class="section-description">Discover the exciting features and updates of the Ndondo Cup, where football meets passion and community.</p>
      <a href="./index.php?page=category" class="btn btn-click">Explore</a>
    </div>
    <div class="col-lg-6 text-center d-none d-lg-block">
      <!-- Optional: Add an image or visual content here if needed -->
    </div>
  </div>
</div>
</section><!-- ======= end Inside Section ======= -->