<?php
include('config/dbcon.php');
include('authentication.php');
//session_start();
include('include/header.php');
?>
<div class="container-fluid px-4">
<div class="row mt-4">
<div class="col-md-12">
<?php include('message.php'); ?>
<div class="card">
<div class="card-header">
<h4>View Category<a href="category-add.php" class="btn btn-primary float-end">Add Category</a></h4>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-bordered" id="example" width="100%" cellspacing="0">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Status</th>
<th>Edit</th>
<?php if ($_SESSION['auth_role'] == 2) : ?>
<th>Delete</th>
<?php endif; ?>
</tr>
</thead>
<tbody>
<?php
$category = "SELECT * FROM categories WHERE status !='2'";
$category_run = mysqli_query($con, $category);
if (mysqli_num_rows($category_run) > 0) {
foreach ($category_run as $item) {
?>
<tr>
<td><?= $item['id']; ?></td>
<td><?= $item['name']; ?></td>
<td>
<?php
if ($item['status'] == '1') {
echo 'Hidden';
} else {
echo 'Visible';
}
?>
</td>
<td><a href="category-edit.php?id=<?= $item['id']; ?>" class="btn btn-info">EDIT</a></td>
<?php if ($_SESSION['auth_role'] == 2) : ?>
<td>
<form action="code-superadmin.php" method="POST">
<button type="submit" name="category_delete" value="<?= $item['id'] ?>" class="btn btn-danger" onclick='return checkDelete()'>DELETE</button>
</form>
</td>
<?php endif; ?>
</tr>
<?php
}
} else {
?>
<tr>
<td colspan="5">No Rectord Found</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<script type="text/javascript">
function checkDelete(){
return confirm('Are you sure you want to delete this record?');
}
</script>
<?php
include('include/footer.php');
include('include/script.php');
?>