PHP分页

最新推荐文章于 2021-03-12 19:19:16 发布

从来_没有过

最新推荐文章于 2021-03-12 19:19:16 发布

阅读量458

点赞数

分类专栏： php语言基础文章标签： PHP mysql 分页

本文链接：https://blog.csdn.net/dustin_php/article/details/40663749

版权

php语言基础专栏收录该内容

17 篇文章 0 订阅

订阅专栏

<?php
/*
* Created on 2014-10-31
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
header("Content-Type: text/html;charset=utf-8");
//连接数据库
$conn = @ mysql_connect("localhost:3306", 'root', 'root') or die("数据库服务器连接失败！");
mysql_select_db("phpstu") or die("数据库连接失败");
mysql_set_charset("utf8"); //设置当前连接的默认字符集。

//总记录数
$totalRecord = count(getData("select * from user"));
//当前页
if ($_GET and array_key_exists("page", $_GET) and (int) $_GET["page"] >= 1) {
$currentPage = $_GET["page"] ? (int) $_GET["page"] : 1;
} else {
$currentPage = 1;
}
//每页记录数
$pageSize = 5;
//总页数
$totalPage = ceil($totalRecord / $pageSize);
//组装获取当前页记录的SQL语句
$sql = "select * from user limit " . ($currentPage -1) * $pageSize . "," . $pageSize;
//存储当前页记录的数组
$rows = getData($sql);
//当前页的路径
$url = $_SERVER['PHP_SELF'];

//获取数据库中的数据
function getData($sql) {
$result = @ mysql_query($sql) or die("SQL语句出错，请检查SQL语句！");
$rows = array ();
while ($row = mysql_fetch_array($result)) {
$rows[] = $row;
}
return $rows;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PHP分页实例</title>
<style type="text/css">
table.pageTable{
width:500px;
margin:0 auto;
text-align:center;
font-family: verdana,arial,sans-serif;
font-size:12px;
color:#333333;
border-width: 1px;
border-color: #666666;
border-collapse: collapse;
}
table.pageTable th {
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #666666;
background-color: #dedede;
}
table.pageTable td {
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #666666;
background-color: #ffffff;
}
</style>
</head>
<body>
<table class="pageTable">
<tr><th>ID</th><th>用户名</th><th>密码</th></tr>
<?foreach($rows as $row):?>
<tr><td><?=$row["uid"];?></td><td><?=$row["uname"];?></td><td><?=$row["upassword"];?></td></tr>
<?endforeach;?>
<?if($totalRecord>$pageSize):?>
<tr><td colspan="3">
<? if ($currentPage == 1):?>
首页上一页 <a href="<?=$url?>?page=<?=$currentPage+1?>">下一页</a> <a href="<?=$url?>?page=<?=$totalPage?>">尾页</a>
<?elseif($currentPage == $totalPage): ?>
<a href="<?=$url?>?page=1">首页</a> <a href="<?=$url?>?page=<?=$currentPage-1?>">上一页</a> 下一页尾页
<?else:?>
<a href="<?=$url?>?page=1">首页</a> <a href="<?=$url?>?page=<?=$currentPage-1?>">上一页</a> <a href="<?=$url?>?page=<?=$currentPage+1?>">下一页</a> <a href="<?=$url?>?page=<?=$totalPage?>">尾页</a>
<?endif;?>
</td></tr>
<? endif; ?>
</table>
</body>
</html>

从来_没有过

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
PHP分页

/* * Created on 2014-10-31 * * To change the template for this generated file go to * Window - Preferences - PHPeclipse - PHP - Code Templates */header("Content-Type: text/html;charset=utf
复制链接

扫一扫