
//?獲取數據總數
$total_sql?=?"SELECT?COUNT(*)?FROM?users";
$total_result?=?mysql_fetch_array(mysql_query($total_sql))?;
$total?=?$total_result[0];
//?echo?"總條數".$total;exit;
//?計算頁數
$total_pages?=?ceil($total/10);??//向上取一?向下取一?floor
mysql_close($conn);?
//3?顯示數據?+?分頁條
$page_banner?=?"<div?class='page'>";
//計算偏移量
$pageoffset?=?($showPage-1)/2;
if?($page?>?1)?{
$page_banner?.=?"<a?href='".$_SERVER['PHP_SELF']."?p=1'>首頁</a>";
$page_banner?.=?"<a?href='".$_SERVER['PHP_SELF']."?p=".($page-1)."'><上一頁</a>";
}else?{
$page_banner?.=?"<span?class='disable'>首頁</span>";
$page_banner?.=?"<span?class='disable'><上一頁</span>";
}
//?初始化數據
$start?=?1;
$end?=?$total_pages;
if?($total_pages?>?$showPage)?{ //分情況討論
if?($page?>?$pageoffset?+?1)?{
$page_banner?.=?"...";
}
if?($page?>?$pageoffset)?{
$start?=?$page?-?$pageoffset;
$end?=?$total_pages?>?$page?+?$pageoffset???$page?+?$pageoffset?:?$total_pages;
}else?{
$start?=?1;
$end?=?$total_pages?>?$showPage???$showPage?:?$total_pages;
}
if?($page?+?$pageoffset?>?$total_pages)?{
$start?=?$start?-?($page?+?$pageoffset?-?$end);
}
}
for?($i=$start;?$i?<?$end;?$i++)?{?
if?($page?==?$i)?{?????????????//如果當前頁碼等于顯示出的頁碼相等
$page_banner?.=?"<span?class='current'>$i</span>";
}else{
$page_banner?.=?"<a?href='".$_SERVER['PHP_SELF']."?p=".$i."'>{$i}</a>";
}
}
//尾部省略號
if?($total_pages?>?$showPage?&&?$total_pages?>?$page?+?$pageoffset)?{
$page_banner?.=?"...";
}
if?($page?<?$total_pages)?{
$page_banner?.=?"<a?href='".$_SERVER['PHP_SELF']."?p=".($page+1)."'>下一頁></a>";
$page_banner?.=?"<a?href='".$_SERVER['PHP_SELF']."?p=".($total_pages)."'>尾頁</a>";
}else?{
$page_banner?.=?"<span?class='disable'>尾頁</span>";
$page_banner?.=?"<span?class='disable'>下一頁></span>";
}
$page_banner?.=?"共{$total_pages}頁,";
//?跳轉頁碼
$page_banner?.=?"<form?action='mypage.php'?method='get'>";
$page_banner?.=?"到第<input?type='text'?size='2'?name='p'>頁";
$page_banner?.=?"<input?type='submit'?value='確定'>";
$page_banner?.=?"</form></div>";
echo?"$page_banner";
?>
2015-12-08
發現問題了for 循環里少了個=號