<?php
   include 'header.php';
?>



<div class="page-banner-area bg-2">
   <div class="container">
      <div class="page-banner-content">
         <h1>Events</h1>
         <ul>
            <li><a href="index.php">Home</a></li>
            <li>Events</li>
         </ul>
      </div>
   </div>
</div>




<section class="sectionPadding pt-100 pb-70">
    <div class="container">
        <div class="row justify-content-center">
            <div class="col-xl-6 col-lg-7">
                <div class="section-title text-center">
                    <h6 class="sub-title double-line">Event </h6>
                    <h2 class="title mt-3">School Activities </h2>
                </div>
            </div>
        </div>
        <div class="row justify-content-center">
         <?php
          $query = $conn->prepare("SELECT * FROM events order by id desc");
          $query->execute();
          $events_result = $query->fetchAll();
          $events_row = count($events_result); 
          if($events_row>0) {
            foreach ($events_result as $value) {
               $title = $value['title'];
               $url = $value['url'];
               $description = $value['description'];
               $created_at = date_create($value['created_at']);

         ?>
           <div class="col-lg-4 col-md-6" data-aos="fade-up" data-aos-duration="1200" data-aos-delay="200" data-aos-once="true">
              <div class="single-events-card">
                 <div class="events-image">
                    <a href="event-details.php?url=<?php echo  $url; ?>"><img src="bb-admin/upload/events/<?php echo $value['feature_img'] ?>" style="width:100%;height:240px;object-fit:cover"></a>
                    <div class="date">
                       <span><?php echo date_format($created_at,"d"); ?></span>
                       <p><?php echo date_format($created_at,"M"); ?></p>
                    </div>
                 </div>
                 <div class="events-content">
                    <!-- <div class="admin">
                       <p><a href="#"><i class="flaticon-student-with-graduation-cap"></i>Children Day</a></p>
                    </div> -->
                    <a href="event-details.php?url=<?php echo  $url; ?>">
                       <h3><?php if(!empty($title)){echo $title; } ?></h3>
                    </a>
                 </div>
              </div>
           </div>

           <?php
            }
         }
        ?>
           
           <!-- <div class="col-lg-4 col-md-6" data-aos="fade-up" data-aos-duration="1200" data-aos-delay="600" data-aos-once="true">
              <div class="single-events-card">
                 <div class="events-image">
                    <a href="#"><img src="assets/images/product/event3.jpeg" style="width:100%;height:240px;object-fit:cover"></a>
                    <div class="date">
                       <span>26</span>
                       <p>Jan</p>
                    </div>
                 </div>
                 <div class="events-content">
                    <div class="admin">
                       <p><a href="#"><i class="flaticon-student-with-graduation-cap"></i> Republic Day</a></p>
                    </div>
                    <a href="#">
                       <h3>"Let's honor the sacrifices made by our heroes and take joy in the glory of our great nation."</h3>
                    </a>
                 </div>
              </div>
           </div> -->

        </div>
    </div>
</section>






<?php
   include 'footer.php';
   ?>