mysql 分页 pagesize_当参数值pagesize改变时，每一个分页页面都需要刷新一次才能成为当前参数值，为什么？...

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;

}

// 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 "

";

echo "

echo "

usernamepassword";

while ($row = mysql_fetch_assoc($result)) {

// echo $row['id'].'-'.$row['name'].'
';

echo "

";

echo "

{$row['username']}";

echo "

{$row['password']}";

echo "

";

}

echo "

";

echo "

";

// 获取数据总条数

$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 = "

";

// 显示偏移量

$pageoffset = ($showpage - 1) / 2;

// 初始化数据

$start = 1;

$end = $total_pages;

if ($page > 1) {

$page_banner .= "首页";

$page_banner .= "";

} else {

$page_banner .= "首页";

$page_banner .= "上一页";

}

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 .= "{$i}";

} else {

$page_banner .= "{$i}";

}

}

//尾部省略

if ($total_pages > $showpage && $total_pages > $page + $pageoffset) {

$page_banner .= "...";

}

if ($page < $total_pages) {

$page_banner .= "下一页>";

$page_banner .= "尾页";

} else {

$page_banner .= "下一页";

$page_banner .= "尾页";

}

$page_banner .= "共{$total_pages}页";

$page_banner .= "

";

$page_banner .= "到第页";

$page_banner .= "";

$page_banner .= "

";

echo $page_banner;

?>