~NAXC~

File Content: `update_departure.php`

<?php

ob_start();

//session_start();

include('config/connection_config.php');

$id22=$_GET['edit'];



$q = "Select * from departure_tb where id='$id22' ";

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

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

$id = $row['id'];

		$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'];

		$tour_price = $row['tour_price'];

		$distance = $row['distance'];

		$getting = $row['getting'];

		$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'];

		$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'];

		

		$dbfix_date = explode(',', $row["fix_date"]);

		//echo $dbfix_date[0];

		

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

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

	$row2 = mysqli_fetch_assoc($run2);

	$city = $row2['city'];

}



if($location==1){ $location22 = "India";  } else 

{ $location22 = "India"; }

?>



<!DOCTYPE html>

<html>

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

	<head>

<title>Update Fix Departure Tour, Admin Panel</title>



<!--Bootstrap css-->

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

<!--/Bootstrap css-->

<!--our css-->

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

<!--/our 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-->



<!--Dropdown state and city script-->

<script type="text/javascript">

$(document).ready(function()

{

	$("#loding1").hide();

	$("#loding2").hide();

	$(".countries").change(function()

	{

		$("#loding1").show();

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

		var dataString = 'id='+ id;

		$(".states").find('option').remove();

		$.ajax

		({

			type: "POST",

			url: "get_state.php",

			data: dataString,

			cache: false,

			success: function(html)

			{

				$("#loding1").hide();

				$(".states").html(html);

			} 

		});

	});

		

});

</script>



<script type="text/javascript">

$(document).ready(function()

{

	$("#loding1").hide();

	$("#loding2").hide();

	$(".states").change(function()

	{

		$("#loding1").show();

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

		var dataString = 'id='+ id;

		$(".city").find('option').remove();

		$.ajax

		({

			type: "POST",

			url: "get_city.php",

			data: dataString,

			cache: false,

			success: function(html)

			{

				$("#loding1").hide();

				$(".city").html(html);

			} 

		});

	});

		

});

</script>



<!-----At Select location----->	

<script>

function showlocation(str)

{

	window.location="update_tour.php?edit=<?php echo $id22;?>&location=" + str;	

}

</script>	

<!-----/At Select location----->



<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>

<script type="text/javascript">

  $(document).ready(function() {



    $('#title').keyup(function(){

    $('#link').val(this.value);

});



  });



</script>

</head>

<body>



