php mysql分页类(php新手入门)

3. /***

4. * php mysql 分页类
5. * 整理 http://bbs.it-home.org
6. */
7. class Pagination{
8. private $_result;
9. private $_count; //记录数
10. private $_pageMax; //最大页
11. private $_page; //当前页
12. private $_url;
13. private $_startPage;//分页条起码
14. private $_endPage; // 分页条止码
15. private $_nextPage; //上一页
16. private $_prePage; //下一页

17. function __construct($table, $pageSize, $getPage){

18. $this->_result = $GLOBALS['db']->query('SELECT * FROM '.$table);
19. $this->_count = $GLOBALS['db']->getRecordNum();
20. $this->_pageMax = ceil($this->_count/$pageSize);
21. $this->_result = '';

22. if($_GET[$getPage] == '')

23. $this->_page = 1;
24. else
25. $this->_page= max(intval($_GET[$getPage]), 1);
27. $this->_page = min($this->_page, $this->_pageMax);

28. $offset = ($this->_page - 1) * $pageSize;

29. $sql = 'SELECT * FROM '.$table.' LIMIT '. $offset .','. $pageSize;
30. $this->_result = $GLOBALS['db']->query($sql);
31. }
33. function getRecord(){
34. return $GLOBALS['db']->getRecord();
35. }
37. function getPageBar($url = '?', $barLn = 10, $style = 1){
38. if($style == 1){
39. if($barLn % 2 != 0 ){
40. $midder = ceil($barLn / 2);
41. $big_repair = $midder - 1 ;//当上面以进一法取整，则这里为减1，反之为加1
42. }else{
43. $midder = $big_repair = $barLn / 2;
44. }
45. $sml_repair = $midder- 1;
47. $this->_startPage = ($this->_page + $midder) > $this->_pageMax ? $this->_pageMax - $barLn : $this->_page - $sml_repair;
48. $this->_endPage = $this->_page _page + $big_repair;
50. }elseif($style == 2){
52. if($this->_page % $barLn == 0){
53. $this->_startPage = $this->_page;
54. }else{
55. $this->_startPage = ($this->_page > $barLn)? $this->_page - ($this->_page % $barLn ) : 1;
56. }
57. $this->_endPage = $this->_startPage + $barLn - 1;
58. }
59. $this->_url = $url;
60. $this->_nextPage = $this->_page + 1;
61. $this->_prePage = $this->_page - 1;
62. $this->_startPage = max($this->_startPage, 1);//至少从第一页开始
63. $this->_endPage = min($this->_endPage, $this->_pageMax);//最多只到末页
66. $this->_result = '当前是：'.$this->_page.'/'.$this->_pageMax.'页，共'.$this->_count.'条记录';
68. if ($this->_page > 1)
69. $this->_result .= '
70. 9
71. 3
';
73. else
74. $this->_result .= '9
75. 3';
77. for($i = $this->_startPage; $i _endPage; $i++) {
78. if ($this->_page == $i)
79. $this->_result .= ''.$i.'';
80. else
81. $this->_result.= ''.$i.'';
82. }
84. if ($this->_page != $this->_pageMax) {
85. $this->_result .= '4';
86. $this->_result .= ':';
87. } else {
88. $this->_result.= '4:';
89. }
91. $this->_result.= '
92. ';
93. return $this->_result;
94. }
95. }
96. ?>

复制代码

2、调用示例

2. $page = new Pagination($table, 5, 'page');
3. while($row = $page->getRecord()){
4. echo $row[0],'
   ';
5. }
6. echo $page->getPageBar('?',8, 1);
7. ?>

复制代码