分頁美化里面 我CSS樣式只有第一頁起作用 其他頁無效果是什么原因呢
<!DOCTYPE?html?PUBLIC?"-//W3C//DTD?XHTML?1.0?Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html?xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>分頁</title>
<meta?name="keywords"?content="分頁設計">
<meta?name="description"?content="分頁">
<meta?name="author"?content="慕課">
<meta?http-equiv="content-type"?content="text/html;charset=UTF-8">
<link?rel="stylesheet"?type="text/css"?href="page.css">
</head>
<body>
<?php
header("Content-Type:text/html;charset=UTF-8");
//1傳入頁碼
$page=$_GET['p'];
//2根據頁碼取出數據：php->mysql處理
$host="localhost";
$username="root";
$password="";
$db="imooc";
$pageSize=3;//每頁顯示條數
$showPage=5;//顯示頁碼個數
//鏈接數據庫
$conn=mysql_connect($host,$username,$password);
if(!$conn){
echo?"數據庫鏈接失敗";
exit;
}
//選擇數據庫
mysql_select_db($db);
//設置數據庫編碼格式
mysql_query("set?names?utf8");
//編寫sql獲取分頁數據
//$sql="select?goods_id,goods_name,goods_price?from?tdb_goods?order?by?goods_id?limit"?.($page-1)*10.?",10";
$sql="select?goods_id,goods_name,goods_price?from?tdb_goods?order?by?goods_id?limit?".(($page-1)*$pageSize).",{$pageSize}";
//把sql語句傳到數據庫
$result=mysql_query($sql);
//處理數據
echo?"<div?class='content'>";
echo?"<table?border=1?cellspacing=0?width=60%??align=center>";
echo?"<caption><h1>商品表</h1></caption>";
echo?'<th>商品ID</th>';
echo?'<th>商品名稱</th>';
echo?'<th>商品價格</th>';
echo?'</tr>';
while($row=mysql_fetch_assoc($result)){
//echo?$row["goods_id"].'-'.$row["goods_name"]."<br>";
echo?"<tr>";
echo?"<td>{$row['goods_id']}</td>";
echo?"<td>{$row['goods_name']}</td>";
echo?"<td>{$row['goods_price']}</td>";
echo?"</tr>";
}
echo?"</table>";
echo?"</div>";
//釋放結果?關閉連接
mysql_free_result($result);
//獲取數據總數
$total_sql="select?count(*)?from?tdb_goods";
$total_result=mysql_fetch_array(mysql_query($total_sql));
$total=$total_result[0];
/*$result=mysql_query("select?*?from?tdb_goods");
????$total=mysql_num_rows($result);*/
//計算頁數
$total_page=ceil($total/$pageSize);
//echo?"總條數{$total}";exit;
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>";
}
//初始化數據
$start=1;//哪一條開始顯示頁碼
$end=$total_page;
if($total_page>$showPage){
if($page>$pageoffset+1){
$page_banner.="...";
}
if($page>$pageoffset){
$start=$page-$pageoffset;
$end=$total_page>$page+$pageoffset?$page+$pageoffset:$total_page;
}else{
$start=1;
$end=$total_page>$showPage?$showPage:$total_page;
}
if($page+$pageoffset>$total_page){
$start=$start-($page+$pageoffset-$end);
//$end=$total_page;
}
}
for($i=$start;$i<=$end;$i++){
$page_banner.="<a?href='".$_SERVER['PHP_SELF']."?p=".$i."'>{$i}</a>";
}
//尾部省略
if($total_page>$showPage&&$total_page>$page+$pageoffset){
$page_banner.="...";
}
//$page_banner.="<a?href='".$_SERVER['PHP_SELF']."?p=".($page-1)."'>上一頁</a>";
//$page_banner.="<a?href='".$_SERVER['PHP_SELF']."?p=".($page+1)."'>下一頁</a>";
if($page<$total_page){
$page_banner.="<a?href='".$_SERVER['PHP_SELF']."?p=".($page+1)."'>下一頁</a>";
$page_banner.="<a?href='".$_SERVER['PHP_SELF']."?p={$total_page}'>尾頁</a>";
}
$page_banner.="共{$total_page}頁;";
$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;
?>
</body>
</html>page.css:
div.page a{
border:#aaaadd 1px solid;
text-decoration:none;
}
2016-05-24
我自己找到原因了 ?我暈 ?我第79行的$page_banner.= ?少了一個拼接. ?導致出錯 。出現和我一樣情況的 注意一下?$page_banner.=是不是沒加.
2016-05-24
<!DOCTYPE?html?PUBLIC?"-//W3C//DTD?XHTML?1.0?Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html?xmlns="http://www.w3.org/1999/xhtml"> <head> <title>分頁</title> <meta?name="keywords"?content="分頁設計"> <meta?name="description"?content="分頁"> <meta?name="author"?content="慕課"> <meta?http-equiv="content-type"?content="text/html;charset=UTF-8"> <link?rel="stylesheet"?type="text/css"?href="page.css"> </head> <body> <?php header("Content-Type:text/html;charset=UTF-8"); //1傳入頁碼 $page=$_GET['p']; //2根據頁碼取出數據：php->mysql處理 $host="localhost"; $username="root"; $password=""; $db="imooc"; $pageSize=3;//每頁顯示條數 $showPage=5;//顯示頁碼個數 //鏈接數據庫 $conn=mysql_connect($host,$username,$password); if(!$conn){ echo?"數據庫鏈接失敗"; exit; } //選擇數據庫 mysql_select_db($db); //設置數據庫編碼格式 mysql_query("set?names?utf8"); //編寫sql獲取分頁數據 //$sql="select?goods_id,goods_name,goods_price?from?tdb_goods?order?by?goods_id?limit"?.($page-1)*10.?",10"; $sql="select?goods_id,goods_name,goods_price?from?tdb_goods?order?by?goods_id?limit?".(($page-1)*$pageSize).",{$pageSize}"; //把sql語句傳到數據庫 $result=mysql_query($sql); //處理數據 echo?"<div?class='content'>"; echo?"<table?border=1?cellspacing=0?width=60%??align=center>"; echo?"<caption><h1>商品表</h1></caption>"; echo?'<th>商品ID</th>'; echo?'<th>商品名稱</th>'; echo?'<th>商品價格</th>'; echo?'</tr>'; while($row=mysql_fetch_assoc($result)){ //echo?$row["goods_id"].'-'.$row["goods_name"]."<br>"; echo?"<tr>"; echo?"<td>{$row['goods_id']}</td>"; echo?"<td>{$row['goods_name']}</td>"; echo?"<td>{$row['goods_price']}</td>"; echo?"</tr>"; } echo?"</table>"; echo?"</div>"; //釋放結果?關閉連接 mysql_free_result($result); //獲取數據總數 $total_sql="select?count(*)?from?tdb_goods"; $total_result=mysql_fetch_array(mysql_query($total_sql)); $total=$total_result[0]; /*$result=mysql_query("select?*?from?tdb_goods"); ????$total=mysql_num_rows($result);*/ //計算頁數 $total_page=ceil($total/$pageSize); //echo?"總條數{$total}";exit; 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_page; if($total_page>$showPage){//總頁數大于顯示頁數?如總頁數就是5頁?顯示也是5頁 if($page>$pageoffset+1){//如果當前頁大于了偏移量（這里是2）+1，則前面的用...代替 $page_banner.="..."; } if($page>$pageoffset){//如果當前頁大于了偏移量 $start=$page-$pageoffset; $end=$total_page>$page+$pageoffset?$page+$pageoffset:$total_page; }else{ $start=1; $end=$total_page>$showPage?$showPage:$total_page; } if($page+$pageoffset>$total_page){ $start=$start-($page+$pageoffset-$end); //$end=$total_page; } } 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_page>$showPage&&$total_page>$page+$pageoffset){ $page_banner.="..."; } //$page_banner.="<a?href='".$_SERVER['PHP_SELF']."?p=".($page-1)."'>上一頁</a>"; //$page_banner.="<a?href='".$_SERVER['PHP_SELF']."?p=".($page+1)."'>下一頁</a>"; if($page<$total_page){//如果是尾頁?則不顯示下一頁尾頁 $page_banner.="<a?href='".$_SERVER['PHP_SELF']."?p=".($page+1)."'>下一頁></a>"; $page_banner.="<a?href='".$_SERVER['PHP_SELF']."?p={$total_page}'>尾頁</a>"; }else{ $page_banner.="<span?class='disable'>下一頁></span>"; $page_banner.="<span?class='disable'>尾頁</span>"; } $page_banner.="共{$total_page}頁;"; $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>"; $page_banner.="</div>"; echo?$page_banner; ?> </body> </html>page.css：
body,html{ padding:0px; margin:0px;font-family:"宋體",Arial,Lucida,Verdana,Helvetica,sans-serif; font-size:12px;width:100%;} ? ?
h1,h2,h3,h4,h5,h6,ul,li,dl,dt,dd,form,img,p,label{margin:0; padding:0; border:none; list-style-type:none;} ? ?
div.page{
text-align:center;
}
div.content{
height:300px;
}
div.page a{
border:#aaaadd 1px solid;
padding:2px 5px 2px 5px;
margin:2px;
text-decoration:none;
}
div.page span.current{
border:#000099 1px solid;
background:#000099;
padding:4px 6px 4px 6px;
margin:2px;
color:#fff;
font-weight:bold;
}
div.page span.disable{
border:1px solid ;
padding:2px 5px 2px 5px;
margin:2px;
color:#ddd;
}
div.page form{
display:inline;
}