php ajax分頁實現程式碼分享

代碼如下

複製代碼

CREATE TABLE `tb_user` (   `id` int(10) NOT NULL auto_increment,   `username` varchar(50) NOT NULL,   PRIMARY KEY  (`id`) ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; INSERT INTO `tb_user` VALUES (1, 'aaa'); INSERT INTO `tb_user` VALUES (2, 'bbb'); INSERT INTO `tb_user` VALUES (3, 'ccc'); INSERT INTO `tb_user` VALUES (4, 'ddd'); INSERT INTO `tb_user` VALUES (5, 'eee'); INSERT INTO `tb_user` VALUES (6, 'fff'); INSERT INTO `tb_user` VALUES (7, 'ggg'); INSERT INTO `tb_user` VALUES (8, 'hhh'); INSERT INTO `tb_user` VALUES (9, '����');

ajaxpage.js ~ 1KB

 

代碼如下

複製代碼

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.onreadystatechange=processrequest;     //確定發送請求方式，URL，及是否同步執行下段代碼     http_request.open("GET",url,true);     http_request.send(null);   }   //處理返回資訊的函數   function processrequest(){    if(http_request.readyState==4){//判斷對象狀態      if(http_request.status==200){//資訊已成功返回，開始處理資訊       document.getElementById(reobj).innerHTML=http_request.responseText;      }      else{//頁面不正常       alert("您所請求的頁面不正常！");      }    }   }   function dopage(obj,url){    document.getElementById(obj).innerHTML="正在讀取資料...";    reobj = obj;    send_request(url);    }

php調用代碼

代碼如下

複製代碼

<title>PHP+ajax分頁示範</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <script language="javascript" src="ajaxpage.js"></script> <div id="result"> <?php $terry=mysql_connect("localhost","root","")or die("串連資料庫失敗:".mysql_error()); mysql_select_db("ajaxtest",$terry); mysql_query("set NAMES 'utf8'"); $result=mysql_query("select * from tb_user"); $total=mysql_num_rows($result) or die(mysql_error()); $page=isset($_GET['page'])?intval($_GET['page']):1; $page_size=3; $url='index.php'; $pagenum=ceil($total/$page_size); $page=min($pagenum,$page); $prepage=$page-1; $nextpage=($page==$pagenum?0:$page+1); $pageset=($page-1)*$page_size; $pagenav=''; $pagenav.="顯示第<font color='red'>".($total?($pageset+1):0)."-".min($pageset+5,$total)."</font>記錄&nbsp;共<b><font color='yellow'>".$total."</font></b>條記錄&nbsp;現在是第&nbsp;<b><font color='blue'>".$page."</font></b>&nbsp;頁&nbsp;"; if($page<=1) $pagenav.="<a style=cursor:not-allowed;>首頁</a>&nbsp;"; else $pagenav.="<a onclick=javascript:dopage('result','$url?page=1') style=cursor:pointer;>首頁</a>&nbsp;"; if($prepage) $pagenav.="<a onclick=javascript:dopage('result','$url?page=$prepage') style=cursor:pointer;>上一頁</a>&nbsp;"; else $pagenav.="<a style=cursor:not-allowed;>上一頁</a>&nbsp;"; if($nextpage) $pagenav.="<a onclick=javascript:dopage('result','$url?page=$nextpage') style=cursor:pointer;>下一頁</a>&nbsp;"; else $pagenav.="<a style=cursor:not-allowed;>下一頁</a>&nbsp;"; if($pagenum) $pagenav.="<a onclick=javascript:dopage('result','$url?page=$pagenum') style=cursor:pointer;>尾頁</a>&nbsp;"; else $pagenav.="<a style=cursor:not-allowed;>尾頁</a>&nbsp;"; $pagenav.="共".$pagenum."頁"; if($page>$pagenum){     echo "error:沒有此頁".$page;     exit(); } ?> <table align="center" border="2" width="300">   <tr bgcolor="#cccccc" align="center">     <td>使用者名稱</td>     <td>使用者密碼</td>   </tr> <?php $info=mysql_query("select * from tb_user order by id desc limit $pageset,$page_size"); while($array=mysql_fetch_array($info)){ ?>   <tr align="center">     <td><?php echo $array['id'];?></td>     <td><?php echo $array['username'];?></td>   </tr> <?php    } ?> </table> <?php echo "<p align=center>$pagenav</p>"; ?> </div>

大家使用時只在一段段代碼按我個面的儲存成單個檔案就可以實現了哦。