<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
<html xmlns="">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<style type="text/css">
*{
margin:0;
padding:0;
}
#lay{
margin:100px 100px 100px 100px;
}
a{
padding:5px;
font-size:13px;
text-decoration:none;
}
span{
font-size:13px;
}
table{
border:1px solid red;
border-collapse:collapse;
}
</style>
id
值
$link = mysql_connect("localhost","root",""); //連接數(shù)據(jù)庫(kù)
mysql_select_db("cs");//選擇哪個(gè)數(shù)據(jù)庫(kù)
mysql_query("set names utf-8"); //設(shè)置數(shù)據(jù)庫(kù)字符編碼為中文
$sql = mysql_query("select *from persons");
$pagesize = 5; //顯示條數(shù)
$sum = mysql_num_rows($sql); //判斷 一共有多少條數(shù)據(jù)
$count = ceil($sum/$pagesize);//求出一共有多少頁(yè)
$pages = $count; //顯示最后一頁(yè)
$init = 1;
$page_len = 7;
$max_p = $count;
if(empty($_GET["page"])|| $_GET["page"]<0){
$page = 1;
}else{
$page = $_GET["page"];
}
$off = ($page-1)*$pagesize; //求出數(shù)據(jù)庫(kù)查詢的第一個(gè)數(shù)據(jù)
$he = mysql_query("select * from persons limit $off,$pagesize");//按照off開(kāi)始，到pagesize規(guī)律顯示
echo "一共 ".$sum." 條數(shù)據(jù)";
while($row = mysql_fetch_array($he)){
echo "";
echo "".$row['id']."";
echo "".$row['FirstName']."";
echo " ";
}
?>
$page_len = ($page_len%2)?$page_len:$page_len+1;//如果余為1則為真，為0則為假
$pageoffset = ($page_len-1)/2;//頁(yè)碼偏移量
$key ="";
if($page!=1){
$key.="第一頁(yè) ";
$key.="上一頁(yè) ";
}else{
$key.="第一頁(yè) ";
$key.="上一頁(yè) ";
}
if($pages>$page_len){
if($page<=$pageoffset){
$init=1;
$max_p = $page_len;
}else{
if($page+$pageoffset>=$pages+1){
$init = $pages - $page_len+1;
}else{
$init = $page-$pageoffset;
$max_p = $page + $pageoffset;
}
}
}
for($i=$init;$i<=$max_p;$i++){
if($i==$page){
$key.="[ ".$i." ]";
}else{
$key.="$i";
}
}
if($i-1!=$page){
$key.="下一頁(yè)";
$key.="最后一頁(yè)";
}else{
$key.="下一頁(yè)";
$key.="最后一頁(yè)";
}
echo "";
echo "".$key."";
echo "";
?>