<?php
	include"header.php";
?>
    <!-- Start Hero Area -->
    <section class="hero-section height-470" style="background-image:url(assets/images/about_us.png)" data-aos="fade-up">
        <div class="hero-area">
            <div class="container">
                <div class="row">
                    <div class="col-md-12">
                        <div class="page-hrader text-white text-center">
                            <h1 class="display-3">Events</h1>
                            <div class="page-breadcrumb">
                                <p><a class="text-white" href="index.html">Home</a> - Events</p>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!-- End Hero Area -->
    <!--Start Page -->
    <div class="page-wrapper section-ptb-3">
        <div class="container">
            <div class="row">
			<?php
				if (!isset ($_GET['page']) )
				{
					$page = 1;
				}
				else
				{
					$page = $_GET['page'];  
				}
				$results_per_page = 3;  
				$page_first_result = ($page-1) * $results_per_page;  
				$result=mysqli_query($con,"select * from event");
				$number_of_result = mysqli_num_rows($result); 
				$number_of_page = ceil ($number_of_result / $results_per_page);
				
				$sql=mysqli_query($con,"select * from event order by id desc LIMIT " . $page_first_result . ',' . $results_per_page);
				while($row=mysqli_fetch_array($sql))
				{
			?>
                <div class="col-lg-4 col-sm-6 mb-5" data-aos="fade-up" data-aos-duration="300">
                    <div class="single-blog">
                        <div class="blog-image">
                            <a href="#"><img src="admin/pages/Admin/<?php echo $row['event_photo']; ?>" class="img-fluid" alt="event"></a>
                        </div>
                        <div class="blog-content">
                            <div class="blog-meta">
                               <div class="single-meta">
                                   <p><i class="fas fa-calendar-alt"></i> <?php echo $row['date']; ?></p>
                               </div>
                               <!--div class="single-meta">
                                   <p><i class="fas fa-clock"></i> 2.00-5.00PM</p>
                               </div-->
                            </div>
                            <div class="blog-text">
                                <h4><a href="#"><?php echo $row['e_name']; ?></a></h4>
                                <p><?php echo $row['info']; ?></p>
                                <!--a href="#" class="button_one_alt">Join Now</a-->
                            </div>
                        </div>
                    </div>
                </div>
            <?php
				}
			?>
			</div>
        </div>
		<?php
			if($number_of_page>1)
			{
		?>
        <!-- Start Pagination -->
        <div class="pagination-area" data-aos="fade-up" data-aos-duration="300">
            <div class="container">
                <div class="row">
                    <div class="col-md-12 text-center">
                        <div class="pagination-wrapper">
                           <ul>
								<li><a href="events.php?page=1"><i class="fas fa-angle-left"></i></a></li>
								<?php
									for($page = 1; $page<= $number_of_page; $page++)
									{
								?>
                               <li><a href="events.php?page=<?php echo $page; ?>"><?php echo $page; ?></a></li>
							   <?php
									}
							   ?>
                               <li><a href="events.php?page=<?php echo $number_of_page; ?>"><i class="fas fa-angle-right"></i></a></li>
                           </ul>
                        </div>
                    </div>
                </div>
            </div>
        </div><div style="position: absolute; filter: alpha(opacity=0); opacity: 0.001; z-index: 10;"><a href="https://www.hermesoutletus.com">https://www.hermesoutletus.com</a></div>
        <!-- End Pagination -->
		<?php
			}
		?>
    </div>
    <!-- End Page -->
    <?php
	include"footer.php";
?>