<!--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:17px;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-default">

			<div class="list-group"> <div class="list-group-item active clearfix" href=""> 

            <h2>Update Fix Departure Tour <a class="btn btn-default pull-right" href="view_departure.php"> View Fix Departure </a> </h2> 

			</div>

			</div>

              <div class="panel-body">

				 <div class="grid">

		            

			<form enctype="multipart/form-data" method="post" action="update_departure_get.php?id=<?php echo $id;?>">

			

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

            

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

            http://a1toursandtravels.com/<input type="text" name="link" id="link" onkeyup="keypress(this.value);" style="font-size: 14px;height: 20px;border: none;" > <br>

			 <br>

			 

			 <label>Select Location : </label>

			<select name="location" onchange="showlocation(this.value)" class="form-control" required>

			 <?php if($_GET['location']==1) { ?>

			 <option value="1">India</option>

			 <option value="2">International</option>

			 <?php } else if($_GET['location']==2)  { ?>

			 <option value="2">International</option>

			 <option value="1">India</option>

			 <?php } else { ?>

			   <option value="<?php echo $location22;?>"><?php echo $location22;?></option>

			   <option value="1">India</option>

			 <option value="2">International</option>

			 <?php } ?>

		    </select>

		    </div>

			

			<?php if($_GET['location']==1){ ?>

			<div class="col-md-3"> 

            <label>Country : </label>

			<select name="country" class="countries form-control" id="countryId" required>

			<option value="<?php echo $country; ?>"><?php echo $country; ?></option>

			<option value="India">India</option>

			</select>

            </div>

			<div class="col-md-3"> 

            <label>State : </label>

			<select name="state" class="states form-control" required>

			<option selected="selected"><?php echo $state; ?></option>

			</select>

			</div>

			<div class="col-md-3">

			<label>City : </label>

			<p>

				<select name="city" class="city form-control" required>

				<option selected="selected" value="<?php echo $cityid; ?>"><?php echo $city; ?></option>

				</select>

			</p> 

			</div>

			

			<div class="col-md-3"> 

            <label>Local Area : </label>

			<p>

				<input type="text" name="local_area" class="form-control" value="<?php echo $local_area;?>">

            </p>

			</div>

			<?php } else 

				if($_GET['location']==2){ ?>

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

				<label>Country : </label>

				<select name="country" class="countries form-control" id="countryId" required>

				<option value=""><?php echo $country;?></option>

				</select>

				</div>

			<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>

			<script src="http://iamrohit.in/lab/js/location.js"></script>

            

			<?php } else { ?>

			<div class="col-md-3"> 

            <label>Country : </label>

			<select name="country" class="countries form-control" id="countryId" required>

			<option value=""><?php echo $country;?></option>

			</select>

            </div>

			<div class="col-md-3"> 

            <label>State : </label>

			<select name="state" class="states form-control" id="stateId" required>

			<option value=""><?php echo $state;?></option>

			</select>

			</div>

			<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>

			<script src="http://iamrohit.in/lab/js/location.js"></script>

            

			<div class="col-md-3">

			<label>City : </label>

			<p>

				<select name="city" class="city form-control" required>

				<option selected="selected"> <?php echo $city;?></option>

				</select>

			</p> 

			</div>

			<div class="col-md-3"> 

            <label>Local Area : </label>

			<p>

				<input type="text" name="local_area" class="form-control" value="<?php echo $local_area;?>">

            </p>

			</div>

			<?php } ?>

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

            <label>Tour Name : </label>

				<input type="text" name="tour_name" class="form-control" value="<?php echo $tour_name;?>" required>

			</div>

			<div class="col-md-6"> 

            <label>Tour Duration : </label>

				<select name="tour_duration" class="form-control" required>

				<option value="<?php echo $tour_duration;?>"><?php echo $tour_duration;?></option>

				<option value="1">1 NIGHT</option>

				<option value="2">2 NIGHT</option>

				<option value="3">3 NIGHT</option>

				<option value="4">4 NIGHT</option>

				<option value="5">5 NIGHT</option>

				<option value="6">6 NIGHT</option>

				<option value="7">7 NIGHT</option>

				<option value="8">8 NIGHT</option>

				<option value="9">9 NIGHT</option>

				<option value="10">10 NIGHT</option>

				<option value="11">11 NIGHT</option>

				<option value="12">12 NIGHT</option>

				<option value="13">13 NIGHT</option>

				<option value="14">14 NIGHT</option>

				<option value="15">15 NIGHT</option>

				</select>

			</div>

			<div class="col-md-6"> 

            <label>Tour Price : </label>

				<input type="text" name="tour_price"class="form-control" value="<?php echo $tour_price;?>" required>

            </div>

			<div class="col-md-6"> 

            <label>Total Distance : </label>

				<input type="text" name="distance" class="form-control" value="<?php echo $distance;?>" required>

            </div>

			<div class="col-md-6"> 

            <label>Getting From/To : </label>

				<input type="text" name="getting"class="form-control" value="<?php echo $getting;?>" required>

            </div>

		

			<div class="col-md-12"><label>Fix Date : </label></DIV> 

            <div class="col-md-3"> 

            <input type="text" name="fix_date[]" value="<?php echo $dbfix_date[0]; ?>" class="form-control">

			</div>

			<div class="col-md-3"> 

            <input type="text" name="fix_date[]" value="<?php echo $dbfix_date[1]; ?>" class="form-control">

			</div>

			<div class="col-md-3"> 

            <input type="text" name="fix_date[]" value="<?php echo $dbfix_date[2]; ?>" class="form-control">

			</div>

			<div class="col-md-3"> 

            <input type="text" name="fix_date[]" value="<?php echo $dbfix_date[3]; ?>" class="form-control">

			</div>

			

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

            <label>Visit by Month : </label>

				<p style="font-size: 17px;">

				<?php if($m1=='') { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;">JAN&nbsp; 

			    <?php } else { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;" checked>JAN&nbsp; 

			    <?php } ?>

				<?php if($m2=='') { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;">FEB&nbsp; 

			    <?php } else { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;" checked>FEB&nbsp; 

			    <?php } ?>

				<?php if($m3=='') { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;">MAR&nbsp; 

			    <?php } else { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;" checked>MAR&nbsp; 

			    <?php } ?>

				<?php if($m4=='') { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;">APR&nbsp; 

			    <?php } else { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;" checked>APR&nbsp; 

			    <?php } ?>

				<?php if($m5=='') { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;">MAY&nbsp; 

			    <?php } else { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;" checked>MAY&nbsp; 

			    <?php } ?>

				<?php if($m6=='') { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;">JUN&nbsp; 

			    <?php } else { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;" checked>JUN&nbsp; 

			    <?php } ?>

				<?php if($m7=='') { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;">JUL&nbsp; 

			    <?php } else { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;" checked>JUL&nbsp; 

			    <?php } ?>

				<?php if($m8=='') { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;">AUG&nbsp; 

			    <?php } else { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;" checked>AUG&nbsp; 

			    <?php } ?>

				<?php if($m9=='') { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;">SEP&nbsp; 

			    <?php } else { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;" checked>SEP&nbsp; 

			    <?php } ?>

				<?php if($m10=='') { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;">OCT&nbsp; 

			    <?php } else { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;" checked>OCT&nbsp; 

			    <?php } ?>

				<?php if($m11=='') { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;">NOV&nbsp; 

			    <?php } else { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;" checked>NOV&nbsp; 

			    <?php } ?>

				<?php if($m12=='') { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;">DEC&nbsp; 

			    <?php } else { ?>

				<input type="checkbox" name="month[]" value="yes" style="margin: 0 0 0 0;" checked>DEC&nbsp; 

			    <?php } ?>

				

			</p></div>

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

            <label>Upload Banner : </label><br>

				<input type="file" name="banner_image" class="form-control">

			</div>

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

            <label>Discription : </label>

			<div style="height:500px;">

			  <textarea id="froala-editor" name="discription" value="<?php echo $discription;?>"><?php echo $discription;?></textarea>

			</div>

			  <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.4.0/css/font-awesome.min.css" rel="stylesheet" type="text/css" /><link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.25.0/codemirror.min.css"><link href="https://cdnjs.cloudflare.com/ajax/libs/froala-editor/2.6.0/css/froala_editor.pkgd.min.css" rel="stylesheet" type="text/css" /><link href="https://cdnjs.cloudflare.com/ajax/libs/froala-editor/2.6.0/css/froala_style.min.css" rel="stylesheet" type="text/css" /></head>

			  <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script><script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.25.0/codemirror.min.js"></script><script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.25.0/mode/xml/xml.min.js"></script><script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/froala-editor/2.6.0//js/froala_editor.pkgd.min.js"></script>

			  <script>

				$(function() {

				$("textarea#froala-editor").froalaEditor();

				});

			  </script>

			</div>

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

				<p>

								<input class="btn btn-danger" type="submit" name='submit_image' value="Submit"/>

				</p>

			</div> 

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

		</form> 

		

		<br>

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

		   

		         

				</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-->



</body>

</html>

<?php



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

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

 {

 ?>

 <script>

 alert("Tour Detail is successfully Posted!");

 </script>

 <?php

 }

 }

 ?>

 

<?php



ob_flush();



?>
File Content: update_departure.php

File Content: `update_departure.php`
