Viewing file:  comments.php (6.27 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);
$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>Blog Comments</h1>
</div>
</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">Article</th>
<th scope="col">Email </th>
<th scope="col">Comments </th>
<th scope="col">Action</th>
</tr>
</thead>
<tbody>
<?php
if ($adminType !== 'Admin') {
$sql = "SELECT * FROM `comments` as a JOIN articles as b ON a.cmt_art_id=b.art_id WHERE b.art_create_by=$adminID ORDER BY cmt_id DESC";
} else {
$sql = "SELECT * FROM `comments` as a JOIN articles as b ON a.cmt_art_id=b.art_id ORDER BY cmt_id DESC";
}
$res = mysqli_query($conn, $sql);
if ($res) {
$count = 0;
while ($row = mysqli_fetch_assoc($res)) {
$id = $row['cmt_id'];
$art_title = $row['art_title'];
$email = $row['cmt_usr_email'];
$cmt_usr_msg = $row['cmt_usr_msg'];
$created_at = $row['cmt_created_dt'];
$count = $count + 1;
?>
<tr data-date="<?= $created_at ?>">
<td><?= $count ?></td>
<td><?= $art_title ?></td>
<td><?= $email ?></td>
<td><?= $cmt_usr_msg ?></td>
<td><?= date('d-m-Y', strtotime($created_at)) ?></td>
<!-- <td><a href="view_details.php?id=<?= $id ?>" class="btn btn-info">View</a></td> -->
</tr>
<?php
}
}
?>
</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'
}
]
});
// Date Filter functionality
$('#from_date, #to_date').on('change', function() {
var from_date = $('#from_date').val();
var to_date = $('#to_date').val();
// Update the export button link with date filter query parameters
var exportUrl = 'export_excel.php';
if (from_date) {
exportUrl += '?from_date=' + from_date;
}
if (to_date) {
exportUrl += (exportUrl.includes('?') ? '&' : '?') + 'to_date=' + to_date;
}
$('#export_button a').attr('href', exportUrl);
// Filter the table based on the date range
table.rows().every(function() {
var row = this.node();
var row_date = $(row).data('date');
var is_valid = true;
if (from_date && new Date(row_date) < new Date(from_date)) {
is_valid = false;
}
if (to_date && new Date(row_date) > new Date(to_date)) {
is_valid = false;
}
if (is_valid) {
$(row).show();
} else {
$(row).hide();
}
});
});
});
</script>
|