Viewing file:  banners.php (5.2 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include('include/header.php');
include('include/conn.php');
error_reporting(E_ALL);
ini_set('display_errors', 1);
$admin_type = $_SESSION['admin_type'];
$adminID = $_SESSION['admin_id'];
$adminType = $_SESSION['admin_type'];
?>
<link href="https://cdn.datatables.net/1.12.1/css/jquery.dataTables.min.css" rel="stylesheet" type="text/css">
<link href="https://cdn.datatables.net/buttons/2.2.3/css/buttons.dataTables.min.css" rel="stylesheet" type="text/css">
<style type="text/css">
.dt-buttons {
width: 50%;
}
</style>
<!-- begin MAIN PAGE CONTENT -->
<div id="page-wrapper" style="min-height:142vh;">
<div class="page-content">
<!-- begin PAGE TITLE ROW -->
<div class="row">
<div class="col-lg-12">
<div class="page-title">
<h1>Banners</h1>
</div>
<?php
if ($admin_type === 'Admin') {
?>
<div class="row">
<div class="col-md-2">
<a href="add_banners.php" class="btn btn-success">Banner +</a>
</div>
</div>
<?php
}
?>
<br>
</div>
<table id="data_table" class="display dataTable table table-striped table-bordered table-hover table-green profile-table">
<thead>
<tr>
<th scope="col">S.No</th>
<th scope="col">Title</th>
<th scope="col">Image</th>
<th scope="col">Action</th>
</tr>
</thead>
<tbody>
<?php
$sql_desig = "SELECT * FROM `banners` ORDER BY ban_id DESC";
$desig_result = mysqli_query($conn, $sql_desig);
if ($desig_result) {
$i = 1; // Initialize the counter outside the loop
while ($row = mysqli_fetch_assoc($desig_result)) {
$art_id = $row['ban_id'];
?>
<tr>
<td><?= $i ?></td>
<td><?= $row['ban_title'] ?></td>
<td><img src="<?= $row['ban_image'] ?>" alt="" style="width: 100px;"></td>
<td>
<a href="add_banners.php?ban_edit=<?= $art_id ?>" class="btn btn-primary">
<i class="fa fa-edit text-white"></i>
</a>
<a href="banner_del.php?ban_del=<?= $art_id ?>" class="btn btn-warning">
<i class="fa fa-trash text-white"></i>
</a>
</td>
</tr>
<?php
$i++; // Increment the counter inside the loop
}
}
?>
</tbody>
</table>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
</div>
<!-- /.page-content -->
</div>
<!-- /#page-wrapper -->
<!-- begin FOOTER -->
<?php include('include/footer.php'); ?>
<!-- end FOOTER -->
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.datatables.net/1.12.1/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.2.3/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.2.3/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.2.3/js/buttons.print.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.2.3/js/buttons.colVis.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script>
$(document).ready(function() {
var table = $('#data_table').DataTable({
dom: 'Bfrtip',
buttons: [{
extend: 'copy',
className: 'btn btn-primary',
text: 'Copy'
},
{
extend: 'csv',
className: 'btn btn-primary',
text: 'CSV'
},
{
extend: 'excel',
className: 'btn btn-primary',
text: 'Excel'
},
{
extend: 'pdf',
className: 'btn btn-primary',
text: 'PDF'
},
{
extend: 'print',
className: 'btn btn-primary',
text: 'Print'
}
]
});
});
</script>
|