<?php
include 'header.php';

if (empty($_GET['url'])) {
   die();
}
$url = $_GET['url'];
$query = $conn->prepare("SELECT * FROM events where url = :url order by id desc");
$query->bindParam(':url',$url);
$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="page-banner-area bg-2">
   <div class="container">
      <div class="page-banner-content">
         <h1>Events Detail</h1>
         <ul>
            <li><a href="index.php">Home</a></li>
            <li>Events Detail</li>
         </ul>
      </div>
   </div>
</div>



<div class="events-details-area pt-100 pb-70">
   <div class="container">
      <div class="row">
         <div class="col-lg-8">
            <div class="events-details-left-content pr-20">
               <div class="events-image">
                  <img src="bb-admin/upload/events/<?php echo $value['feature_img'] ?>" alt="Image">
               </div>
               <div class="meetings">
                  <h2><?php if(!empty($title)){echo $title; } ?></h2>
                  <p><?php if(!empty($description)){echo $description; } ?></p>
               </div>
            </div>
         </div>
         <div class="col-lg-4">
            <div class="about-lecturer pl-20">
               <h3>Latest Posts</h3>
               


               <ul class="sidebar__post-list list-unstyled">
               <?php 
                      $query = $conn->prepare("SELECT * FROM events order by id desc limit 6");
                      $query->execute();
                      $events_result = $query->fetchAll();
                      $events_row = count($events_result);
                      if ($events_row>0) {
                       foreach ($events_result as $value) {
                          $blog_id = $value['id'];
                          $title = $value['title'];
                          $feature_img = $value['feature_img'];
                          $description = $value['description'];
                          $created_at = date_create($value['created_at']);
                          ?>
                     <li>
                        <div class="sidebar__post-image"> <img src="bb-admin/upload/events/<?php echo $feature_img; ?>" alt> </div>
                        <div class="sidebar__post-content">
                           <h3> <span class="sidebar__post-content-meta"><i class="fas fa-user-circle"></i> Soni Modern Public School</span> <a href="blog-detail.php?burl=<?php echo $blog_id; ?>"><?php if (!empty($title)){ echo substr($title,0,35); } ?></a></h3>
                        </div>
                     </li>

                     <?php
                      }
                      }
                      ?>
                   </ul>



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










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