快捷導(dǎo)航

無(wú)JS,完全php面向過(guò)程數(shù)據(jù)分頁(yè)實(shí)現(xiàn)代碼

更新時(shí)間：2012年08月27日 22:21:42 作者：

無(wú)JS,完全php面向過(guò)程數(shù)據(jù)分頁(yè)實(shí)現(xiàn)代碼，需要的朋友可以參考下

 
<?php 
//登陸頁(yè)面設(shè)置的session,當(dāng)session中存在name時(shí) 
//session_start(); 
//$name = $_SESSION['name']; 
//if (empty($name)){ 
// header("Location: error.php"); 
// exit(); 
//} 
//面向過(guò)程, 數(shù)據(jù)分頁(yè)顯示 
if(false!=($mysql = mysql_connect('本地mysql', 'mysql用戶(hù)名', 'mysql密碼'))){ 
mysql_query('set names utf8',$mysql); //設(shè)置數(shù)據(jù)庫(kù)中的編碼 
mysql_select_db("數(shù)據(jù)庫(kù)database",$mysql); 
}else{ 
die("連接失敗"); 
} 


$pageSize = 10; //頁(yè)面顯示條數(shù) 
$rowCount = 0; //數(shù)據(jù)總條數(shù),從數(shù)據(jù)庫(kù)獲得 

$sqlCount = 'select count(id) from employee'; 
$res1 = mysql_query($sqlCount,$mysql); 

//取出數(shù)據(jù)條數(shù) 
if(false!=($row=mysql_fetch_row($res1))){ 
$rowCount = $row[0]; 
} 

//總頁(yè)數(shù),通過(guò)計(jì)算得到 
$pageCount = 0; 
$pageCount = ceil($rowCount/$pageSize); 

//獲取當(dāng)前頁(yè) 
if(!isset($_GET['pageNow'])){ // 當(dāng) get/post都為空的時(shí)候賦默認(rèn)值1 
$pageNow = 1; //當(dāng)前頁(yè)數(shù) 
}elseif(false!=is_numeric($_GET['pageNow']) && $_GET['pageNow']<=$pageCount){ 
$pageNow = $_GET['pageNow']; 
}else{ 
header("Location: ../Error/error.php"); 
exit(); 
} 
//打印分頁(yè)數(shù)據(jù) 
echo "<div style='margin-left:300px;margin-top:1px;'>"; 
echo "<table style='border:1px;border-style:solid;border-width:1px;border-color:green'>"; 
echo "<tr><th>id</th>&nbsp;<th>name</th>&nbsp;<th>age</th>&nbsp;<th>sex</th>&nbsp;<th>birthday</th>&nbsp;<th>編輯雇員</th>&nbsp;<th>刪除雇員</th>&nbsp;</tr>"; 
$sqList = "select id,name,age,sex,birthday from employee limit ".($pageNow-1)*$pageSize.",".$pageSize; 
$res2 = mysql_query($sqList,$mysql); 
while (false!=($row=mysql_fetch_assoc($res2))){ 
echo "<tr><td>{$row['id']}</td>&nbsp;<td>{$row['name']}</td>&nbsp;<td>{$row['age']}</td>&nbsp;<td>{$row['sex']}</td>&nbsp;<td>{$row['birthday']}</td>&nbsp;<td><a href=#>編輯</a></td>&nbsp;<td><a href=#>刪除</a></td></tr>"; 
} 
echo "</table>"; 
//表單控制顯示頁(yè)數(shù) 
echo "<form action='當(dāng)前頁(yè)'>"; 
//上一頁(yè)按鈕 
if($pageNow>1){ 
$pageUp = $pageNow-1; 
echo "<a href='?pageNow=".$pageUp."'>上一頁(yè)</a>&nbsp;"; 
} 

//下一頁(yè)按鈕 
if($pageNow<$pageCount){ 
$pageDown = $pageNow+1; 
echo "<a href='?pageNow=".$pageDown."'>下一頁(yè)</a>&nbsp;<br/>"; 
} 

//后退十頁(yè)按鈕 
if($pageNow-10>0){ 
echo "<a href='?pageNow=".($pageNow-10)."'>&lt;&lt;&lt;</a>&nbsp;"; 
} 


//向本頁(yè)傳遞當(dāng)前顯示的頁(yè)數(shù),并顯示第幾頁(yè)按鈕 
for($i=1;$i<=$pageCount;$i++){ 

if($i>$pageNow-2 && $i<$pageNow+6){ 
if($i!=$pageNow){ 
echo "<a href='?pageNow=".$i."'>第".$i."頁(yè)</a>&nbsp;"; 
} 
} 
} 

//前進(jìn)十頁(yè) 
if($pageNow+10<=$pageCount){ 
echo "<a href='?pageNow=".($pageNow+10)."'>&gt;&gt;&gt;</a>&nbsp;"; 
} 

//顯示當(dāng)前頁(yè)與總頁(yè)數(shù) 
echo "<br/>當(dāng)前頁(yè)".$pageNow."頁(yè)/共".$pageCount."頁(yè)"; 


//跳轉(zhuǎn)頁(yè) 
echo "跳轉(zhuǎn)到:<input type='text' name='pageNow' id='pageNow' style='width:30px;height:20px'/>頁(yè)<input type='submit' style='width:37px;height:20px;font-size:11px;' value='go'/>"; 
echo "</form>"; 
echo "</div>"; 
?> 