~NAXC~

File Content: `view_destination.php`

<?php

ob_start();

session_start();

include('config/connection_config.php');



if(isset($_POST['not_hot']))

{   $hotid = $_POST['hotid']; 

    mysqli_query($con,"update using_tour_tb set hot='yes' where id='".$hotid."'");

    header("location:view_destination.php");

	exit();	

}

else

if(isset($_POST['hot']))

{   $hotid = $_POST['hotid']; 

    mysqli_query($con,"update using_tour_tb set `hot` =  'no' where id='".$hotid."'");

	if($con){

	mysqli_query($con,"update using_tour_tb set `date_time` =  '000-00-00 00:00:00' where id='".$hotid."'");

	}

	header("location:view_destination.php");

	exit();	

}

?>



<!DOCTYPE html>

<html>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<head>

<title>View Theme, Admin Panel</title>

<!--Bootstrap css-->

<link href="css/bootstrap.css" rel='stylesheet' type='text/css'>

<!--/Bootstrap css-->

<!--Dropdown discription js-->

    <script type="text/javascript" src="js/left-dropdown/jquery-2.1.1.min.js"></script>

	<script type="text/javascript" src="js/left-dropdown/bootstrap.min.js"></script>

<!--Dropdown discription js-->

<!--our css-->

  <link href="css/mycss.css" rel='stylesheet' type='text/css'>

<!--/our css-->



</head>

<style type="text/css">

span.glyphicon.glyphicon-pencil{color:green;}

span.glyphicon.glyphicon-remove{color:red;}

.panel{background-image: linear-gradient(to bottom,orange 0,darkorange 100%);}

.panel-body {

    padding: 20px;

    background: white;

margin: 5px 20px 20px 20px;}

h2{color:white}

span.label.label-sm.label-danger a {

    color: white;

font-size: 12px;}

th {

    font-size: 15px;

}

td {

    font-size: 15px;

}

form {

    margin: 0;

    padding: 0; background:none;

}

input.btn.btn-danger, input.btn.btn-success{    padding: .2em .6em .3em;font-size: 10px;

    font-weight: bold;

    line-height: 1;

    color: #fff;

    text-align: center;

    white-space: nowrap;

    vertical-align: baseline;

    border-radius: .25em;}

	</style>

	

<!--Top Bar-->

<section>

  <div class="row">

    <div class="">

	

      <?php require('include/menu-navigation.php'); ?>

	  

	  <div class="col-lg-10 col-md-10 col-sm-10 col-xs-12" style="padding:0;background:#e7e7e7;">

        

		<div>

    <div id="menu" style="padding:14px;background:#3c8dbc;">

	   <a href="Log-Out.php" class="pull-right"> log out </a>

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

	</div> 

 	

    <div>

	

        <div class="col-md-12"> <br>

        <div class="panel panel-violet">

		<div class="panel-heading clearfix">

		<h2 class="pull-left">View Destination </h2>

		<form action="view_destination.php" id="search_form" method="GET">

		<p><input name="keyword" placeholder="search keyword" autocomplete="off" id="list_search" type="search" required class="search form-control pull-right" style="width: 250px;;"/></p>

		</form> 

		</div>

		<div class="panel-body">

			<div style="overflow: scroll;height: 600px;">

			<table class="table table-hover table-striped">

				<thead>

	<tr>

		<th>#</th>

		<th>Tour Id</th>

		<th>Tour Name</th>

		<th>Category</th>

		<th>Sub-Category</th>		

		<th>Hot/Not Hote</th>

		<th>Action</th>

	</tr>

	</thead>

	<tbody>

	<tr>

<?php

if(isset($_GET['keyword'])){

	$keyword = $_GET['keyword'];

    $q = "Select * from using_tour_tb where (tour_id LIKE '%$keyword%' || main_category LIKE '%$keyword%' || category LIKE '%$keyword%' || sub_category LIKE '%$keyword%') && main_category='Destination' order by date_time desc";  

	}else{

	$q = "Select * from using_tour_tb where main_category='Destination' order by date_time desc";

    }

$run = mysqli_query($con,$q);

