impetrator

Back Back Up Advanced Editor

<?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>
    
    
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

<title>Admin | Tourism Fraternity Network &copy;</title>

<meta property="og:title" content="Admin | Tourism Fraternity Network &copy;">

<meta property="og:description" content="A premier online listing for businesses and travelers">

<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">
        
        <link rel="stylesheet" href="../css/style.css">
        <link rel="stylesheet" href="../css/responsive.css">

<link rel="stylesheet" type="text/css" href="../css/animations/style.css">

<link href="../css/fontawesome/css/all.css" rel="stylesheet">

/*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 class="header_area">
            <div class="container">
                <nav class="navbar navbar-expand-lg navbar-light">
                    
                    <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>
                    
                    <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>
         
 
        
        
        <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'>&times;</button>
            ".$_SESSION['error']."
          </div>";
          unset($_SESSION['error']);
        }
        if(isset($_SESSION['success'])){
          echo "<div class='alert alert-success text-center'>
            <button class='close'>&times;</button>
            ".$_SESSION['success']."
          </div>";
          unset($_SESSION['success']);
        }
      ?>
</div>

<div><a href="#addnew" data-toggle="modal" class="button_hover theme_btn_two text-white"><i class="fa fa-plus"></i>&nbsp; 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>

<?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>';

}

?>

</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>&nbsp; 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>&nbsp; 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]);
}