File "index.php"
Full Path: /home/custbahd/tourismfraternity.com/admin/blogs/index.php
File size: 14.12 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: 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;
}
</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"><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>
<!--================Header Area =================-->
<!--================ Blog Area Start =================-->
<section class="latest_blog_area one section_gap">
<!--================ Session Handler Start =================-->
<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>
<!--================ Session Handler End =================-->
<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 Blog</a></div>
<div><a href="video-blogs" class="button_hover theme_btn_two text-white"><i class="fa fa-video"></i> Video Blogs</a></div>
<div class="section_title text-center">
<h2 class="title_color">BLOGS</h2>
<p class="text-uppercase" style="font-size: 18px;">
<?php
$sql = "SELECT COUNT(*) FROM blogs WHERE blog_type='Image' AND deleted=''";
//use for MySQLi-OOP
$query = $conn->query($sql);
while($row = $query->fetch_assoc()){
if ($row['COUNT(*)']==0) {
echo "No blogs";
} elseif ($row['COUNT(*)']==1) {
echo "".number_format($row['COUNT(*)'])." Blog";
} else {
echo "".number_format($row['COUNT(*)'])." Blogs";
}
}
?>
<?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";
} elseif ($row['COUNT(*)']==1) {
echo " | <a href='video-blogs' class='text-underline'>".number_format($row['COUNT(*)'])." Video Blog</a>";
} else {
echo " | <a href='video-blogs' class='text-underline'>".number_format($row['COUNT(*)'])." Video Blogs</a>";
}
}
?>
</p>
<hr>
</div>
<div class="row mb_30">
<?php
$sql = "SELECT * FROM blogs WHERE blog_type='Image' 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 '<img class="img-fluid one" src="images/'.$row["image1"].'" alt="'.$row["title"].' img">';
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> 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>';
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>
<!--================ 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 =================-->
<?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>
</body>
</html>