本文實例講述了PHP+ajax分頁實現方法。分享給大家供大家參考,具體如下:
HTML代碼如下:
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
|
<html> <head> <meta http-equiv= "Content-Language" content= "en" /> <meta name= "GENERATOR" content= "PHPEclipse 1.0" /> <meta http-equiv= "Content-Type" content= "text/html; charset=GB2312" /> <title>title</title> <mce:script type= 'text/javascript' ><!-- var http_request= false ; function send_request(url){ //初始化,指定處理函數,發送請求的函數 http_request= false ; //開始初始化XMLHttpRequest對象 if (window.XMLHttpRequest){ //Mozilla瀏覽器 http_request= new XMLHttpRequest(); if (http_request.overrideMimeType){ //設置MIME類別 http_request.overrideMimeType( "text/xml" ); } } else if (window.ActiveXObject){ //IE瀏覽器 try { http_request= new ActiveXObject( "Msxml2.XMLHttp" ); } catch (e){ try { http_request= new ActiveXobject( "Microsoft.XMLHttp" ); } catch (e){} } } if (!http_request){ //異常,創建對象實例失敗 window.alert( "創建XMLHttp對象失敗!" ); return false ; } http_request.open( "GET" ,url, true ); http_request.onreadystatechange=processrequest; //確定發送請求方式,URL,及是否同步執行下段代碼 http_request.send( null ); } //處理返回信息的函數 function processrequest(){ if (http_request.readyState==4){ //判斷對象狀態 if (http_request.status==200){ //信息已成功返回,開始處理信息 document.getElementById( 'result' ).innerHTML=http_request.responseText; } else { //頁面不正常 alert( "您所請求的頁面不正常!" ); } } } function dopage(url) { document.getElementById( 'result' ).innerHTML= "正在讀取數據..." ; send_request(url); } // --></mce:script> </head> <body bgcolor= "#FFFFFF" text= "#000000" link= "#FF9966" vlink= "#FF9966" alink= "#FFCC99" > <div id= 'result' > </div> </body> </html> |
php代碼如下:
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
|
header( "Content-type: text/html;charset=GBK" ); // $link =mysql_connect( 'localhost' , 'root' , 'root' ); mysql_select_db( 'test' ); mysql_query( "SET NAMES 'GBK'" ); $num =5; //每頁顯示5條 $sql = "select * from article " ; //總共有多少記錄 $resultt =mysql_query( $sql ); //獲取數據庫總記錄數 $total =mysql_num_rows( $result ); echo $total ; //總共有多少頁 $pagecount = $total / $num ; //獲取當前頁 $currentPage =isset( $_GET [ 'page' ])? intval ( $_GET [ 'page' ]):1; //查詢條數 $offset =( $currentPage -1)* $num ; //下一頁 $nexpage =( $currentPage == $pagecount ?0: $currentPage +1); //上一頁 $prepg = $currentPage -1; $url = 'ajax.php' ; //根據條數查詢信息 $strSQL = "select * from article limit $offset,$num" ; $pagecontrol = "當前第" . $currentPage . "頁" ; $pagecontrol .= "共" . $pagecount . "頁" ; $pagecontrol .= "<a href=" javascript:dopage( " mce_href=" javascript:dopage( "'$url?page=1')>首 頁</a> " ; if ( $prepg ) $pagecontrol .= " <a href=" javascript:dopage( " mce_href=" javascript:dopage( "'$url?page=$prepg');>上一頁</a> " ; else $pagecontrol .= " 上一頁 " ; if ( $nexpage ) $pagecontrol .= "<a href=" javascript:dopage( " mce_href=" javascript:dopage( "'$url?page=$nexpage');>下一頁</a>" ; else $pagecontrol .= "下一頁" ; $pagecontrol .= "<a href=" javascript:dopage( " mce_href=" javascript:dopage( "'$url?page=$pagecount')>尾 頁</a>" ; $result1 =mysql_query( $strSQL ); echo "<table border=1 width=100%>" ; echo "<tr>" ; echo "<td>編 號</td><td>標 題</td><td>新聞類型</td>" ; echo "</tr>" ; while ( $row =mysql_fetch_array( $result1 )) { echo "<tr>" ; echo "<td>$row[id]</td><td>$row[title]</td><td>$row[classname]</td>" ; echo "</tr>" ; } echo "</table>" ; echo "<br/>" ; echo $pagecontrol ; |
希望本文所述對大家PHP程序設計有所幫助。