php - MySQL PHP 分页

Question

是否可以在不获取表格所有元素的情况下创建分页？但是对于 GET 中的页面，例如/1/666...

Answer 1

它通常涉及发出两个查询:一个是获取结果集的“切片”，另一个是获取记录总数。从那里，您可以计算出您有多少页并相应地构建分页。

一个简单的例子:

<?php
$where = ""; // your WHERE clause would go in here
$batch = 10; // how many results to show at any one time
$page  = (intval($_GET['page']) > 0) ? intval($_GET['page']) : 1;
$start = $page-1/$batch;
$pages = ceil($total/$batch);

$sql = "SELECT COUNT(*) AS total FROM tbl $where";
$res = mysql_query($sql);
$row = mysql_fetch_assoc($res);
$total = $row['total'];

// start pagination
$paging = '<p class="paging">Pages:';
for ($i=1; $i <= $pages; $i++) {
    if ($i==$page) {
        $paging.= sprintf(' <span class="current">%d</a>', $i);
    } else {
        $paging.= sprintf(' <a href="?page=%1$d">%1$d</a>', $i);
    }
}
$paging.= sprintf' (%d total; showing %d to %d)', $total, $start+1, min($total, $start+$batch));

然后查看您的分页链接:

...
// loop over result set here

// render pagination links
echo $paging;

希望对您有所帮助。