php怎么实现翻页

实现翻页的基本方法

在PHP中实现翻页功能通常需要结合SQL查询的LIMIT子句和前端的分页控件。以下是一个基本实现步骤：

获取当前页码和每页显示数量

$current_page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$per_page = 10; // 每页显示10条记录

计算SQL查询的偏移量

$offset = ($current_page - 1) * $per_page;

构建带分页的SQL查询

$sql = "SELECT * FROM your_table LIMIT $offset, $per_page";
$result = mysqli_query($conn, $sql);

计算总页数

获取总记录数

$total_sql = "SELECT COUNT(*) as total FROM your_table";
$total_result = mysqli_query($conn, $total_sql);
$total_row = mysqli_fetch_assoc($total_result);
$total_records = $total_row['total'];

计算总页数

$total_pages = ceil($total_records / $per_page);

生成分页链接

创建分页导航HTML

$pagination = '';
for ($page = 1; $page <= $total_pages; $page++) {
    $active = ($page == $current_page) ? 'active' : '';
    $pagination .= "<a href='?page=$page' class='$active'>$page</a> ";
}

完整示例代码

数据库连接和查询

$conn = mysqli_connect("localhost", "username", "password", "database");

$current_page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$per_page = 10;
$offset = ($current_page - 1) * $per_page;

$sql = "SELECT * FROM articles LIMIT $offset, $per_page";
$result = mysqli_query($conn, $sql);

显示数据和分页导航

while ($row = mysqli_fetch_assoc($result)) {
    echo "<div>{$row['title']}</div>";
}

$total_sql = "SELECT COUNT(*) as total FROM articles";
$total_result = mysqli_query($conn, $total_sql);
$total_row = mysqli_fetch_assoc($total_result);
$total_pages = ceil($total_row['total'] / $per_page);

echo "<div class='pagination'>";
for ($page = 1; $page <= $total_pages; $page++) {
    echo "<a href='?page=$page'>$page</a> ";
}
echo "</div>";

高级分页实现

使用预处理语句防止SQL注入

$stmt = $conn->prepare("SELECT * FROM articles LIMIT ?, ?");
$stmt->bind_param("ii", $offset, $per_page);
$stmt->execute();
$result = $stmt->get_result();

添加上一页/下一页按钮

if ($current_page > 1) {
    echo "<a href='?page=".($current_page-1)."'>上一页</a>";
}
if ($current_page < $total_pages) {
    echo "<a href='?page=".($current_page+1)."'>下一页</a>";
}

使用分页类库

对于更复杂的需求，可以考虑使用现成的分页类库，如Laravel的paginate方法：

$posts = Post::paginate(15); // 每页15条
return view('posts.index', ['posts' => $posts]);

在视图中显示分页链接：

{{ $posts->links() }}

这些方法提供了从基础到高级的PHP分页实现方案，可以根据项目需求选择合适的实现方式。