php+aja實現(xiàn)分頁效果

1、1覽文庫-覽【PHP代碼】php+ajax實現(xiàn)分頁效果ajax可以實現(xiàn)無刷新提交，當然也可以實現(xiàn)無刷新分頁，這對于用戶體驗來說是很不錯，好 了，廢話不說，看代碼。ajaxpage.php【這里是數(shù)據(jù)展示頁面的代碼】：vmeta charset= utf-8 vscript src=” HYPERLINK /ajax/libs/jquery/1.4/jquery.min.jS /ajax/libs/jquery/1.4/jquery.min.jS type=”text/javascript” /v/script獲取當前url地址，主要是獲取page參數(shù)，為了不實現(xiàn)跳轉在分頁中采用了錨點連接的方

2、式var url=location.href;uarr=url.indexOf( #);npage=url.substr(uarr+6);if(!npage)npage=1;jQuery(function()$.ajax(type: “POST” ,url: “ajax.php” ,dataType: json，由于ajax返回值是數(shù)組，所以在php腳本中經(jīng)過json編碼data: “page=” +npage,success: function(msg)$( #post_result ).html(msg.page_content);$( #navipage ).html(msg.pagei

3、st););)function url_go(page)$.ajax(type: “POST” ,url: “ajax.php” ,dataType: json,data: “page=” +page,success: function(msg)$( #post_result ).html(msg.page_content);$( #navipage ).html(msg.pageist););1覽文庫覽v/scriptvdiv id=post_result ajax.php【這里是生成數(shù)據(jù)和分頁的代碼】：v?php$host=” localhost” ;$user=” root” ;$pwd

4、=” root” ;$dbname=” test” ;$link = mysql_connect($host, $user, $pwd)or die( “Could not connect: ”. mysql_error();mysql_select_db($dbname, $link) or die ( Can t use test : . mysql_error();mysql_query( “SET NAMES utf8”)；mysql_query( “SET CHARACTER_SET_CLIENT=utf8)；mysql_query( “SET CHARACTER_SET_RESUL

5、TS=utf8)；分頁設置$page=$_REQUESTpage?$_REQUESTpage:l;設置每頁顯示多好條記錄$page_size=2;設置limit偏量$off=($1)*$page_size;獲取總記錄數(shù)$sql_all=” select * from user order by id desc” ;$all_res=mysql_query($sql_all);$total_all=mysql_num_rows($all_res);計算頁面總數(shù)，注意鍵名,當然你也可以使用數(shù)字下標$page_num=ceil($total_all/$page_size);讀取當前頁記錄數(shù)$sql_

6、page=” select * from user order by id desc limit $off,$page_size” ; $page_res=mysql_query($sql_page);while ($arr=mysql_fetch_array($page_res)$ajax_arrpage_content.= id: .$arrid. user: .$arruser. ;for($i=1;$iv=$page_num;$i+)if($i=$page)$ajax_arrpage_list.= .$i.v/fontv/a ;else$ajax_arrpageist.= .$i.v/

7、a ;1覽文庫-覽對數(shù)組進行json編碼，否則ajax無法獲取數(shù)組形式的返回值 echo json_encode($ajax_arr);?這里是sql文件用來生成測試數(shù)據(jù)：-phpMyAdmin SQL Dump-version 339.2- HYPERLINK -主機:localhost-生成日期:2002年01月01日04:57-服務器版本:5.5.9-PHP 版本:5.3.5SET SQL_MODE=” NO_AUTO_VALUE_ON_ZERO” ;/*!40101 SET OLD_CHARACTER_SET_CLIENT=CHARACTER_SET_CLIENT */;/*!4010

8、1 SET OLD_CHARACTER_SET_RESULTS=CHARACTER_SET_RESULTS */;/*!40101 SET OLD_COLLATION_CONNECTION=COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;-數(shù)據(jù)庫:test-表的結構userCREATE TABLE IF NOT EXISTS user (id int(10) unsigned NOT NULL AUTO_INCREMENT,user varchar(6) NOT NULL,pwd varchar(30) NOT NULL,PRIMARY KEY (id)ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;-轉存表中的數(shù)據(jù)userINSERT INTO user