ikan Uploader :
Directory : /home/u956822991/domains/kalamasserylocalnews.com/public_html/admin/
Upload File : |
| Current File : /home/u956822991/domains/kalamasserylocalnews.com/public_html/admin/add-reporter.php |
<?php
session_start();
include('include/config.php');
$username = $_SESSION['alogin'];
date_default_timezone_set('Asia/Kolkata'); // change according to your timezone
if (strlen($_SESSION['alogin']) == 0) {
header('location: login.php');
} else {
$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') {
if (isset($_POST['submit'])) {
$reporter = mysqli_real_escape_string($con, $_POST['reporter']);
$sql_insert = mysqli_query($con, "INSERT INTO admin (username, password, role, status) VALUES ('$reporter', 'f925916e2754e5e03f75dd58a5733251', 'REPORTER', 'ACTIVE')");
if ($sql_insert) {
$_SESSION['msg'] = "Reporter Inserted Successfully !!"; // Changed message for clarity
} else {
$_SESSION['msg'] = "Error: " . mysqli_error($con);
}
}
if(isset($_GET['del']))
{
mysqli_query($con,"delete from admin where id = '".$_GET['id']."'");
$_SESSION['delmsg']="Reporter Deleted !!";
}
if(isset($_GET['disable']))
{
mysqli_query($con,"update admin set status='INACTIVE' where id = '".$_GET['id']."'");
$_SESSION['disablemsg']="Reporter Account Disabled !!";
}
if(isset($_GET['enable']))
{
mysqli_query($con,"update admin set status='ACTIVE' where id = '".$_GET['id']."'");
$_SESSION['enablemsg']="Reporter Account Enabled !!";
}
} else {
header('location: unauthorized.php');
exit(); // Make sure to exit after redirection
}
}
?>
<!doctype html>
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta charset="utf-8">
<title>Form Editors | Veltrix - Admin & Dashboard Template</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.ico">
<!-- 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">\
<script src="http://js.nicedit.com/nicEdit-latest.js" type="text/javascript"></script>
<script type="text/javascript">bkLib.onDomLoaded(nicEditors.allTextAreas);</script>
</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');
}
?>
<!-- Left Sidebar End -->
<!-- ============================================================== -->
<!-- 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">Upload News</h6>
</div>
</div>
</div>
<!-- end page title -->
<div class="row">
<div class="col-12">
<div class="card">
<?php if(isset($_POST['submit']))
{?>
<div class="alert alert-success">
<button type="button" class="btn-close" data-dismiss="alert"></button>
<strong>Well done!</strong> <?php echo htmlentities($_SESSION['msg']);?><?php echo htmlentities($_SESSION['msg']="");?>
</div>
<?php } ?>
<?php if(isset($_GET['del']))
{?>
<div class="alert alert-danger">
<strong>Oh snap!</strong> <?php echo htmlentities($_SESSION['delmsg']);?><?php echo htmlentities($_SESSION['delmsg']="");?></p>
</div>
<?php } ?>
<?php if(isset($_GET['disable']))
{?>
<div class="alert alert-danger">
<strong>Oh snap!</strong> <?php echo htmlentities($_SESSION['disablemsg']);?><?php echo htmlentities($_SESSION['disablemsg']="");?></p>
</div>
<?php } ?>
<?php if(isset($_GET['enable']))
{?>
<div class="alert alert-success">
<button type="button" class="btn-close" data-dismiss="alert"></button>
<strong>Well done!</strong> <?php echo htmlentities($_SESSION['enablemsg']);?><?php echo htmlentities($_SESSION['enablemsg']="");?>
</div>
<?php } ?>
<div class="card-body">
<form class="form-horizontal row-fluid" name="insertproduct" method="post" enctype="multipart/form-data">
<div class="form-group">
<label class="control-label" for="basicinput">News Content</label>
<div class="controls">
<input name="reporter" placeholder="Enter Reporter Name" rows="6" cols="110" class="form-control">
</div>
</div>
<div class="text-center mt-3">
<button type="submit" name="submit" class="btn btn-primary waves-effect waves-light">Send Files</button>
</div>
</form>
</div>
</div>
</div> <!-- end col -->
</div> <!-- end row -->
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-body">
<div class="table-responsive">
<br />
<table class="table table-editable table-nowrap align-middle table-edits">
<thead>
<tr>
<th>ID</th>
<th>NAME</th>
<th>ROLE</th>
<th>STATUS</th>
<th>CREATION DATE</th>
<th>UPDATION DATE</th>
<th>EDIT / DELETE</th>
</tr>
</thead>
<?php
$query = mysqli_query($con, "select * from admin where role='REPORTER' order by id desc");
while ($row = mysqli_fetch_array($query)) {
?>
<tbody>
<tr data-id="1">
<td><?php echo htmlentities($row['id']); ?></td>
<td><?php echo htmlentities($row['username']); ?></td>
<td><?php echo htmlentities($row['role']); ?></td>
<td>
<?php if ($row['status'] == 'ACTIVE') { ?>
<a href="add-reporter.php?id=<?php echo $row['id']; ?>&disable=inactive" onClick="return confirm('Are you sure you want to inactivate this account?')">
<button type="button" class="btn btn-success waves-effect waves-light">
<?php echo htmlentities($row['status']); ?>
</button></a>
<?php } else { ?>
<a href="add-reporter.php?id=<?php echo $row['id']; ?>&enable=active" onClick="return confirm('Are you sure you want to activate this account?')">
<button type="button" class="btn btn-danger waves-effect waves-light">
<?php echo htmlentities($row['status']); ?>
</button>
<?php } ?>
</td>
<td><?php echo htmlentities($row['creationdate']); ?></td>
<td><?php echo htmlentities($row['updationdate']); ?></td>
<td style="width: 100px">
<a href="edit-reporter.php?id=<?php echo $row['id']; ?>">
<button type="button" class="btn btn-success waves-effect waves-light">
Edit
</button>
</a>
<a href="add-reporter.php?id=<?php echo $row['id']; ?>&del=delete" onClick="return confirm('Are you sure you want to delete?')">
<button type="button" class="btn btn-danger waves-effect waves-light">
Delete
</button>
</a>
</td>
</tr>
</tbody>
<?php } ?>
</table>
<!-- end table -->
</div>
<!-- end -->
</div>
</div>
</div> <!-- end col -->
</div> <!-- end row -->
</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>
<!--tinymce js-->
<script src="assets/libs/tinymce/tinymce.min.js"></script>
<!-- init js -->
<script src="assets/js/pages/form-editor.init.js"></script>
<script src="assets/js/app.js"></script>
</body>
</html>
........