PHP分页功能怎么实现_PHP分页显示数据的原理与代码示例

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(100),
    created_at DATETIME
);

<?php
$host = 'localhost';
$db   = 'test_db';
$user = 'root';
$pass = '';
$charset = 'utf8mb4';
<p>$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$options = [
PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
];</p><p>try {
$pdo = new PDO($dsn, $user, $pass, $options);
} catch (&#36;e) {
die("数据库连接失败: " . &#36;e->getMessage());
}
?></p>

<?php
// 设置每页显示数量
&#36;pageSize = 10;
<p>// 获取当前页码，确保为正整数，默认第一页
&#36;page = isset(&#36;_GET['page']) ? (int)&#36;_GET['page'] : 1;
&#36;page = &#36;page < 1 ? 1 : &#36;page;</p><p>// 计算偏移量
&#36;offset = (&#36;page - 1) * &#36;pageSize;</p><p>// 查询总记录数
&#36;stmt = &#36;pdo->prepare("SELECT COUNT(*) FROM users");
&#36;stmt->execute();
&#36;total = &#36;stmt->fetchColumn();</p><p>// 计算总页数
&#36;totalPages = ceil(&#36;total / &#36;pageSize);</p><p>// 查询当前页数据
&#36;stmt = &#36;pdo->prepare("SELECT * FROM users ORDER BY id LIMIT ? OFFSET ?");
&#36;stmt->bindValue(1, &#36;pageSize, PDO::PARAM_INT);
&#36;stmt->bindValue(2, &#36;offset, PDO::PARAM_INT);
&#36;stmt->execute();
&#36;users = &#36;stmt->fetchAll();
?></p>

<table border="1" cellpadding="8">
  <tr>
    <th>ID</th>
    <th>姓名</th>
    <th>邮箱</th>
  </tr>
  <?php foreach (&#36;users as &#36;user): ?>
  <tr>
    <td><?php echo &#36;user['id']; ?></td>
    <td><?php echo htmlspecialchars(&#36;user['name']); ?></td>
    <td><?php echo htmlspecialchars(&#36;user['email']); ?></td>
  </tr>
  <?php endforeach; ?>
</table>
<p><div style="margin-top: 20px;">
<?php if (&#36;page > 1): ?>
<a href="?page=1">首页</a>
<a href="?page=<?php echo &#36;page - 1; ?>">上一页</a>
<?php endif; ?></p><p><span> 第&#36;page页 / 共&#36;totalPages页 </span></p><p><?php if (&#36;page < &#36;totalPages): ?>
<a href="?page=<?php echo &#36;page + 1; ?>">下一页</a>
<a href="?page=<?php echo &#36;totalPages; ?>">尾页</a>
<?php endif; ?>
</div></p>