Jinsi ya Kuongeza Pagination kwenye User Management Dashboard kwa PHP

Jifunze jinsi ya kuongeza pagination kwenye User Management Dashboard kwa PHP. Pagination inasaidia kupunguza loading time na kufanya dashboard iwe responsive na rahisi kusoma, hasa ikiwa una watumiaji wengi.

Example Code:
1. Pagination Dashboard
<?php
session_start();
if (!isset($_SESSION['admin_logged'])) {
header("Location: login.php");
exit;
}

// Database connection
$pdo = new PDO("mysql:host=localhost;dbname=test_db;charset=utf8", "root", "");

// Pagination settings
$limit = 10; // users per page
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$offset = ($page - 1) * $limit;

// Count total users
$total_stmt = $pdo->query("SELECT COUNT(*) FROM users");
$total_users = $total_stmt->fetchColumn();
$total_pages = ceil($total_users / $limit);

// Fetch users for current page
$stmt = $pdo->prepare("SELECT * FROM users ORDER BY id ASC LIMIT :offset, :limit");
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
$stmt->execute();
$users = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>

<h1>User Management Dashboard</h1>
<a href="logout.php">Logout</a>

<h2>Users</h2>
<table border="1" cellpadding="5">
<tr>
<th>ID</th>
<th>Username</th>
<th>Email</th>
<th>Actions</th>
</tr>
<?php foreach ($users as $user): ?>
<tr>
<td><?= $user['id'] ?></td>
<td><?= htmlspecialchars($user['username']) ?></td>
<td><?= htmlspecialchars($user['email']) ?></td>
<td>
<a href="edit_user.php?id=<?= $user['id'] ?>">Edit</a> |
<a href="dashboard.php?delete=<?= $user['id'] ?>" onclick="return confirm('Delete?')">Delete</a>
</td>
</tr>
<?php endforeach; ?>
</table>

<!-- Pagination Links -->
<div style="margin-top:20px;">
<?php for ($i = 1; $i <= $total_pages; $i++): ?>
<a href="?page=<?= $i ?>" style="margin:0 5px; <?= $i==$page ? 'font-weight:bold;' : '' ?>"><?= $i ?></a>
<?php endfor; ?>
</div>

2. Logout (logout.php)
<?php
session_start();
session_destroy();
header("Location: login.php");
exit;
?>

Links Za Kujifunza Zaidi

🌐 Faulink Official Website:
https://www.faulink.com/

📘 Jifunze Web Design & Programming:
https://www.faulink.com/excel_mifumo.php

📲 Piga / WhatsApp kwa msaada wa haraka:
https://wa.me/255693118509