Viewing file:  subscribers.php (5.13 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);
?>
<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>Our Subscribers</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">Email </th>
<th scope="col">Date</th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM `users` ORDER BY user_id DESC";
$res = mysqli_query($conn, $sql);
if ($res) {
$count = 0;
while ($row = mysqli_fetch_assoc($res)) {
$id = $row['user_id'];
$email = $row['email'];
$created_at = $row['created_dt'];
$count = $count + 1;
?>
<tr data-date="<?= $created_at ?>">
<td><?= $count ?></td>
<td><?= $email ?></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>
|