当参数值pagesize改变时，每一个分页页面都需要刷新一次才能成为当前参数值，为什么？
<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'];
// 根据页码取出数据
$pagesize = 6;//
$showpage = 5;
// 连接数据库
$conn = mysql_connect("localhost","root", "root");
if (! $conn) {
echo "数据库链接失败";
exit();
}
// 选择所要操作的数据库
mysql_select_db("test",$conn);
// 设置数据库编码格式
mysql_query("SET NAMES UTF8");
// 编写sql获取分页数据 select * from 表名 limit起始位置 显示条数
$sql = "SELECT*FROM page LIMIT " . (($page - 1) * $pagesize) . ",6";
// 把sql语句传入数据
$result = mysql_query($sql);
// 处理数据
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>";
// 获取数据总条数
$total_sql = "SELECT COUNT(*) FROM page";
$total_result = mysql_fetch_array(mysql_query($total_sql));
$total = $total_result[0];
// 计算页数
$total_pages = ceil($total / $pagesize);
//exit();
// 释放结果，关闭链接
mysql_free_result($result);
mysql_close($conn);
// 显示数据+分页条
$page_banner = "<div class='page'>";
// 显示偏移量
$pageoffset = ($showpage - 1) / 2;
// 初始化数据
$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>
qq_責责_01回答
-
MR帽子先生
原因很简单，一般在改变之后你要进行一次重新异步加载来直接改变页面显示数目，但是在你的代码中没有进行异步加载，所以需要手动刷新才可以，希望对你有帮助，祝你学习愉快。
随时随地看视频慕课网APP
PHP