<?php
$sql = 'select * from tablename ';
$res = mysql_query($sql);
$num = mysql_fetch_row($res); //返回总的行数
if(empty($_GET['page']))
{
$page = 0;
}
else
{
$page = $_GET['page'];
if($page < 0)
{
$page = 0;
}
if($page >= ceil($num/10)) //ceil() -> 返回 向上舍入为最接近的整数
{
$page = ceil($num/10) - 1;
}
}
mysql_query('select * from tablename order by id limit '.$page.',10');
?>
<a href="page.php?page=0">首页</a>
<a href="page.php?page=<?=$page-1?>">上一页</a>
<a href="page.php?page=<?=$page+1?>">下一页</a>
<a href="page.php?page=<?=ceil($num/10)-1?>">尾页</a>
简单分页思路
最新推荐文章于 2021-06-20 23:50:43 发布