|
Server IP : 162.214.80.37 / Your IP : 216.73.216.83 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/imyrqtmy/public_html/localapp/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
header("Location: login.php");
}
include("inc/config.php");
?>
<!DOCTYPE html>
<html lang="en">
<?php require "inc/head.php"; ?>
<body>
<!-- Header -->
<?php require "inc/header.php"; ?>
<div class="wrapper">
<?php require "inc/sidebar.php"; ?>
<div id="content">
<div class="row">
<div class="col-12 col-sm-12">
<div class="row mb-4">
<div class="col-12 col-md-12">
<div class="card redial-border-light redial-shadow mb-4">
<div class="card-body">
<h6 class="header-title pl-3 redial-relative">Data Table</h6>
<table id="example" class="table table-bordered" cellspacing="0" width="100%">
<thead>
<tr>
<th>#</th>
<th>News Title</th>
<th>Reporter</th>
<th>Category</th>
<th>Image</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$query = "SELECT news.id, news.news_title, news.photo, news.status,
vendor.name AS reporter_name,
categories.cat_name
FROM news
LEFT JOIN vendor ON news.reporter_id = vendor.id
LEFT JOIN categories ON news.category_id = categories.id";
$query_run = mysqli_query($conn, $query);
if (mysqli_num_rows($query_run) > 0) {
foreach ($query_run as $row) {
$status_class = ($row['status'] == 'Approved') ? 'badge bg-success' : 'badge bg-warning';
?>
<tr>
<td><?php echo $row['id']; ?></td>
<td><?php echo $row['news_title']; ?> </td>
<td><?php echo $row['reporter_name']; ?></td>
<td><?php echo $row['cat_name']; ?></td>
<td><img src="<?php echo "../vendor/news/" . $row['photo']; ?>" height="50" alt=""></td>
<td>
<span class="<?php echo $status_class; ?>">
<?php echo $row['status']; ?>
</span>
</td>
<td>
<div class='btn-group mb-2'>
<!-- <a href="update-news.php?id=<?php echo $row['id']; ?>" class="btn btn-success">
<i class='fa fa-pencil'></i>
</a> -->
<form action="update_status.php" method="post" style="display:inline-block;">
<input type="hidden" name="news_id" value="<?php echo $row['id']; ?>">
<button type="submit" name="update_status" class="btn btn-primary">
<i class="fa fa-check"></i>
</button>
</form>
</div>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- jQuery -->
<script src="dist/js/plugins.min.js"></script>
<script src="dist/js/common.js"></script>
</body>
</html>