events.php

<?php if(!isset($_SESSION)) { session_start(); } ?>
<?php include('func/function.php'); ?>
<?php include('inc/head.php'); ?>
<title>lifesadventure | Events</title>
<?php include('inc/header.php'); ?>
<?php include('register.php'); ?>
<?php include('sign-in.php'); ?>
<?php 
	if (isset($_GET['e_id'])) {
		$cn = makeconnection();
		$event_id = mysqli_real_escape_string($cn, $_GET['e_id']);
		$event_select = "SELECT * FROM event WHERE id={$event_id}";
		$event_query = mysqli_query($cn, $event_select);
		while ($event_data = mysqli_fetch_array($event_query)) { ?>

			<style type="text/css">
				.map-ratings-review-area {
					right: 5px;
				}
				.map-ratings-review-area.creator {
					bottom: 0;
				}
				.map-ratings-review-area {
					bottom: 60px;
				}
				.map-ratings-review-area.creator a {
					background-color: #7643ea;
					color: white;
				}
				#advertisement p {
					position: absolute;
					top: calc(50% - 18px);
					left: 45%;
					height: 35px;
					background-color: #2a2a2a;
			        font-size: 12px;
			        line-height: 35px;
			        margin-bottom: 0;
			        padding: 0 15px;
			        font-weight: 600;
			        color: #fff;
			        z-index: 9;
				}
				.img.modal-footer, .img.modal-header {
					padding: 0 5px 0 0;
				}
				.modal-footer button {
					border-radius: 0;
					margin: 5px 2px 5px 0;
				}
				.listing-menu-area .modal {
					background-color: #2a2a2a;
				}
				.listing-menu-area .modal-content {
					background-color: rgba(0,0,0,.8);
				}
				.listing-menu-area .close {
					color: white;
				}
				.image:hover {
					cursor: pointer;
				}
				.carousel-item, .carouse-item img {
					max-height: 600px;
				}
			</style>
			<!-- ***** Breadcumb Area Start ***** -->
		    <div class="breadcumb-area height-700 bg-img bg-overlay" style="background-image: url(uploads/<?php echo $event_data['image1']; ?>); background-attachment: fixed; background-position: center;">
		        <div class="container">
		            <div class="row">
		                <div class="col-12">
		                    <div class="breadcumb-content">
		                    	<div class="map-ratings-review-area creator d-flex">
		                        	<a href="" class="text-capitalize">Created By <?php echo $event_data['creator']; ?></a>
		                        </div>
		                        <div class="map-ratings-review-area d-flex">
		                            <a target="_blank" href="http://maps.google.com/maps?daddr=<?php echo $event_data['street']; ?>&amp;ll=" class="d-flex align-items-center justify-content-center"><i class="fas fa-map"></i></a>
		                            <a href=""><?php echo date('d M', strtotime($event_data['date_added'])); ?></a>
		                        </div>
		                    </div>
		                </div>
		            </div>
		        </div>
		    </div>
		    <!-- ***** Breadcumb Area End ***** -->

		    <!-- ***** Single Listing Area Start ***** -->
		    <section class="dorne-single-listing-area section-padding-100">
		        <div class="container">
		            <div class="row justify-content-center">
		                <!-- Single Listing Content -->
		                <div class="col-12 col-lg-8">
		                    <div class="single-listing-content">
		                    	<?php 
									if (isset($_GET['e_id'])) {
										$cn = makeconnection();
										$id = mysqli_real_escape_string($cn, $_GET['e_id']);   
					                    $view_query = "UPDATE event SET event_visit_counter = event_visit_counter + 1 WHERE id= '$id' ";
					                    $send_query = mysqli_query($cn, $view_query);
										$s = "SELECT * FROM event WHERE id='$id' ";
										$q = mysqli_query($cn, $s);
										while ($data = mysqli_fetch_array($q)) {
											$a_id = $data['id'];
											if ($id == $a_id) {
												$a_title = $data['title'];
												$a_description = $data['description'];
												$a_province = $data['province'];
												$a_street = $data['street'];
												$a_zip = $data['zip'];
												$a_group_size = $data['group_size'];
												$a_date = $data['date_added'];
												$a_img = $data['image'];
												$a_img1 = $data['image1'];
												$a_img2 = $data['image2'];
											?>

											<div class="listing-title">
					                            <h3 class="text-uppercase"><?php echo $data['title']; ?></h3>
					                            <a href="adventures.php?filter%5B%5D=<?php echo $data['group_size']; ?>"><h6><?php echo $data['group_size']; ?> Type</h6></a>
					                        </div>

					    					<?php }
										} 
									} else {
										header('location: index.php');
									}
								?>

		                        <div class="single-listing-nav">
		                            <nav>
		                                <ul id="listingNav">
		                                    <li class="active"><a href="#overview">Overview</a></li>
		                                    <li><a href="#images">Images</a></li>
		                                    <li><a href="#lomap">Location</a></li>
		                                </ul>
		                            </nav>
		                        </div>

		                        <div class="overview-content mt-40" id="overview">
		                            <h6><?php echo $a_description; ?></h6>
		                        </div>

		                        <div class="listing-menu-area" style="margin-top: 60px;" id="images">
		                            <h4 style="margin-bottom: 30px;">More Images</h4>
		                            <div class="row">
										<div class="col-md-12">
											<section class="more-image row">
												<div class="col-md-4 mt-2">
													<img class="image" data-toggle="modal" data-target="#imageModal" src="uploads/<?php echo $a_img; ?>" style="height: 250px; width: 100%;">
												</div>
												<div class="col-md-4 mt-2">
													<img class="image" data-toggle="modal" data-target="#imageModal" src="uploads/<?php echo $a_img1; ?>" style="height: 250px; width: 100%;">
												</div>
												<div class="col-md-4 mt-2">
													<img class="image" data-toggle="modal" data-target="#imageModal" src="uploads/<?php echo $a_img2; ?>" style="height: 250px; width: 100%;">
												</div>
											</section>
										</div>
		                            	<!-- Modal -->
										<div class="modal fade" id="imageModal" tabindex="-1" role="dialog" aria-labelledby="imageModalLabel" aria-hidden="true">
											<div class="modal-dialog modal-lg" role="document">
												<div class="modal-content">
													<div class="modal-header img">
														<button type="button" class="close" data-dismiss="modal" aria-label="Close">
															<span aria-hidden="true">&times;</span>
														</button>
													</div>
													<div class="modal-body">
														<div id="carouselExampleControls" class="carousel slide" data-ride="carousel">
															<div class="carousel-inner">
																<div class="carousel-item active">
																	<img class="d-block w-100" src="uploads/<?php echo $a_img; ?>" alt="First slide">
																</div>
																<div class="carousel-item">
																	<img class="d-block w-100" src="uploads/<?php echo $a_img1; ?>" alt="Second slide">
																</div>
																<div class="carousel-item">
																	<img class="d-block w-100" src="uploads/<?php echo $a_img2; ?>" alt="Second slide">
																</div>
															</div>
															<a class="carousel-control-prev" href="#carouselExampleControls" role="button" data-slide="prev">
																<span class="carousel-control-prev-icon" aria-hidden="true"></span>
																<span class="sr-only">Previous</span>
															</a>
															<a class="carousel-control-next" href="#carouselExampleControls" role="button" data-slide="next">
																<span class="carousel-control-next-icon" aria-hidden="true"></span>
																<span class="sr-only">Next</span>
															</a>
														</div>
													</div>
													<div class="modal-footer img">
														<button type="button" class="btn btn-dark" data-dismiss="modal">Close</button>
													</div>
												</div>
											</div>
										</div>
		                            </div>
		                        </div>

					            <div class="location-on-map" id="lomap">
		                            <h4 style="margin-bottom: 30px; margin-top: 30px;">Location</h4>
		                            <a target="_blank" href="http://maps.google.com/maps?daddr=<?php echo $a_street; ?>&amp;ll=">
		                            	<h5><?php echo $a_street; ?>, <?php echo $a_zip; ?> <?php echo $a_province; ?></h5>
		                            </a>
		                        </div>
		                    </div>
		                </div>

		                <!-- Listing Sidebar -->
		                <div class="col-12 col-md-8 col-lg-4">
		                    <div class="listing-sidebar">

		                        <!-- Listing Verify -->
		                        <div class="listing-verify">
		                            <a target="_blank" href="http://maps.google.com/maps?daddr=<?php echo $a_street; ?>&amp;ll=" class="btn dorne-btn w-100"><i class="fas fa-map"></i> &nbsp; Get Location</a>
		                        </div>
		                        <div class="listing-verify"  style="margin-top: 10px;">
		                            <a href="#" id="downloadPDF" class="btn dorne-btn w-100"><i class="fas fa-download"></i> &nbsp; Download PDF</a>
		                        </div>
		                       	
		                        <!-- Book A Table Widget -->
		                        <div class="book-a-table-widget mt-50">
		                            <h6>Advertisement</h6>
		                            <section class="advertise slider">
		                            	<?php 
		                            		$cn = makeconnection();
		                            		$s = "SELECT * FROM advertisement";
		                            		$q = mysqli_query($cn, $s);
		                            		if (mysqli_num_rows($q) <= 0) {
		                            			echo "<h3>No Advertisement...</h3>";
		                            		} else {
		                            			while ($adData = mysqli_fetch_array($q)) { ?>
			                            			<div class="slide" style="position: relative;">
														<a href="<?php echo $adData['link'];?>" target="_blank">
															<img class="image" src="uploads/<?php echo $adData['image']; ?>" style="height: 250px;">
														</a>
														<a href="<?php echo $adData['link'];?>" target="_blank" style="position: absolute; top: 5px; left: 5px; background-color: #2a2a2a; color: white; padding: 5px 8px 5px 8px;">Sponsored</a>
													</div>
			                            		<?php }
		                            		}
		                            	?>
									</section>
		                        </div>
		                        <div class="listing-verify mt-50" style="border-bottom: 1px solid darkgrey;">
		                            <a href="accommodation.php" class="btn dorne-btn w-100"><i class="fas fa-hotel"></i> &nbsp; Book Accommodation</a>
		                        </div>
		                        <div class="listing-verify"  >
		                            <a href="transportAPI/transport.php" target="_blank" class="btn dorne-btn w-100"><i class="fas fa-bus-alt"></i> &nbsp; Book Transportation</a>
		                        </div>
		                    </div>
		                </div>
		                <div class="col-lg-12">
		                	<div class="listing-menu-area" style="margin-top: 60px;">
		                        <h4 style="margin-bottom: 30px;">Advertisement</h4>
		                        <div style="position: relative;" id="advertisement">
		                        	<?php 
	                            		$cn = makeconnection();
	                            		$s = "SELECT * FROM advertisement";
	                            		$q = mysqli_query($cn, $s);
	                            		if (mysqli_num_rows($q) <= 0) {
	                            			echo "<h1>No Advertisement..</h1>";
	                            		} else {
	                            			while ($adData = mysqli_fetch_array($q)) { ?>
		                            			<div class="slide" style="position: relative;">
													<a href="<?php echo $adData['link'];?>" target="_blank">
														<img class="image" src="uploads/<?php echo $adData['image']; ?>" style="height: 250px;">
													</a>
													<a href="<?php echo $adData['link'];?>" target="_blank" style="position: absolute; top: 5px; left: 5px; background-color: #2a2a2a; color: white; padding: 5px 8px 5px 8px;">Sponsored</a>
												</div>
		                            		<?php }
	                            		}
	                            	?>
		                        </div>
		                    </div>
		                </div>
		            </div>
		        </div>
		    </section>
		<?php }
	} else { ?>
		<link rel="stylesheet" href="css/adventures/new-style.css">
    	<link rel="stylesheet" href="css/adventures/animate.css">

	    <style type="text/css">
	    	.destination .a-img {
	    		overflow: hidden;
	    	}
	    	.destination .a-img:hover img {
	    		transform: scale(1.2);
	    		transition: all .8s ease;
	    	}
	    	.a-img img {
	    		height: 350px;
	    	}
	    	.multiselect {
				width: 200px;
			}
			.selectBox, .selectBox1, .selectBox2, .selectBox3 {
				position: relative;
			}
			.selectBox select, .selectBox1 select, .selectBox2 select, .selectBox3 select {
				width: 100%;
				font-weight: normal;
				height: 50px;
				padding-left: 20px;
				background-color: white;
				border: 1px #dadada solid;
			}
			.overSelect, .overSelect1, .overSelect2, .overSelect3 {
				position: absolute;
				left: 0;
				right: 0;
				top: 0;
				bottom: 0;
			}
			#checkboxes, #checkboxes1, #checkboxes2, #checkboxes3 {
				display: none;
				border: 1px #dadada solid;
				padding: 10px;
			}
			#checkboxes label, #checkboxes1 label, #checkboxes2 label, #checkboxes3 label {
				display: block;
			}
			#checkboxes label:hover, #checkboxes1 label:hover, #checkboxes2 label:hover, #checkboxes3 label:hover {
				background-color: #1e90ff;
			}
			.area, .area:hover {
				font-size: 6px;
				font-weight: normal;
				color: black !important;
				text-decoration: none;
			}
			.block-27 ul {
				padding: 0;
				margin: 0; 
				max-width: 100%;
			}
			.block-27 ul li {
				display: inline-block;
				margin-bottom: 4px;
				font-weight: 400; 
			}
			.block-27 ul li a, .block-27 ul li span {
				color: #e9ecef;
				text-align: center;
				display: inline-block;
				width: 40px;
				height: 40px;
				line-height: 40px;
				border-radius: 50%;
			}
			.block-27 ul li.active a, .block-27 ul li.active span {
				background: #e9ecef;
				color: #f85959;
				border: 1px solid transparent; 
			}
			@media (min-width: 1024px) and (max-width: 1366px) {
				.a-img img {
		    		height: 270px;
		    	}
			}
			@media (min-width: 768px) and (max-width: 1023px) {
				.a-img img {
		    		height: 265px;
		    	}
			}			
	    </style>

		<section class="bg-img bg-overlay-9" style="background-image: url(assets/ireland1.jpg); background-attachment: fixed; padding-top: 10em; padding-bottom: 5em;">	            
			<div class="container-fluid">
				<div class="row">
					<div class="col-lg-10 offset-lg-1">
						<?php if ($msgl != ''): ?>
		                    <div class="alert <?php echo $msglClass; ?> text-center col-lg-10 offset-lg-1 alert-dismissable" id="flash-msg">
		                        <?php echo $msgl; ?>
		                        <button aria-hidden="true" data-dismiss="alert" class="close" type="button">&times;</button>
		                    </div>
		                <?php endif; ?>
						<div class="row">
							<?php 
								$cn = makeconnection();
								$per_page = 6;
				                if(isset($_GET['page'])){
				                    $page = $_GET['page'];
				                } else {
				                    $page ="";
				                }
				                
				                if($page == "" || $page == 1){
				                    $page_1 = 0;
				                } else {
				                    $page_1 =($page * $per_page) - $per_page;
				                }

				                $adv_query_count ="SELECT * FROM event";
				                $find_count  = mysqli_query($cn,$adv_query_count);
				                $count = mysqli_num_rows($find_count);
				                
				                $count = ceil($count / $per_page);

								$s = "SELECT * FROM event LIMIT $page_1,$per_page";
								$q = mysqli_query($cn, $s);
								$r = mysqli_num_rows($q);

								while ($data = mysqli_fetch_array($q)) {
									$image = $data['image'];
								?>
								<div class="col-md-4 col-md col-lg-4 col-sm-6 ftco-animate">
									<div class="destination">
										<div class="a-img">
											<a href="events.php?e_id=<?php echo $data['id']; ?>">
												<img src="uploads/<?php echo $image; ?>" alt="<?php echo $data['title']; ?>" style="width: 100%;">
											</a>
										</div>
										<div class="text p-3">
											<div class="d-flex">
												<h3>
													<a href="events.php?e_id=<?php echo $data['id']; ?>" class="text-capitalize text-primary">
														<?php echo $data['title']; ?>		
													</a>
												</h3>
											</div>
											<p class="star">
												Organized by <?php echo $data['creator']; ?>
											</p>
											<div style="width: 100%; text-overflow: ellipsis; white-space: nowrap;overflow: hidden;">
												<?php echo $data['description']; ?>
											</div>
											<hr>
											<p class="bottom-area d-flex">
												<a target="_blank" href="http://maps.google.com/maps?daddr=<?php echo $data['street']; ?>&amp;ll=" class="area">
													<span>
														<i class="fas fa-map"></i> <?php echo $data['street']; ?>, <?php echo $data['province']; ?>
													</span>
												</a> 
												<span class="ml-auto">
													<a class="bg-primary" style="border-radius: 0;" href="events.php?e_id=<?php echo $data['id']; ?>">Explore</a>
												</span>
											</p>
										</div>
									</div>
								</div>
							<?php }
							?>
						</div>
					</div> <!-- .col-md-9 -->
				</div>
				<div class="row mt-5">
					<div class="col text-center">
						<div class="block-27">
							<ul>
								<?php
									for ($page=1; $page <= $count ; $page++) { 
										$page_next = $page_1+1;
										if ($page == $page_next) { ?>
											<li class='active'><span><a href='events.php?page=<?php echo $page; ?>'><?php echo $page; ?></a></span></li>
										<?php } elseif ($page == $page_next+1) { ?>
											<li><span><a href='events.php?page=<?php echo $page_next+1; ?>'><i class="fas fa-angle-right"></i></a></span></li>
											<li><span><a href='events.php?page=<?php echo $count; ?>'><i class="fas fa-angle-double-right"></i></a></span></li>
										<?php } elseif ($page == $page_next-1) { 
											if ($page_next > 2) { ?>
												<li><span><a href='events.php'><i class="fas fa-angle-double-left"></i></a></span></li>
											<?php } ?>
											<li><span><a href='events.php?page=<?php echo $page_next-1; ?>'><i class="fas fa-angle-left"></i></a></span></li>
										<?php }
									} 
			                    ?>
							</ul>
						</div>
					</div>
				</div>
			</div>
		</section>
	<?php }
?>

<?php include('inc/footer.php'); ?>