php简单分页原理与分页代码示例

3. /*******分页原理*********/

4. //每页显示记录条数
5. $page_size = 3;
6. $sql = "select * from message";
7. $result = mysql_query($sql);

8. //总记录条数

9. $num = mysql_num_rows($result);
10. //总页面数量的计算
11. if($numif($num%$page_size) { $page_count = intval($num/$page_size)+1 ;}
12. if($num%$page_size==0) { $page_count = $num/$page_size ;}
14. if( isset($_GET['page']) ){
15. $page = intval($_GET['page']);
16. }
17. else{
18. $page = 1;
19. }
21. $sql_page= "select * from message limit ".($page-1)*$page_size.",$page_size";
22. $do = mysql_query($sql_page);
23. while( $re = mysql_fetch_object($do)){
24. echo '随便写点什么都行';
25. }
27. if($page1){
28. echo '首页';
29. echo '上一页';
30. }
32. if($page$page_count){
33. echo '
    ';
34. echo '下一页';
35. echo '最后一夜';
36. echo '

';

}

复制代码