ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/aspicious.php |
<?php
include "common/header.php";
// Database connection (PDO)
$host = 'localhost';
$db = 'poojajeweller';
$user = 'poojajeweller_user';
$pass = 'Poojajeweller@12345#';
$charset = 'utf8mb4';
try {
$dsn = "mysql:host=$host;dbname=$db;charset=utf8mb4";
$pdo = new PDO($dsn, $user, $pass, [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
]);
} catch (PDOException $e) {
die("Database connection failed: " . $e->getMessage());
}
/* ------------------ PAGINATION ------------------ */
$limit = 20; // number of records per page
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
if ($page < 1) $page = 1;
$offset = ($page - 1) * $limit;
// Count total records
$totalQuery = $pdo->query("SELECT COUNT(*) as total FROM auspicious_days");
$totalResult = $totalQuery->fetch(PDO::FETCH_ASSOC);
$totalRows = $totalResult['total'];
$totalPages = ceil($totalRows / $limit);
// Fetch paginated records
$stmt = $pdo->prepare("SELECT * FROM auspicious_days ORDER BY id ASC LIMIT :limit OFFSET :offset");
$stmt->bindValue(":limit", $limit, PDO::PARAM_INT);
$stmt->bindValue(":offset", $offset, PDO::PARAM_INT);
$stmt->execute();
$auspiciousDays = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
<!-- ==================================================== -->
<!-- Start right Content here -->
<!-- ==================================================== -->
<div class="page-content">
<!-- Start Container Fluid -->
<div class="container-xxl">
<div class="row">
<div class="col-xl-12">
<div class="card">
<div class="card-header d-flex justify-content-between align-items-center gap-1">
<h4 class="card-title flex-grow-1">All Auspicious Days</h4>
<a href="add_aspicious.php" class="btn btn-sm btn-primary">
Add Auspicious Day
</a>
</div>
<div>
<div class="table-responsive">
<table class="table align-middle mb-0 table-hover table-centered">
<thead class="bg-light-subtle">
<tr>
<th>Sl No.</th>
<th>Title</th>
<th>Date</th>
<th>Icon</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php if ($auspiciousDays): ?>
<?php $sn = $offset + 1; // serial number continues across pages ?>
<?php foreach ($auspiciousDays as $day): ?>
<tr>
<td><?= $sn++; ?></td>
<td><?= htmlspecialchars($day['title']) ?></td>
<td><?= htmlspecialchars($day['day_date']) ?></td>
<td>
<?php if (!empty($day['icon'])): ?>
<img src="../<?= htmlspecialchars($day['icon']) ?>" alt="icon" width="40" height="40" class="rounded">
<?php else: ?>
<span class="text-muted">No Icon</span>
<?php endif; ?>
</td>
<td>
<div class="d-flex gap-2">
<a href="add_aspicious.php?id=<?= $day['id'] ?>&action=edit_aspicious" class="btn btn-soft-primary btn-sm">
<iconify-icon icon="solar:pen-2-broken" class="align-middle fs-18"></iconify-icon>
</a>
<a href="function.php?delete_auspicious=<?= $day['id'] ?>&redirect=aspicious.php"
onclick="return confirm('Are you sure you want to delete this record?')"
class="btn btn-soft-danger btn-sm">
<iconify-icon icon="solar:trash-bin-minimalistic-2-broken" class="align-middle fs-18"></iconify-icon>
</a>
</div>
</td>
</tr>
<?php endforeach; ?>
<?php else: ?>
<tr>
<td colspan="6" class="text-center text-muted">No Auspicious Days found.</td>
</tr>
<?php endif; ?>
</tbody>
</table>
</div>
<!-- end table-responsive -->
</div>
<!-- Pagination -->
<?php if ($totalPages > 1): ?>
<div class="card-footer border-top">
<nav aria-label="Page navigation example">
<ul class="pagination justify-content-end mb-0">
<!-- Previous -->
<li class="page-item <?= ($page <= 1) ? 'disabled' : '' ?>">
<a class="page-link" href="?page=<?= $page-1 ?>">Previous</a>
</li>
<!-- Page Numbers -->
<?php for ($i = 1; $i <= $totalPages; $i++): ?>
<li class="page-item <?= ($i == $page) ? 'active' : '' ?>">
<a class="page-link" href="?page=<?= $i ?>"><?= $i ?></a>
</li>
<?php endfor; ?>
<!-- Next -->
<li class="page-item <?= ($page >= $totalPages) ? 'disabled' : '' ?>">
<a class="page-link" href="?page=<?= $page+1 ?>">Next</a>
</li>
</ul>
</nav>
</div>
<?php endif; ?>
</div>
</div>
</div>
</div>
<!-- End Container Fluid -->
<!-- ========== Footer Start ========== -->
<?php include "common/footer.php" ?>
<!-- ========== Footer End ========== -->
</div>
<!-- ==================================================== -->
<!-- End Page Content -->
<!-- ==================================================== -->
</div>
<!-- END Wrapper -->
<!-- Vendor Javascript (Require in all Page) -->
<script src="assets/js/vendor.js"></script>
<!-- App Javascript (Require in all Page) -->
<script src="assets/js/app.js"></script>
</body>
</html>
........