while($row = mysqli_fetch_array($run)){

$id = $row['id'];

$tour_id = $row['tour_id'];

$main_category=$row['main_category'];

$category = $row['category'];

$sub_category = $row['sub_category'];

$hot = $row['hot'];

?>  

   

		<td><?php  echo $id; ?></td>

		<td><?php  echo $tour_id; ?></td>

		<td><a data-toggle="collapse" data-parent="#accordion" href="#<?php  echo $id; ?>" class="pull-left" style="margin: 0 5px 0 0;">

			 <center> <h6 class="label label-danger"> view</h6> </center> 

		</a>

		<?php  $sql = "Select * from tour_tb where id='$tour_id' order by id desc";

		$row = mysqli_fetch_assoc( mysqli_query($con, $sql) );

		echo $tour_name = $row['tour_name']; ?>

		</td>

		<td><?php  echo $category; ?>

		</td>

		<td><?php  echo $sub_category; ?> </td>

		<td> 

		  <center>

		      <?php 

			   if(($hot=='no') || ($hot=='')) 

				{

					?>

                    <form action="" method="post">

					  <input class="hide" type="text" name="hotid" value="<?php echo $id; ?>">

					  <input class="btn btn-danger" type="submit" name="not_hot" value="Not Hot">

					</form>

					

					<?php

					

				}

				else{

					

						?>



					<form action="" method="post">

					  <input class="hide"  type="text" name="hotid" value="<?php echo $id; ?>">

					  <input class="btn btn-success" type="submit" name="hot" value="hot">

					</form>

					

					<?php

				}





?>

			   

			   </center> 

			   

			   </td><td width="90">

		 <center> 

		    <a href="update_using_tour.php?id=<?php echo $id;?>"> <img src="images/edit.png" width="20"> </a>  

          | <a href="view_destination.php?del=<?php echo $id;?>" onclick="return confirm('Are you sure you want to remove this row?')"> <img src="images/delete.png" width="15"> </a>  

		  </center>

		</td>

	</tr>

    

	<tr>

	<td colspan="9" style="padding: 0;">

	<?php 	

	$sql = "Select * from tour_tb where id='$tour_id' order by id desc";

	$row = mysqli_fetch_assoc( mysqli_query($con, $sql) );

	$location = $row['location'];

	$country = $row['country'];

	$state = $row['state'];

	$cityid = $row['city'];

	$local_area = $row['local_area'];

	$tour_name = $row['tour_name'];

	$tour_duration = $row['tour_duration'];

	$destination_covered = $row['destination_covered'];

	$tour_price = $row['tour_price'];

	$banner_image = $row['banner_image'];

	$thumb_banner_image = $row['thumb_banner_image'];

	$gallery1 = $row['gallery1'];

	$thumb_gallery1 = $row['thumb_gallery1'];

	$gallery2 = $row['gallery2'];

	$thumb_gallery2 = $row['thumb_gallery2'];

	$gallery3 = $row['gallery3'];

	$thumb_gallery3 = $row['thumb_gallery3'];

	$gallery4 = $row['gallery4'];

	$thumb_gallery4 = $row['thumb_gallery4'];

	$discription = $row['discription'];

	$Tour_By_Duration = $row['Tour_By_Duration'];

	$Weekend_Tour = $row['Weekend_Tour'];

	$Luxury_Tour = $row['Luxury_Tour'];

	$m1 = $row['JUN'];

	$m2 = $row['FEB'];

	$m3 = $row['MAR'];

	$m4 = $row['APR'];

	$m5 = $row['MAY'];

	$m6 = $row['JUN'];

	$m7 = $row['JUL'];

	$m8 = $row['AUG'];

	$m9 = $row['SEP'];

	$m10 = $row['OCT'];

	$m11 = $row['NOV'];

	$m12 = $row['DECM'];

	

	$q2 = "Select * from mastercity_tb where cityid='$cityid' ";

	$run2 = mysqli_query($con,$q2);

	$row2 = mysqli_fetch_assoc($run2);

	$city = $row2['city'];

	?> 

<div class="panel-group" id="accordion">

		<div id="<?php  echo $id; ?>" class="panel-collapse collapse out">

		<div class="list-group" style="padding:10px;">

		<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12" style="padding:0;">

		<strong>Gallery Image :</strong>

		</div>

		<div class="col-lg-3 col-md-3 col-sm-3 col-xs-12">

		 <?php if(!$thumb_gallery1=='') { ?>

		 <img class="thumbnail_image" src="<?php echo $thumb_gallery1; ?>" width="100%" style="min-height: 150px;max-height: 150px;">

		 <?php 

         } else { } 

	     ?>

		</div>

		<div class="col-lg-3 col-md-3 col-sm-3 col-xs-12">

		 <?php if(!$thumb_gallery2=='') { ?>

		 <img class="thumbnail_image" src="<?php echo $thumb_gallery2; ?>" width="100%" style="min-height: 150px;max-height: 150px;">

		 <?php 

         } else { } 

	     ?>

		</div>

		<div class="col-lg-3 col-md-3 col-sm-3 col-xs-12">

		 <?php if(!$thumb_gallery3=='') { ?>

		 <img class="thumbnail_image" src="<?php echo $thumb_gallery3; ?>" width="100%" style="min-height: 150px;max-height: 150px;">

		 <?php 

         } else { } 

	     ?>

		</div>

		<div class="col-lg-3 col-md-3 col-sm-3 col-xs-12">

		 <?php if(!$thumb_gallery4=='') { ?>

		 <img class="thumbnail_image" src="<?php echo $thumb_gallery4; ?>" width="100%" style="min-height: 150px;max-height: 150px;">

		 <?php 

         } else { } 

	     ?>

		</div>

		<div class="col-lg-3 col-md-3 col-sm-3 col-xs-12">

		 <?php if($thumb_gallery1=='' & $thumb_gallery2=='' & $thumb_gallery3=='' & $thumb_gallery4=='') {

         echo "<font color='red'>No Gallery Image Found</font>"; }

		 ?>

		</div>

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

		<?php if($location==1){ ?>

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

		 <strong>Country :</strong> <?php  echo $country; ?>

		

		 <strong style="margin-left:50px;">State :</strong> <?php  echo $state; ?>

		

		 <strong style="margin-left:50px;">City :</strong> <?php  echo $city; ?>

		<?php } else if($location==2){ ?>

		<strong>Country :</strong> <?php  echo $country; ?>

		<?php } ?>

		

		<?php if(!$local_area=='') { ?>

		 <strong style="margin-left:50px;">Local Area :</strong> <?php  echo $local_area; ?><br><br>

		<?php } ?>

		

		<?php if(!$destination_covered=='') { ?>

		 <strong>Destination Covered :</strong> <?php  echo $destination_covered; ?><br><br>

		<?php } ?>

		

		<?php if(($Tour_By_Duration=="yes") || ($Weekend_Tour=="yes") || ($Luxury_Tour=="yes")) { ?>

		 <strong>Using for :</strong> 

		 <?php if($Tour_By_Duration=="yes"){ echo "Tour By Duration";}  

		 if($Weekend_Tour=="yes"){ echo ", Weekend Tour";}  

		 if($Luxury_Tour=="yes"){ echo ", Luxury Tour";} ?>

		 <br><br>

		<?php } ?>

		

		<?php if(($Tour_By_Duration=="yes") || ($Weekend_Tour=="yes") || ($Luxury_Tour=="yes")) { ?>

		 <strong>Visit by Month :</strong> 

		 <?php 

		 if($m1=="yes"){ echo "JAN";}           if($m2=="yes"){ echo ", FEB";}

		 if($m3=="yes"){ echo ", MAR";}           if($m4=="yes"){ echo ", APR";}

		 if($m5=="yes"){ echo ", MAY";}           if($m6=="yes"){ echo ", JUN";}

		 if($m7=="yes"){ echo ", JULY";}           if($m8=="yes"){ echo ", AUG";}

		 if($m9=="yes"){ echo ", SEP";}           if($m10=="yes"){ echo ", OCT";}  

		 if($m11=="yes"){ echo ", NOV";}           if($m12=="yes"){ echo ", DEC";}  

		 ?>

		 <br><br>

		<?php } ?>

		

		<?php if(!$discription=='') { ?>

		<strong>Discription :</strong> <?php  echo $discription; ?>

		<?php } ?>

		</div>

		</div>

		</div>

	</td>

    </tr>							

	<?php

}

