ikan Uploader :
Directory : /home/u956822991/domains/kalamasserylocalnews.com/public_html/admin/
Upload File : |
| Current File : /home/u956822991/domains/kalamasserylocalnews.com/public_html/admin/index.php |
<?php
session_start();
include("include/config.php");
$username = $_SESSION['alogin'];
if(strlen($_SESSION['alogin'])==0)
{
header('location:login.php');
}
else{
date_default_timezone_set('Asia/Kolkata');// change according timezone
$currentTime = date( 'd-m-Y h:i:s A', time () );
if(isset($_POST['submit']))
{
$sql=mysqli_query($con,"SELECT username,Position FROM admin where username='".$_SESSION['alogin']."'");
$num=mysqli_fetch_array($sql);
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Dashboard | Kalamassery Local News | Admin</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="Premium Multipurpose Admin & Dashboard Template" name="description">
<meta content="Themesbrand" name="author">
<!-- App favicon -->
<link rel="shortcut icon" href="assets/images/favicon.png">
<link href="assets/libs/chartist/chartist.min.css" rel="stylesheet">
<!-- Bootstrap Css -->
<link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css">
<!-- Icons Css -->
<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css">
<!-- App Css-->
<link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css">
</head>
<body data-sidebar="dark">
<!-- Begin page -->
<div id="layout-wrapper">
<?php include('include/header.php');?>
<!-- ========== Left Sidebar Start ========== -->
<?php
$sql = mysqli_query($con, "SELECT role FROM admin WHERE username='$username'");
$row = mysqli_fetch_assoc($sql); // Corrected variable name from $result to $sql
if ($row['role'] == 'ADMIN') {
include('include/left-sidebar.php');
}
else {
include('include/reporter-left-sidebar.php');
}
?>
<!-- ============================================================== -->
<!-- Start right Content here -->
<!-- ============================================================== -->
<div class="main-content">
<div class="page-content">
<div class="container-fluid">
<!-- start page title -->
<div class="page-title-box">
<div class="row align-items-center">
<div class="col-md-8">
<h6 class="page-title">Dashboard</h6>
<ol class="breadcrumb m-0">
<li class="breadcrumb-item active">Welcome to Kalamassery Local News Dashboard</li>
</ol>
</div>
</div>
</div>
<!-- end page title -->
<?php if ($row['role'] == 'ADMIN') { ?>
<div class="row">
<?php
$query=mysqli_query($con,"SELECT count(*) as count FROM uploads ");
while($row=mysqli_fetch_array($query))
{
?>
<div class="col-xl-3 col-md-6">
<div class="card mini-stat bg-primary text-white">
<div class="card-body">
<div class="mb-4">
<div class="float-start mini-stat-img me-4">
<img src="assets/images/services-icon/01.png" alt="">
</div>
<h5 class="font-size-16 text-uppercase text-white-50">News Uploads</h5>
<h4 class="fw-medium font-size-24"><?php echo htmlentities($row['count']);?> <i
class="mdi mdi-arrow-up text-success ms-2"></i></h4>
</div>
<div class="pt-2">
<div class="float-end">
<a href="manage.php" class="text-white-50"><i class="mdi mdi-arrow-right h5"></i></a>
</div>
</div>
</div>
</div>
</div>
<?php } ?>
<div class="col-xl-3 col-md-6">
<div class="card mini-stat bg-primary text-white">
<div class="card-body">
<div class="mb-4">
<div class="float-start mini-stat-img me-4">
<img src="assets/images/services-icon/04.png" alt="">
</div>
<h5 class="font-size-16 text-uppercase text-white-50">Advertisements</h5>
<h4 class="fw-medium font-size-24">04<i
class="mdi mdi-arrow-up text-success ms-2"></i></h4>
</div>
<div class="pt-2">
<div class="float-end">
<a href="manage-ads.php" class="text-white-50"><i class="mdi mdi-arrow-right h5"></i></a>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- end row -->
<div class="row">
<div class="col-xl-8">
<div class="card">
<div class="card-body">
<h4 class="card-title mb-4">Latest Transaction</h4>
<div class="table-responsive">
<table class="table table-hover table-centered table-nowrap mb-0">
<thead>
<tr>
<th scope="col">Sl No</th>
<th scope="col">Date</th>
<th scope="col">Name</th>
<th scope="col">Email</th>
<th scope="col">Message</th>
</tr>
</thead>
<tbody>
<?php
$query=mysqli_query($con,"SELECT * FROM contactmsg order by user_id desc");
$cnt=1;
while($row=mysqli_fetch_array($query))
{
?>
<tr>
<th scope="row"><?php echo htmlentities($cnt);?></th>
<td><?php echo htmlentities($row['orderDate']);?></td>
<td>
<?php echo htmlentities($row['name']);?>
</td>
<td><a href="mailto:<?php echo htmlentities($row['email']);?>"><?php echo htmlentities($row['email']);?></a></td>
<td><?php echo htmlentities($row['message']);?></td>
</tr>
<?php $cnt=$cnt+1; } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<!-- end row -->
<?php } else {?>
<div class="col-xl-3">
<div class="user-sidebar">
<div class="card">
<div class="card-body">
<div class="mt-n4 position-relative">
<div class="text-center">
<img src="assets/images/users/user-4.jpg" alt="" class="avatar-xl rounded-circle img-thumbnail">
<div class="mt-3">
<h5 class=""><?php echo $username; ?></h5>
<div>
<a href="pages-profile.html#" class="text-muted m-1">Admin</a>
</div>
<div class="mt-4">
<a href="index.php" class="btn btn-primary waves-effect waves-light btn-sm">Home</a>
<a href="calendar.php" class="btn btn-primary waves-effect waves-light btn-sm">Calendar</a>
</div>
</div>
</div>
</div>
</div> <!-- end card body -->
</div> <!-- end card -->
</div>
</div>
<?php } ?>
</div> <!-- container-fluid -->
</div>
<!-- End Page-content -->
<?php include('include/footer.php');?>
</div>
<!-- end main content-->
</div>
<!-- END layout-wrapper -->
<!-- Right bar overlay-->
<div class="rightbar-overlay"></div>
<!-- JAVASCRIPT -->
<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/metismenu/metisMenu.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/node-waves/waves.min.js"></script>
<!-- Peity chart-->
<script src="assets/libs/peity/jquery.peity.min.js"></script>
<!-- Plugin Js-->
<script src="assets/libs/chartist/chartist.min.js"></script>
<script src="assets/libs/chartist-plugin-tooltips/chartist-plugin-tooltip.min.js"></script>
<script src="assets/js/pages/dashboard.init.js"></script>
<script src="assets/js/app.js"></script>
</body>
</html>
<?php } ?>
........