|
|
<?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用戶名', '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> <th>name</th> <th>age</th> <th>sex</th> <th>birthday</th> <th>編輯雇員</th> <th>刪除雇員</th> </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> <td>{$row['name']}</td> <td>{$row['age']}</td> <td>{$row['sex']}</td> <td>{$row['birthday']}</td> <td><a href=#>編輯</a></td> <td><a href=#>刪除</a></td></tr>";
}
echo "</table>";
//表單控制顯示頁(yè)數(shù)
echo "<form action='當(dāng)前頁(yè)'>";
//按鈕
if($pageNow>1){
$pageUp = $pageNow-1;
echo "<a href='?pageNow=".$pageUp."'></a> ";
}
//按鈕
if($pageNow<$pageCount){
$pageDown = $pageNow+1;
echo "<a href='?pageNow=".$pageDown."'></a> <br/>";
}
//后退十頁(yè)按鈕
if($pageNow-10>0){
echo "<a href='?pageNow=".($pageNow-10)."'><<<</a> ";
}
//向本頁(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> ";
}
}
}
//前進(jìn)十頁(yè)
if($pageNow+10<=$pageCount){
echo "<a href='?pageNow=".($pageNow+10)."'>>>></a> ";
}
//顯示當(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>";
?>
php技術(shù)：無(wú)JS,完全php面向過(guò)程數(shù)據(jù)分頁(yè)實(shí)現(xiàn)代碼，轉(zhuǎn)載需保留來(lái)源！
鄭重聲明：本文版權(quán)歸原作者所有，轉(zhuǎn)載文章僅為傳播更多信息之目的，如作者信息標(biāo)記有誤，請(qǐng)第一時(shí)間聯(lián)系我們修改或刪除，多謝。
