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: 0;
    left: 0;
  font-size: 100px;
  width: 100%;
  height: 90%;
  opacity: 0;
  z-index: 9;
}

.upload-btn-wrapper .btn {
    color: #fff;
    font-size: 12px;
    width: 100%;
    height: 65px;
    background: #77df40;
    border-radius: 6px;
}

.upload-btn-wrapper .btn i.fa-image {
    display: block;
    color: #fff;
    font-size: 12px;
}

.output_image1 {
    position: absolute;
    top: 0;
    left: 0;
    border-radius: 6px;
    border: none;
}

img.output_image1{
  width: 100%;
    height: 90%;
  object-fit: cover;
}

/*Custom File Input*/
.file {
  opacity: 0;
  width: 0.1px;
  height: 0.1px;
  position: absolute;
}

.file-input label {
  display: block;
  position: relative;
  width: 100%;
  height: 50px;
  border-radius: 25px;
  background: linear-gradient(40deg,#174899,#164798,#92A9CF);
   background-size: 400% 400%;
    -webkit-animation: gradient 8s ease infinite;
            animation: gradient 8s ease infinite;
  box-shadow: 0 4px 7px rgba(0, 0, 0, 0.4);
  display: flex;
  align-items: center;
  justify-content: center;
  color: #fff;
  font-weight: bold;
  cursor: pointer;
  outline: none;
  transition: transform .2s ease-out;
}

.file-input p {
  position: absolute;
  top: -20px;
  left: 20px;
  font-size: 12px;
  color: #555;
  font-weight: normal;
}

.file-input input:hover + label,
.file-input input:focus + label {
  transform: scale(1.02);
}

</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"><a class="nav-link" href="../../listings" >Listings</a></li> 
                            <li class="nav-item active"><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-video"></i>&nbsp; Add Video Blog</a></div>

<div class="section_title text-center">
                    <h2 class="title_color">VIDEO BLOGS</h2>
                    <p class="text-uppercase" style="font-size: 18px;">

<?php

$sql = "SELECT COUNT(*) FROM blogs WHERE blog_type='Video' AND deleted=''";

//use for MySQLi-OOP
    $query = $conn->query($sql);
    while($row = $query->fetch_assoc()){
        if ($row['COUNT(*)']==0) {
            echo "No video blogs found";
        } elseif ($row['COUNT(*)']==1) {
            echo "".number_format($row['COUNT(*)'])." Video Blog";
        } else {
            echo "".number_format($row['COUNT(*)'])." Video Blogs";
        }
    }

?>
                    </p>
                    <hr>
                </div>
                <div class="row mb_30">

<?php

$sql = "SELECT * FROM blogs WHERE blog_type='Video' AND 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 '<video class="img-fluid one" controls><source src="videos/'.$row["vid1"].'"></video>';
                            echo '</div>';
                            echo '<div class="details" align="center">';
                                echo '<a href="#!"><h4 class="sec_h4">'.$row["title"].'</h4></a>';
                                echo '<p>'.$row["paragraph1"].'</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>';
                                echo '<hr>';
                            echo '</div>';  
                        echo '</div>';
                    echo '</div>';

//Edit Image Upload

echo "<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; 
}

</script>";

include('modals/edit.php');

}
?>

</div>
            </div>
        </section>

<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> &copy; <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>

</footer>

<?php include('modals/add.php') ?>
        
        
        
        
        <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/upload_img_script.js"></script>

//hide alert
    $(document).on('click', '.close', function(){
      $('.alert').hide();
    })
});
</script>

reader.readAsDataURL(input.files[0]);
        }
    }
    function displayVID2(input,_this) {
        if (input.files && input.files[0]) {
            var reader = new FileReader();
            reader.onload = function (e) {
                $('#vid-field2').html("<source src='"+e.target.result+"'>");
                console.log(e.target.result)
            }

reader.readAsDataURL(input.files[0]);
        }
    }
    function displayImg(input,_this) {
        if (input.files && input.files[0]) {
            var reader = new FileReader();
            reader.onload = function (e) {
                $('#vid-field1').attr('poster', e.target.result);
            }

reader.readAsDataURL(input.files[0]);
        }
    }
</script>

</body>
</html>