標籤：from 資料庫 res size null 姓名 status xmlhttp etc
使用JSON實現分頁可直接用
Fenye.html
<!DOCTYPE html><html><head> <title>JSON分頁</title></head><body><script type="text/javascript">function getPageList(pageno){ var req=new XMLHttpRequest(); req.open(‘get‘,‘./JSON_Fenye.php?pageno=‘+pageno); req.onreadystatechange=function(){ if(req.readyState==4 && req.status==200){ //將傳來的字串轉化為對象 eval(‘var info=‘+req.responseText); var str=‘<tr><th>ID</th><th>姓名</th><th>郵箱</th><th>等級</th></tr>‘; //迴圈取出info對象中的資料 for(var i=0,n=info.length-1;i<n;i++){ str+=‘<tr><td>‘+info[i].id+‘</td><td>‘+info[i].name+‘</td><td>‘+info[i].email+‘</td><td>‘+info[i].level+‘</td></tr>‘; } //分頁連結 str+=‘<tr><td colspan="4" align="center">‘; for(var i=1;i<=info[info.length-1];i++){ str+=‘<a href="javascript:void(0)" onclick="getPageList(‘+i+‘)">‘+i+‘</a> ‘; console.log(i); } str+=‘</td></tr>‘; //把資料輸出到瀏覽器 document.getElementById(‘result‘).innerHTML=str; } } req.send(null);}//預設顯示第一頁window.onload=function(){ getPageList(1);}</script><table id=‘result‘></table></body></html>
Fenye.php
<?php /***JSON分頁*///連結資料庫@mysql_connect(‘localhost‘,‘root‘,‘‘);@mysql_select_db(‘empmanage‘);@mysql_query(‘set name utf8‘);//擷取總記錄數$rs = mysql_query(‘select count(*) from emp‘);$rows = mysql_fetch_row($rs);$recordCount = $rows[0];//每頁顯示多少條pageSize$pageSize = 5;//總頁數 = 總記錄/每頁顯示多少$pageCount=ceil($recordCount/$pageSize);//擷取當前頁 三元運算 若不存在pageNow則預設顯示第1頁$pageNow = isset($_GET[‘pageNow‘])? $_GET[‘pageNow‘]:1;if ($pageNow < 1) { $pageNow = 1;}elseif ($pageNow > $pageCount) { $pageNow = $pageCount;}//起始位置 每頁從第幾條資料顯示$pageStart = ($pageNow-1)*$pageSize;//從哪條開始顯示，限制每頁顯示幾條$sql = "select * from emp limit $pageStart,$pageSize";//連結資料庫$rs = mysql_query($sql);//定義數組，把資料存放在數組中$info = array();while ($rows = mysql_fetch_assoc($rs)) { $info[] = $rows;}//將總頁碼儲存到數組$info[] = $pageCount;echo json_encode($info); ?>
使用JSON實現分頁
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
