php查询数据库并分页,输出分页的html代码
$db->query("SELECT COUNT(*) FROM snippets s WHERE s.user_id = '$user_id'");
$numRecords = mysql_result($db->result, 0, 0);
$numPages = ceil($numRecords / $perpage);
$page = intval($_GET['page']);
if($page > $numPages) $page = $numPages;
if($page < 1) $page = 1;
$start = ($page - 1) * $perpage;
$nextPage = ($page + 1 > $numPages) ? $numPages : $page + 1;
$prevPage = ($page - 1 < 1) ? 1 : $page - 1;
if($page == 1 && $numPages == 1)
$paging = "[Page 1 of $numPages]";
elseif($page == 1 && $numPages > 1)
$paging = "[Page 1 of $numPages] Next >>";
elseif($page == $numPages)
$paging = "<< Prev [Page $page of $numPages]";
else
$paging = "<< Prev [Page $page of $numPages] Next >>";
开心洋葱 , 版权所有丨如未注明 , 均为原创丨未经授权请勿修改 , 转载请注明php数据库查询分页显示!