<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>
1 回答
已采纳
MR帽子先生
TA贡献245条经验 获得超106个赞
原因很简单，一般在改变之后你要进行一次重新异步加载来直接改变页面显示数目，但是在你的代码中没有进行异步加载，所以需要手动刷新才可以，希望对你有帮助，祝你学习愉快。
- 1 回答
- 0 关注
- 1962 浏览
添加回答
举报
0/150
提交
取消