?>									

		

			</tbody>

		</table>

	</div>

	</div>

		</div>

		

</div>

			

		<!--footer-->

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

  

  <div class="row panel-footer" style="background:#000; color:#FFF;">

    Copyright © 2016. A1 Tour & Travel <span class="pull-right"> Powered By <a href=""> Arc Solutions </a> </span>

  </div>

  

<!--/footer-->	

		

		</div>

		

      </div>

      

    </div>

	

      </div>

	  

    </div>

  </div>

</section>

<!--/Top Bar-->

   

<!-- keywrd seacching script -->

<script src="//code.jquery.com/jquery-1.10.2.min.js"></script>

<script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>

<link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">

<script type="text/javascript">

$(document).ready(function(){

	$(document).on('keyup','#list_search',function(){   

		var value = $(this).val();

		$.getJSON('../ajax_search_destination.php?keyword='+value, function (data) {

			var availableTags = data;

			$( "#list_search" ).autocomplete({

				source: availableTags,

				select: function(event, ui) {

				$(event.target).val(ui.item.value);

				$('#search_form').submit();

				return false;

			},

			 });

		});

		

	});

});

</script>

</body>

</html>







<?php

if(isset($_GET['del'])){

	$id = $_GET["del"];

	

    $d = "delete from using_tour_tb where id=".$id;

	

    $del = mysqli_query($con,$d);

	if($del){		

       header("location:view_destination.php?n=1");

	   exit();

	}



}



?>



<?php

 if(isset($_GET['n']))

 {

 if($_GET['n']==1)

 {

 ?>

 <script>alert("Data is deleted!");</script>

 <?php

 }

 }

 

 

 if(isset($_GET['u']))

 {

 if($_GET['u']==1)

 {

 ?>

 <script>alert("Data is updated!");</script>

 <?php

 }

 }



?>



<?php

 

ob_flush();



?>
File Content: view_destination.php

File Content: `view_destination.php`
