快捷導(dǎo)航

php ajax 靜態(tài)分頁過程形式

更新時(shí)間：2011年09月02日 15:25:24 作者：

php ajax 靜態(tài)分頁過程形式,擴(kuò)展性不是很好，但比較適合新手學(xué)習(xí)。

 
js 端 及判斷 
<script language='javascript' > 
$(function(){ 
//var url=$(this)[0].location.href; 
//alert(url); 
goPageFirst(); 
$('#selpage').bind('change',goPage); 
}); 
//返回當(dāng)前頁數(shù) 
function getNowPage() 
{ 
return parseInt($('#nowPage').html()); 
} 
//返回每頁顯示的條數(shù) 
function getPer() 
{ 
return $('#perPage').val(); 
} 
//返回總記錄數(shù) 
function getTotal() 
{ 
return parseInt($('#total').html()); 
} 
//返回總頁數(shù) 
function getAllPage() 
{ 
return parseInt($('#allpage').html()); 
} 
//組合字符串參數(shù) 
function getData(act) 
{ 
var target=1; 
var now=getNowPage()+1; 
var per=getPer(); 
var sum=getTotal(); 
var allpage=getAllPage(); 
switch(act) 
{ 
case 'first': 
target=1; 
break; 
case 'prev': 
target=now>1?now-1:1; 
break; 
case 'next': 
target=now+1>allpage?now:1; 
break; 
case 'last': 
target=allpage>0?allpage:1; 
break; 
case 'constans': 
target=$('#selpage').val()>0?$('#selpage').val():1; 
default : 
target=1; 
} 
var data="check="+act+"&nowpage="+now+"&perpage="+per+'&target='+target; 
alert(data); 
return data; 
} 
//執(zhí)行第一頁 
function goPageFirst() 
{ 
var param=getData('first'); 
http_post(param); 
} 
//執(zhí)行上一頁 
function goPagePrev() 
{ 
var param=getData('prev'); 
http_post(param); 
} 
//執(zhí)行下一頁 
function goPageNext() 
{ 
var param=getData('next'); 
http_post(param); 
} 
//執(zhí)行最后頁 
function goPageLast() 
{ 
var param=getData('last'); 
http_post(param); 
} 
//選中到指定頁面 
function goPage() 
{ 
var param=getData('constans'); 
http_post(param); 
} 
//post 請求數(shù)據(jù)加載 
function http_post(db) 
{ 
$.post('./mysql.php',db,function(data){ 
responseAjax(data); 
},'text'); 
} 
//返回?cái)?shù)據(jù)的調(diào)處理 
function responseAjax(msg) 
{ 
//alert(msg); 
//alert(msg.content); 
//$('#listDiv').html(msg.content); 
$('#listDiv').html(msg); 
} 
server端 判斷及實(shí)現(xiàn) 
//@autor 499188204@qq.com 
mb_internal_encoding('gb2312'); 
$con=mysql_connect("127.0.0.1","root","12345678") or die("連接失敗"); 
$m=mysql_select_db("ec",$con); 
$sql = 'SELECT `attr_id`,`cat_id`,`attr_name` 
FROM `ecs_attribute` '; 
$rs = mysql_query($sql ); 
$count = mysql_num_rows($rs); //返回記錄總數(shù) 
//echo $count; //總記錄數(shù) 
//每頁的記錄數(shù) 10 
//求總頁數(shù) ceil($count/10) 
//echo '<hr >'; 
if(!isset($_POST['check'])) 
{ 
$set['id']=0; 
die('no access please!'); 
} 
if(isset($_POST['perpage']) && $_POST['perpage']>0 ) 
{ 
$per=$_POST['perpage']; 
} 
else 
{ 
$per=15; 
} 
$page = ceil($count/$per); 
//echo $page; 
if(!isset($_POST['nowpage'])) 
{ 
$nowPage=1; 
} 
else 
{ 
$nowPage = $_POST['nowpage']; 
} 
$start = ($nowPage-1)*$per+1; 
$sql = 'select `attr_id`,`cat_id`,`attr_name` from `ecs_attribute` limit '.$start.','. $per; 
//$sql = 'select `attr_id`,`cat_id`,`attr_name` from `ecs_attribute` limit 10 offset 20'; 
$rs = mysql_query($sql ); 

$str = "<table id='content'> 
<tr><th>屬性編號</th><th>類型編號</th><th>屬性名字</th></tr>"; 
while($row = mysql_fetch_assoc($rs)){ 
$str .='<tr><td>'.$row['attr_id'].'</td><td>'.$row['cat_id'].'</td><td>'.$row['attr_name'].'</td><tr>'; 
} 
$str.="</table> 
<table id='page_list'> 
<tr><td><div><span>總計(jì)<span id='total'>".$count."</span>個(gè)記錄分為<span id='allpage'>".$page."</span>頁當(dāng)前第<span id='nowPage'>".$nowPage."</span>頁,每頁<input type='text' id='perPage' value='".$per."'/>&nbsp;|&nbsp; 
<a href='javascript:void(0)' onclick='goPageFirst()'>第一頁</a> 
<a href='javascript:void(0)' onclick='goPagePrev()'>上一頁</a> 
<a href='javascript:void(0)' onclick='goPageFirst()'>下一頁</a> 
<a href='javascript:void(0)' onclick='goPageFirst()'>最末頁 </a> 
<select id='selpage' >"; 
for($i=1;$i <=$page;$i++) 
{ 
if($nowPage==$i) 
{ 
$str .= "<option selected >".$i."</option>"; 
} 
else 
{ 
$str .= "<option >".$i."</option>"; 
} 
} 
$str .="</select> 
</span></div></td></tr> 
</table>"; 
echo mb_convert_encoding($str,'UTF-8','gb2312'); 
//$set['content']=$str; 
//echo json_encode($set); 
?> 