简略分页思路

简单分页思路?php$sql select * from tablename $res mysql_query($sql)$num mysql_fetch_row($r

简单分页思路

<?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>
?