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

3. //定每页显示多少条

4. //count(*)查询总条数
5. //计算总页数ceil()
6. //判断$_GET 并赋值当前页数
7. //mysql查询 limit (当前页数-1)*每页条数,每页条数
8. //如果总条数不为空，进行循环mysql_fetch_array()
9. //$_SERVER['PHP_SELF']
10. //上一页?page=当前页-1
11. //下一页?page=当前页+1
12. //edit: bbs.it-home.org
13. include("conn.php");
14. $perpagenum = 3;
15. $total = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM message"));
16. $Total = $total[0];
17. $Totalpage =ceil($Total/$perpagenum);

18. if(!isset($_GET['page'])||!intval($_GET['page'])||$_GET['page']>$Totalpage){

19. $page = 1;
20. }else{
21. $page = $_GET['page'];
22. }

23. $start = ($page-1)*$perpagenum;

24. $sql = "SELECT * FROM message ORDER BY id DESC LIMIT $start,$perpagenum";
25. $result = mysql_query($sql);
26. $contents = mysql_fetch_array($result);
27. ?>
29. if($total){
30. do{
31. $user = $contents['user'];
32. $contact = $contents['contact'];
33. $content = $contents['content'];
34. $date = $contents['date'];

35. ?>

44. }
45. //php分页开始
46. while($contents=mysql_fetch_array($result));
47. $per = $page-1;
48. $next= $page+1;
49. echo "共有".$Total."条留言，每页".$perpagenum."条，共".$page."/".$Totalpage."页。";
    if($page!=1){
    echo "首页".
    "上一页";
    }
    if($page!=$Totalpage){
    echo "下一页";
    echo "尾页";
    }
    ?>
    }
    ?>

昵称：		发表于:

复制代码