跳转到主内容
趣航编程网 - 趣学编程,启航技术之路!

php分页原理简单分页代码总结

//定每页显示多少条//count(*)查询总条数//计算总页数ceil()//判断$_get 并赋值当前页数//mysql查询 limit (当前页数-1)*每页条数,每页条数//如果总条数不为空,进行循环mysql_fetch_array()//$_server['php_self']//上一页?page=当前页-1//下一页?page=当前页+1//edit: bbs.it-home.orginclude("conn.php");$perpagenum = 3;$total = mysql_fetch_array(mysql_query("select count(*) from message"));$total = $total[0];$totalpage =ceil($total/$perpagenum);if(!isset($_GET['page'])||!intval($_GET['page'])||$_GET['page']>$Totalpage){$page = 1;}else{$page = $_GET['page'];}$start = ($page-1)*$perpagenum;$sql = "SELECT * FROM message ORDER BY id DESC LIMIT $start,$perpagenum";$result = mysql_query($sql);$contents = mysql_fetch_array($result);?>if($total){do{$user = $contents['user'];$contact = $contents['contact'];$content = $contents['content'];$date = $contents['date'];?>昵称:发表于:}//php分页开始while($contents=mysql_fetch_array($result));$per = $page-1;$next= $page+1;echo "共有".$Total."条留言,每页".$perpagenum."条,共".$page."/".$Totalpage."页。";if($page!=1){echo "首页"."上一页";}if($page!=$Totalpage){echo "下一页";echo "尾页";}?>}?>复制代码

相关文章