<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /></head><style type="text/css">body {font-size-12px;}div.page {text-align: center}div.content {height: 300px;}div.page a {?border: 1px solid;text-decoration: none;padding: 2px 5px 2px 5px;margin: 2px;}div.page span.current {border: 1px soild #black;background-color: #000099;padding: 4px 6px 4px 6px;margin: 2px;color: #fff;}div.page span.disable {border: 1px soild #blue;padding: 2px 5px 2px 5px;margin: 2px;color: #ddd;}div.page form {display: inline;}</style><body><?php// header("Content-type:text/html;charset=utf-8");// 傳入頁碼if(empty($_GET['p'])){? ? $page = 1;}else{? ? $page = $_GET['p'];}//$page = $_GET['p'];// 根據(jù)頁碼取出數(shù)據(jù)$pagesize = 6;//$showpage = 5;// 連接數(shù)據(jù)庫$conn = mysql_connect("localhost","root", "root");if (! $conn) {? ? echo "數(shù)據(jù)庫鏈接失敗";? ? exit();}// 選擇所要操作的數(shù)據(jù)庫mysql_select_db("test",$conn);// 設置數(shù)據(jù)庫編碼格式mysql_query("SET NAMES UTF8");// 編寫sql獲取分頁數(shù)據(jù) ?select * from 表名 ?limit起始位置 ?顯示條數(shù)$sql = "SELECT*FROM page LIMIT " . (($page - 1) * $pagesize) . ",6";// 把sql語句傳入數(shù)據(jù)$result = mysql_query($sql);// 處理數(shù)據(jù)echo "<div class='content'>";echo "<table border=1 cellspacing=0 width=40% ?align=center>";echo "<tr><td>username</td><td>password</td></tr>";while ($row = mysql_fetch_assoc($result)) {? ? // echo $row['id'].'-'.$row['name'].'<br>';? ? echo "<tr>";? ? echo "<td>{$row['username']}</td>";? ? echo "<td>{$row['password']}</td>";? ? echo "</tr>";}echo "</table>";echo "</div>";// 獲取數(shù)據(jù)總條數(shù)$total_sql = "SELECT COUNT(*) FROM page";$total_result = mysql_fetch_array(mysql_query($total_sql));$total = $total_result[0];// 計算頁數(shù)$total_pages = ceil($total / $pagesize);//exit();// 釋放結果，關閉鏈接mysql_free_result($result);mysql_close($conn);// 顯示數(shù)據(jù)+分頁條$page_banner = "<div class='page'>";// 顯示偏移量$pageoffset = ($showpage - 1) / 2;// 初始化數(shù)據(jù)$start = 1;$end = $total_pages;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'>首頁</a></span>";? ? $page_banner .= "<span class='disable'>上一頁</a></span>";}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'>下一頁</a></span>";? ? $page_banner .= "<span class='disable'>尾頁</a></span>";}$page_banner .= "共{$total_pages}頁";$page_banner .= "<form action='select.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>
1 回答
已采納
MR帽子先生
TA貢獻245條經(jīng)驗 獲得超106個贊
原因很簡單，一般在改變之后你要進行一次重新異步加載來直接改變頁面顯示數(shù)目，但是在你的代碼中沒有進行異步加載，所以需要手動刷新才可以，希望對你有幫助，祝你學習愉快。
- 1 回答
- 0 關注
- 1997 瀏覽
添加回答
舉報
0/150
提交
取消