main_page2.php

<?php

include("connection.php");

include("page_content/header.php");
error_reporting(E_ALL ^ E_WARNING); 

if(isset($_POST['budget_post']))
{
	$budget=$_POST['budget'];
	$district=$_POST['district'];

	$sql_trasnport="select * from transport_cost where source ='$district'";
	$res_transport=mysqli_query($conn,$sql_trasnport);
	
	$place_name=array();
	while($row_transport=mysqli_fetch_array($res_transport))
	{
		$cost=0;
		$cost=$cost+ $row_transport['cost'];
		

		 $destination=$row_transport['destination'];

		
		  $sql_res="SELECT * from res where place_name='$destination'";
		  $res_res=mysqli_query($conn,$sql_res);
		   while($row_res=mysqli_fetch_array($res_res))
		   { 
		   	
             $cost=$cost+$row_res['Lunch'];
             //$res_name =$row_res['res_name'];
		   	 
               $sql_hotel="SELECT * from hotel where place_name='$destination'";
               $res_hotel=mysqli_query($conn,$sql_hotel);
               while($row_hotel=mysqli_fetch_array($res_hotel))
               {
               	$cost1=$cost+$row_hotel['price'];
              
                if($cost1<$budget)
                {    if(!in_array($destination, $place_name)){
                	$place_name[]=$destination;
               //  	$fp = fopen('lidn.txt', 'a+');
               // fwrite($fp, $destination." ");
           }
                	
                	
                }
                
                 
               
               }

		   }

		   	
    
	}
	$place_name=array_unique($place_name);

	

}



  // file_put_contents("sss.txt", $district.$view);

?>
<!-- ======================= End Navigation ===================== -->

<!-- ======================= Start Banner ===================== -->

<!-- ======================= End Banner ===================== -->
<div class="clearfix"></div>




<!-- ====================== Popular Tour ================= -->
<section class="gray-bg">
	<div class="container">
		<div class="row">
			<div class="col-md-12">
			    
			    <div class="heading">
               <?php  if($place_name !=NULL){ ?>
					<h1>Your Searching Place</h1>
				<?php }
                else {
				?>
				<h1>This type of place doesn't exist </h1>
			<?php }  ?>
				</div>
				 
			</div>
		</div>



		<div class="row">

			<!-- Single Destination -->

			<?php 
			for($i=0;$i<count($place_name);$i++)
			{



				$place=$place_name[$i];
				$sql="Select * from place where place_name='$place'";
				$res=mysqli_query($conn,$sql);
				$row=mysqli_fetch_array($res);
				
					$place_id=$row['id'];

				$sql3="Select * from place_review where place_id=$place_id";
				$res3=mysqli_query($conn,$sql3);
				$rating=0;
				$num_of_review=mysqli_num_rows($res3);
				while($row3=mysqli_fetch_array($res3))

				{
					$rating=$rating+$row3['rating'];



				}
              if($num_of_review==0)
              {
              	$num_of_review=1;
              }

              if($rating==0)
              {
              	$rating=0;
              }
				$rating=floor($rating/$num_of_review);
				
				

				?>
				<div class="col-md-4 col-sm-6">
					<article class="destination-box style-1">

						<div class="destination-box-image">
							<figure>
								<a href="place.php?id=<?php echo $row['id']  ?>">
									<img src="<?php echo $row['place_image']  ?>" class="img-responsive listing-box-img" alt="" />
									<div class="list-overlay"></div>
								</a>

								<h4 class="destination-place">
									<a href="place.php?id=<?php echo $row['id']  ?>"><?php echo $row['district'] ?></a>
								</h4>
								
							</figure>
						</div>

						<div class="entry-meta">
							<div class="meta-item meta-rating">

								<?php 
									if ($rating < 1) {
								?>
								<p style="margin:0px;font-size:10px;" >No Ratings</p>
								<?php
							}else {
								 for($j=0;$j<$rating;$j++) 
                                  {
								?>

								<i class="fa fa-star"></i>
								<?php
                                  }
                              }
								?>
							</div>

						</div>


						<div class="inner-box">
							<div class="box-inner-ellipsis">
								<h4 class="entry-location">
									<a href="place.php?id=<?php echo $row['id']  ?>"><?php echo $row['place_category'].','.$row['place_name'] ?> </a>
								</h4>
								<div class="price-box">
									<div class="destination-price fl-right">
										<a href="place.php?id=<?php echo $row['id']  ?>"><i class="theme-cl ti-arrow-right"></i></a>
									</div>
								</div>
							</div>
						</div>

					</article>
				</div>


				<?php
			}

			?>

			<!-- Single Destination -->
















			

		</div>
	</section>

	<div class="clearfix"></div>



	




	<!-- ================= footer start ========================= -->
	<?php  
	include("page_content/footer.php");

	?>

	<!-- Sign Up Window Code -->
	<div class="modal fade" id="signin" tabindex="-1" role="dialog" aria-labelledby="myModalLabel1" aria-hidden="true">
		<?php include("page_content/login_window.php"); ?>
	</div>   
	<!-- End Sign Up Window -->


	<!-- =================== START JAVASCRIPT ================== -->
	<script src="assets/plugins/js/jquery.min.js"></script>
	<script src="assets/plugins/js/bootstrap.min.js"></script>
	<script src="assets/plugins/js/viewportchecker.js"></script>
	<script src="assets/plugins/js/bootsnav.js"></script>
	<script src="assets/plugins/js/slick.min.js"></script>
	<script src="assets/plugins/js/jquery.nice-select.min.js"></script>
	<script src="assets/plugins/js/jquery.fancybox.min.js"></script>
	<script src="assets/plugins/js/jquery.downCount.js"></script>
	<script src="assets/plugins/js/freshslider.1.0.0.js"></script>
	<script src="assets/plugins/js/moment.min.js"></script>
	<script src="assets/plugins/js/daterangepicker.js"></script>
	<script src="assets/plugins/js/wysihtml5-0.3.0.js"></script>
	<script src="assets/plugins/js/bootstrap-wysihtml5.js"></script>
	 <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>

	<!-- Dashboard Js -->
	<script src="assets/plugins/js/jquery.slimscroll.min.js"></script>
	<script src="assets/plugins/js/jquery.metisMenu.js"></script>
	<script src="assets/plugins/js/jquery.easing.min.js"></script>

	<!-- Custom Js -->
	<script src="assets/js/custom.js"></script>
	<script type="text/javascript" src="assets/js/sweetalert.min.js"></script>

	<script>
		$(function() {

			$('input[name="book-date"]').daterangepicker({
				autoUpdateInput: false,
				locale: {
					cancelLabel: 'Clear'
				}
			});

			$('input[name="book-date"]').on('apply.daterangepicker', function(ev, picker) {
				$(this).val(picker.startDate.format('MM/DD/YYYY') + ' - ' + picker.endDate.format('MM/DD/YYYY'));
			});

			$('input[name="book-date"]').on('cancel.daterangepicker', function(ev, picker) {
				$(this).val('');
			});

		});
	</script>

	<script src="assets/js/jQuery.style.switcher.js"></script>
	<script>
		function openRightMenu() {
			document.getElementById("rightMenu").style.display = "block";
		}
		function closeRightMenu() {
			document.getElementById("rightMenu").style.display = "none";
		}
	</script>

	<script type="text/javascript">
		$(document).ready(function() {
			$('#styleOptions').styleSwitcher();
		});
	</script>
	
</body>

</html>