都能運行但是每一頁里邊的數(shù)據(jù)不一樣多是因為什么？
都能運行但是每一頁里邊的數(shù)據(jù)不一樣多是因為什么？是哪里有寫錯的地方嗎？
<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è)置數(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();
// 釋放結(jié)果，關(guān)閉鏈接
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>
2017-10-13
可能是數(shù)據(jù)庫查詢語句錯了