File "index.php"
Full Path: /home/custbahd/tourismfraternity.com/admin/listings/index.php
File size: 21.93 KB
MIME-type: text/x-php
Charset: utf-8
<?php
session_start();
include_once('../db/saucerer.php');
// Define variables and initialize with empty values
$id = $name = $token = $access = "";
$id_err = $name_err = $token_err = $access = "";
// Check if the user is logged in, if not then redirect him to login page
if(!isset($_SESSION["loggedin"]) || $_SESSION["loggedin"] != true){
$loggedin = "";
header("location: ../secure");
exit;
} elseif(!isset($_SESSION["loggedin"]) || $_SESSION["loggedin"] == true){
$loggedin = $_SESSION['loggedin'];
$id = $_SESSION['id'];
$token = $_SESSION['token'];
// of college_data table
$sql = "SELECT * FROM secure WHERE token='$token'";
$result = $conn->query($sql);
// Display data on web page
while($row = mysqli_fetch_array($result)) {
$id = $row['id'];
$name = $row['name'];
$token = $row['token'];
}
}
// Generating a random number
date_default_timezone_set('Africa/Kampala');
$today = date("His-dmY",time());
$code1 = rand(1,9);
$code2 = rand(1,9);
$code3 = $code1 * $code2;
$tokens = "$code3-$today";
?>
<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<title>Admin | Tourism Fraternity Network ©</title>
<meta name="description" content="A premier online listing for businesses and travelers">
<link rel="shortcut icon" type="image/x-icon" href="../../assets/images/favicon.png" />
<!-- Social Share Data -->
<meta content="text/html; charset=utf-8" name="Content-Type">
<meta property="og:type" content="article">
<meta property="og:image" content="https://tourismfraternity.com/assets/images/card/1.png">
<!-- Less than 65 characters -->
<meta property="og:title" content="Admin | Tourism Fraternity Network ©">
<meta property="og:url" content="https://camonitor.online/Tourism/admin">
<!-- Less than 300 characters -->
<meta property="og:description" content="A premier online listing for businesses and travelers">
<meta property="og:site_name" content="Admin | Tourism Fraternity Network ©">
<!-- Twitter Cards -->
<meta name="twitter:card" content="summary_large_image">
<meta name="twitter:url" content="https://camonitor.online/Tourism/admin">
<meta name="twitter:title" content="Admin | Tourism Fraternity Network ©">
<meta name="twitter:description" content="A premier online listing for businesses and travelers">
<meta name="twitter:image" content="https://tourismfraternity.com/assets/images/card/1.png">
<meta name="twitter:site" content="@tourism_fraternity_network">
<meta name="twitter:creator" content="@iann_thecreator">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="../css/bootstrap.css">
<link rel="stylesheet" href="../vendors/linericon/style.css">
<link rel="stylesheet" href="../css/font-awesome.min.css">
<link rel="stylesheet" href="../vendors/owl-carousel/owl.carousel.min.css">
<link rel="stylesheet" href="../vendors/bootstrap-datepicker/bootstrap-datetimepicker.min.css">
<link rel="stylesheet" href="../vendors/nice-select/css/nice-select.css">
<link rel="stylesheet" href="../vendors/owl-carousel/owl.carousel.min.css">
<!-- main css -->
<link rel="stylesheet" href="../css/style.css">
<link rel="stylesheet" href="../css/responsive.css">
<!--Animations-->
<link rel="stylesheet" type="text/css" href="../css/animations/style.css">
<!--Fontawesome 6-->
<link href="../css/fontawesome/css/all.css" rel="stylesheet">
<link href="../css/datatable/dataTable.bootstrap.min.css" rel="stylesheet">
<style type="text/css">
/*Upload Wrapper*/
.upload-wrapper {
width: 100%;
border-radius: 10px;
}
.upload-btn-wrapper input[type=file] {
position: absolute;
top: 30px;
left: 0;
font-size: 100px;
width: 100%;
height: 85%;
opacity: 0;
z-index: 9;
}
.upload-btn-wrapper .btn {
color: #fff;
font-size: 12px;
text-transform: uppercase;
width: 100%;
height: 200px;
background: #77df40;
border-radius: 6px;
}
.upload-btn-wrapper .btn.one {
background: none;
}
.upload-btn-wrapper .btn img {
width: 100%;
height: 100%;
object-fit: cover;
border-radius: 10px;
}
.upload-btn-wrapper .btn i.fa-image {
display: block;
color: #fff;
font-size: 20px;
margin-top: 70px;
}
.output_image1 {
position: absolute;
top: 30px;
left: 0;
border-radius: 10px;
border: none;
}
img.output_image1{
width: 100%;
height: 85%;
object-fit: cover;
}
.output_image_1 {
position: absolute;
top: 30px;
left: 0;
border-radius: 10px;
border: none;
}
img.output_image_1{
width: 100%;
height: 85%;
object-fit: cover;
}
/*Other Images*/
.others .upload-btn-wrapper input[type=file] {
position: absolute;
top: 0;
left: 0;
font-size: 100px;
width: 100%;
height: 90%;
opacity: 0;
z-index: 9;
}
.others .upload-btn-wrapper .btn {
color: #fff;
font-size: 12px;
width: 100%;
height: 65px;
text-transform: none;
background: #77df40;
border-radius: 6px;
}
.others .upload-btn-wrapper .btn i.fa-image {
display: block;
color: #fff;
font-size: 12px;
margin-top: 6px;
}
.others .output_image1 {
position: absolute;
top: 0;
left: 0;
border-radius: 6px;
border: none;
}
.others img.output_image1{
width: 100%;
height: 90%;
object-fit: cover;
}
.popup{
width: 420px;
padding: 30px 40px;
position: fixed;
transform: translate(-50%,-50%);
left: 50%;
top: 50%;
border-radius: 8px;
font-family: "Poppins",sans-serif;
display: none;
text-align: center;
z-index: 999;
background-image: url('../../assets/images/stock/img/elephants.png');
background-position: center;
background-size: cover;
background-attachment: fixed;
}
.popup button{
display: block;
margin: 0 0 20px auto;
background-color: transparent;
font-size: 30px;
color: #ffffff;
background: #F7970F;
border-radius: 100%;
width: 40px;
height: 40px;
border: none;
outline: none;
cursor: pointer;
}
.popup h2{
font-size: 20px;
margin-top: -20px;
}
.popup h3{
font-size: 18px;
margin-top: 10px;
}
.popup h3 span{
font-weight: normal;
font-size: 14px;
}
.popup p{
font-size: 14px;
text-align: justify;
margin: 20px 0;
line-height: 25px;
}
.popup a{
display: block;
position: relative;
margin: 5px;
text-align: center;
background-color: #53a92c;
color: #ffffff;
text-decoration: none;
padding: 8px 0;
transition: 0.5s;
}
.popup a:hover{
background-color: #F7970F;
}
.popup a.popup-link{
display: inline-block;
padding: 8px 30px;
}
</style>
</head>
<body>
<!--================Header Area =================-->
<header class="header_area">
<div class="container">
<nav class="navbar navbar-expand-lg navbar-light">
<!-- Brand and toggle get grouped for better mobile display -->
<a class="navbar-brand logo_h" href="../../"><img src="../../assets/images/logo/2.png" alt="Tourism Fraternity Network Logo"></a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse offset" id="navbarSupportedContent">
<ul class="nav navbar-nav menu_nav ml-auto">
<li class="nav-item"><a class="nav-link" href="../">Admin</a></li>
<li class="nav-item active"><a class="nav-link" href="../listings" >Listings</a></li>
<li class="nav-item"><a class="nav-link" href="../blogs">Blogs</a></li>
<li class="nav-item"><a class="nav-link" href="../events">Events</a></li>
<li class="nav-item"><a class="nav-link" href="../inquiries">Inquiries</a></li>
</ul>
</div>
</nav>
</div>
</header>
<!--================Header Area =================-->
<!--================ Blog Area Start =================-->
<section class="latest_blog_area one section_gap">
<div class="session_handler">
<?php
if(isset($_SESSION['error'])){
echo "<div class='alert alert-danger text-center'>
<button class='close'>×</button>
".$_SESSION['error']."
</div>";
unset($_SESSION['error']);
}
if(isset($_SESSION['success'])){
echo "<div class='alert alert-success text-center'>
<button class='close'>×</button>
".$_SESSION['success']."
</div>";
unset($_SESSION['success']);
}
?>
</div>
<div class="container">
<!--================ Add New =================-->
<div><a href="#addnew" data-toggle="modal" class="button_hover theme_btn_two text-white"><i class="fa fa-plus"></i> Add New Place</a></div>
<div class="section_title text-center">
<h2 class="title_color">LISTINGS</h2>
<p class="text-uppercase" style="font-size: 18px;">
<?php
$sql = "SELECT COUNT(*) FROM listings WHERE deleted=''";
//use for MySQLi-OOP
$query = $conn->query($sql);
while($row = $query->fetch_assoc()){
if ($row['COUNT(*)']==0) {
echo "No places found";
} elseif ($row['COUNT(*)']==1) {
echo "".number_format($row['COUNT(*)'])." Place";
} else {
echo "".number_format($row['COUNT(*)'])." Places";
}
}
?>
</p>
<hr>
<!-- The Creator's Cave Start -->
<?php
if (!empty($_GET['creator'])) {
echo '<form action="url/index.php" method="POST">';
$sql = "SELECT * FROM listings WHERE deleted=''";
//use for MySQLi-OOP
$query = $conn->query($sql);
while($row = $query->fetch_assoc()){
echo "<input type='hidden' name='id[]' value='".$row['id']."'>";
}
echo '<button type="submit" value="submit" name="submit" class="btn theme_btn button_hover">Refresh</button>';
echo '</form>';
}
?>
<!-- The Creator's Cave End -->
</div>
<div class="row mb_30">
<?php
$sql = "SELECT * FROM listings WHERE deleted='' ORDER BY id DESC";
//use for MySQLi-OOP
$query = $conn->query($sql);
while($row = $query->fetch_assoc()){
echo '<div class="col-lg-4 col-md-6">';
echo '<span id="nav_'.$row["id"].'"></span>';
echo '<div class="single-recent-blog-post">';
echo '<div class="thumb">';
echo '<img class="img-fluid one" src="images/'.$row["image"].'" alt="'.$row["title"].' img">';
echo '</div>';
echo '<div class="details" align="center">';
echo '<p>'.$row["sub"].'</p>';
echo '<a href="#!"><h4 class="sec_h4">'.$row["title"].'</h4></a>';
if (!empty($_GET['creator'])) { echo '<p>'.$row["url"].'</p>'; }
echo '<p>'.$row["services"].'</p>';
echo '<a href="#edit_'.$row["id"].'" data-toggle="modal" class="button_hover theme_btn_two text-white mr-1"><i class="fa fa-edit"></i> Edit</a>';
echo '<a href="#delete_'.$row["id"].'" data-toggle="modal" class="button_hover theme_btn_two text-white ml-1"><i class="fa fa-trash"></i> Delete</a>';
if (!empty($_GET['creator'])) {
if (empty($row['url'])) {
echo '<a href="url/1/?id='.$row["id"].'&title='.$row["title"].'" class="button_hover theme_btn_two text-white ml-1"><i class="fa fa-refresh"></i></a>';
}
}
echo '<hr>';
echo '</div>';
echo '</div>';
echo '</div>';
//Edit Image Upload
echo "<script>
function preview_image_".$row['id']."(event)
{
var reader = new FileReader();
reader.onload = function()
{
var output = document.getElementById('output_image_".$row['id']."');
output.src = reader.result;
}
reader.readAsDataURL(event.target.files[0]);
}
function myFunction() {
document.getElementById('myFile".$row['id']."').required = false;
}
</script>
<script>
function preview_image_one_".$row['id']."(event)
{
var reader = new FileReader();
reader.onload = function()
{
var output = document.getElementById('output_image_one_".$row['id']."');
output.src = reader.result;
}
reader.readAsDataURL(event.target.files[0]);
}
function myFunction() {
document.getElementById('myFile".$row['id']."').required = false;
}
function preview_image_two_".$row['id']."(event)
{
var reader = new FileReader();
reader.onload = function()
{
var output = document.getElementById('output_image_two_".$row['id']."');
output.src = reader.result;
}
reader.readAsDataURL(event.target.files[0]);
}
function myFunction() {
document.getElementById('myFile".$row['id']."').required = false;
}
function preview_image_three_".$row['id']."(event)
{
var reader = new FileReader();
reader.onload = function()
{
var output = document.getElementById('output_image_three_".$row['id']."');
output.src = reader.result;
}
reader.readAsDataURL(event.target.files[0]);
}
function myFunction() {
document.getElementById('myFile".$row['id']."').required = false;
}
function preview_image_four_".$row['id']."(event)
{
var reader = new FileReader();
reader.onload = function()
{
var output = document.getElementById('output_image_four_".$row['id']."');
output.src = reader.result;
}
reader.readAsDataURL(event.target.files[0]);
}
function myFunction() {
document.getElementById('myFile".$row['id']."').required = false;
}
function preview_image_five_".$row['id']."(event)
{
var reader = new FileReader();
reader.onload = function()
{
var output = document.getElementById('output_image_five_".$row['id']."');
output.src = reader.result;
}
reader.readAsDataURL(event.target.files[0]);
}
function myFunction() {
document.getElementById('myFile".$row['id']."').required = false;
}
function preview_image_six_".$row['id']."(event)
{
var reader = new FileReader();
reader.onload = function()
{
var output = document.getElementById('output_image_six_".$row['id']."');
output.src = reader.result;
}
reader.readAsDataURL(event.target.files[0]);
}
function myFunction() {
document.getElementById('myFile".$row['id']."').required = false;
}
</script>";
include('modals/edit.php');
}
?>
</div>
</div>
</section>
<!--================ Blog Area End =================-->
<!--================ start footer Area =================-->
<footer class="footer-area section_gap">
<div class="container">
<div class="row footer-bottom d-flex justify-content-between align-items-center">
<div class="col-lg-3 col-sm-12 footer-social">
<a href="https://facebook.com/"><i class="fab fa-facebook"></i></a>
<a href="https://x.com/"><i class="fab fa-x-twitter"></i></a>
<a href="https://instagram.com/"><i class="fab fa-instagram"></i></a>
<a href="https://wa.me/256785196012"><i class="fab fa-whatsapp"></i></a>
</div>
<p class="col-lg-6 col-sm-12 footer-text m-0 text-center">
<a href="#">Tourism Fraternity Network</a> © <script>document.write(new Date().getFullYear());</script>, All Rights Reserved<span class="flash">.</span></p>
<p class="col-lg-3 col-sm-12 footer-text m-0 text-center" style="font-size: 12px;">Powered by <a href="https://camonitor.online" target="_blank" style="color: #82848f;">Custom Assist Inc<span class="flash">.</span></a></p>
</div>
</div>
</footer>
<!--================ End footer Area =================-->
<!--Auto Pop Up Start-->
<?php
$sql = "SELECT * FROM listings WHERE cat='Hospitality Facility' AND sub_type='' AND deleted='' OR cat='Tourist Attraction' AND sub_type='' AND deleted='' OR cat='Important Stakeholder' AND sub_type='' AND deleted='' OR cat='Tour Guide' AND gender='' AND deleted='' ORDER BY id DESC";
//use for MySQLi-OOP
$query = $conn->query($sql);
while($row = $query->fetch_assoc()){
echo '<div class="popup background-overlay-white">';
echo '<button id="close">×</button>';
echo '<h2>Assign Listing</h2>';
echo '<p>Assign your listings below to their designated criterias.</p>';
echo '<h3>'.$row["title"].' - <span>'.$row["cat"].'</span></h3>';
if ($row["cat"]=='Hospitality Facility') {
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Hotel&url='.$row["url"].'" class="popup-link">Hotel</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Motel&url='.$row["url"].'" class="popup-link">Motel</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Lodge&url='.$row["url"].'" class="popup-link">Lodge</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Restaurant&url='.$row["url"].'" class="popup-link">Restaurant</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Night Club&url='.$row["url"].'" class="popup-link">Night Club</a>';
echo "<hr>";
}
if ($row["cat"]=='Tourist Attraction') {
echo '<a href="add/1/?id='.$row["id"].'&sub_type=National Park&url='.$row["url"].'" class="popup-link">National Parks</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Game Reserve&url='.$row["url"].'" class="popup-link">Game Reserves</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Eco&url='.$row["url"].'" class="popup-link">Eco</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Cultural&url='.$row["url"].'" class="popup-link">Cultural</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Religious&url='.$row["url"].'" class="popup-link">Religious</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Birding&url='.$row["url"].'" class="popup-link">Birding</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Waters&url='.$row["url"].'" class="popup-link">Waters</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Mountains&url='.$row["url"].'" class="popup-link">Mountains</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Antiquity&url='.$row["url"].'" class="popup-link">Antiquity</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Other&url='.$row["url"].'" class="popup-link">Others</a>';
echo "<hr>";
}
if ($row["cat"]=='Important Stakeholder') {
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Ministry&url='.$row["url"].'" class="popup-link">Ministry</a>';
echo '<a href="add/1/?id='.$row["id"].'&sub_type=Regulator&url='.$row["url"].'" class="popup-link">Regulator</a>';
echo "<hr>";
}
if ($row["cat"]=='Tour Guide') {
echo '<a href="add/2/?id='.$row["id"].'&gender=Male&url='.$row["url"].'" class="popup-link">Male</a>';
echo '<a href="add/2/?id='.$row["id"].'&gender=Female&url='.$row["url"].'" class="popup-link">Female</a>';
echo '<a href="add/2/?id='.$row["id"].'&gender=None&url='.$row["url"].'" class="popup-link">None</a>';
echo "<hr>";
}
echo '</div>';
}
?>
<!--Auto Pop Up End-->
<?php include('modals/add.php') ?>
<!-- Optional JavaScript -->
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script src="../js/jquery-3.2.1.min.js"></script>
<script src="../js/popper.js"></script>
<script src="../js/bootstrap.min.js"></script>
<script src="../vendors/owl-carousel/owl.carousel.min.js"></script>
<script src="../js/jquery.ajaxchimp.min.js"></script>
<script src="../js/mail-script.js"></script>
<script src="../vendors/bootstrap-datepicker/bootstrap-datetimepicker.min.js"></script>
<script src="../vendors/nice-select/js/jquery.nice-select.js"></script>
<script src="../js/mail-script.js"></script>
<script src="../js/stellar.js"></script>
<script src="../vendors/lightbox/simpleLightbox.min.js"></script>
<script src="../js/custom.js"></script>
<script src="../js/video-on-scroll.js"></script>
<script src="../js/datatable/jquery.dataTables.min.js"></script>
<script src="../js/datatable/dataTable.bootstrap.min.js"></script>
<!-- Upload Image JS -->
<script src="../js/upload_img_script.js"></script>
<script>
$(document).ready(function(){
//inialize datatable
$('#myTable').DataTable();
//hide alert
$(document).on('click', '.close', function(){
$('.alert').hide();
})
});
</script>
<!--Auto Pop Up-->
<script type="text/javascript">
window.addEventListener("load", function(){
setTimeout(
function open(event){
document.querySelector(".popup").style.display = "block";
},
500
)
});
document.querySelector("#close").addEventListener("click", function(){
document.querySelector(".popup").style.display = "none";
});
</script>
</body>
</html>