本文實例講述了php+ajax實現無刷新分頁實現方法。分享給大家供大家參考。具體如下：
limit 偏移量，長度;
limit 0,7; 第一頁
limit 7,7; 第二頁
limit 14,7; 第三頁
每頁信息條數：7
信息總條數：select count(*) from table
信息總頁數：ceil向上取整(總條數/每頁條數)
1、分頁類具體使用
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
|
<?phpclass pagination { private $total; //數據表中總記錄數 private $listrows; //每頁顯示行數 private $limit; //mysql 數據庫的limit private $uri; //分頁信息前面的uri地址 private $pagenum; //頁數 private $config = array('header' => "個記錄", "prev" => "【上一頁】", "next" => "【下一頁】", "first" => "【首 頁】", "last" => "【尾 頁】"); private $listnum = 8; /* * $total 當前信息總條數 * $listrows 每頁顯示的條數 * $pa 下面的page http://網址/index.php?page=5 */ public function __construct($total, $listrows = 10, $pa = "") { $this->total = $total; $this->listrows = $listrows; $this->uri = $this->geturi($pa); $this->page = !empty($_get["page"]) ? $_get["page"] : 1;//不傳入page，則默認顯示首頁 $this->pagenum = ceil($this->total / $this->listrows); $this->limit = $this->setlimit(); } //設置每頁顯示的條數 private function setlimit() { return "limit " . ($this->page - 1) * $this->listrows . ", {$this->listrows}"; } //獲得url地址 private function geturi($pa) { $url = $_server["request_uri"] . (strpos($_server["request_uri"], '?') ? '' : "?") . $pa; $parse = parse_url($url); if (isset($parse["query"])) { parse_str($parse['query'], $params); unset($params["page"]); $url = $parse['path'] . '?' . http_build_query($params); } return $url; } //魔術方法， public function __get($args) { if ($args == "limit") return $this->limit; else return null; } //頁面開始的條數 private function start() { if ($this->total == 0) return 0; else return ($this->page - 1) * $this->listrows + 1; } //頁面結束的條數 private function end() { return min($this->page * $this->listrows, $this->total); } /*設置首頁*/ private function first() { $html = ""; if ($this->page == 1) $html.=' '.$this->config["first"].' '; else $html.=" <a href='javascript:void(0)' onclick='showpage(\"{$this->uri}&page=1\")'>{$this->config["first"]}</a> "; //$html.=" <a href='{$this->uri}&page=1'>{$this->config["first"]}</a> "; return $html; } /*設置上一頁*/ private function prev() { $html = ""; if ($this->page == 1) $html.=' '.$this->config["prev"].' '; else $html.=" <a href='javascript:void(0)' onclick='showpage(\"{$this->uri}&page=" . ($this->page - 1) . "\")'>{$this->config["prev"]}</a> "; //$html.=" <a href='{$this->uri}&page=".($this->page-1)."'>{$this->config["prev"]}</a> "; return $html; } //頁碼列表【首頁】【2】【3】…………【尾頁】 private function pagelist() { $linkpage = ""; $inum = floor($this->listnum / 2); for ($i = $inum; $i >= 1; $i--) { $page = $this->page - $i; if ($page < 1) continue; $linkpage.=" <a href='javascript:void(0)' onclick='showpage(\"{$this->uri}&page={$page}\")'>{$page}</a> "; } $linkpage.=" {$this->page} "; for ($i = 1; $i <= $inum; $i++) { $page = $this->page + $i; if ($page <= $this->pagenum) $linkpage.=" <a href='javascript:void(0)' onclick='showpage(\"{$this->uri}&page={$page}\")'>{$page}</a> "; else break; } return $linkpage; } /*設置下一頁*/ private function next() { $html = ""; if ($this->page == $this->pagenum) $html.=' '.$this->config["next"].' '; else $html.=" <a href='javascript:void(0)' onclick='showpage(\"{$this->uri}&page=" . ($this->page + 1) . "\")'>{$this->config["next"]}</a> "; //$html.=" <a href='{$this->uri}&page=".($this->page + 1)."'>{$this->config["next"]}</a> "; return $html; } /*設置尾頁*/ private function last() { $html = ""; if ($this->page == $this->pagenum) $html.=' '.$this->config["last"].' '; else $html.=" <a href='javascript:void(0)' onclick='showpage(\"{$this->uri}&page=" . ($this->pagenum) . "\")'>{$this->config["last"]}</a> "; //$html.=" <a href='{$this->uri}&page=.(this->pagenum).'>{$this->config["last"]}</a> "; return $html; } /*設置頁面跳轉*/ private function gopage() { return ' <input type="text" onkeydown="javascript:if(event.keycode==13){var page=(this.value>' . $this->pagenum . ')?' . $this->pagenum . ':this.value;showpage(\'' . $this->uri . '&page=\'+page+\'\')}" value="' . $this->page . '" style="width:25px"> <input type="button" value="go" onclick="javascript:var page=(this.previoussibling.value>' . $this->pagenum . ')?' . $this->pagenum . ':this.previoussibling.value;showpage(\'' . $this->uri . '&page=\'+page+\'\')"> '; } //頁面列表配置選項 function fpage($display = array(0, 1, 2, 3, 4, 5, 6, 7, 8)) { $html[0] = " 共有<b>{$this->total}</b>{$this->config["header"]} "; $html[1] = " 每頁顯示<b>" . ($this->end() - $this->start() + 1) . "</b>條，本頁<b>{$this->start()}-{$this->end()}</b>條 "; $html[2] = " <b>{$this->page}/{$this->pagenum}</b>頁 "; $html[3] = $this->first(); $html[4] = $this->prev(); $html[5] = $this->pagelist(); $html[6] = $this->next(); $html[7] = $this->last(); $html[8] = $this->gopage(); $fpage = ''; foreach ($display as $index) { $fpage.=$html[$index]; } return $fpage; }} |
2 數據顯示
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
<?php//鏈接數據庫//獲得具體信息//分頁顯示header("content-type:text/html;charset=utf-8");$link = mysql_connect('localhost','root','111111');mysql_select_db('shop', $link);mysql_query("set names utf8");$css = <<<eof<style type="text/css"> table {border:1px solid black; width:700px; margin:auto; border-collapse:collapse;} td {border:1px solid black; }</style>eof;echo $css;echo "<table> <tr><td>序號</td><td>名稱</td><td>數量</td><td>價格</td><td>時間</td></tr>";//1 引入分頁類include "./pagination.php";//2. 獲得信息總條數$sql = "select * from sw_goods";$qry = mysql_query($sql);$total = mysql_num_rows($qry);$per = 7;//3. 實例化分頁類對象$page_obj = new pagination($total,$per);//4. 拼裝sql語句，獲得每頁信息//利用page_obj實現limit的靈活設置//$page_obj -> limit;$sqla = "select * from sw_goods ".$page_obj->limit;$qrya = mysql_query($sqla);//5. 獲得頁面列表$pagelist = $page_obj -> fpage(array(3,4,5,6,7,8));$i=1;while($rsta = mysql_fetch_assoc($qrya)){ echo "<tr>"; echo "<td>".$i++."</td>"; echo "<td>".$rsta['goods_name']."</td>"; echo "<td>".$rsta['goods_number']."</td>"; echo "<td>".$rsta['goods_price']."</td>"; echo "<td>".date("y-m-d h:i:s",$rsta['goods_create_time'])."</td>"; echo "</tr>";}echo "<tr><td colspan=5>".$pagelist."</td></tr>";echo "</table>"; |
3 ajax無刷新分頁實現
open(‘get','http://網址/index.php?page=2')
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"><html> <head> <title>新建網頁</title> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <meta name="description" content="" /> <meta name="keywords" content="" /> <script type="text/javascript">//獲得分頁信息ajax函數function showpage(myurl){ var xhr = new xmlhttprequest(); xhr.onreadystatechange = function(){ if(xhr.readystate==4){ var rst = document.getelementbyid("result"); rst.innerhtml = xhr.responsetext; } } xhr.open("get",myurl); xhr.send(null);}window.onload = function(){ showpage("./data1.php"); //獲得分頁信息 //showpage("./data.php?page=2");} </script> <style type="text/css"> </style> </head> <body> <h2>ajax無刷新分頁效果</h2> <div id="result"></div> </body></html><script type="text/javascript"> document.write(new date()+"<br />"); document.write(new date()+"<br />"); document.write(new date()+"<br />"); document.write(new date()+"<br />");</script> |
希望本文所述對大家的php程序設計有所幫助。
