PHP中如何做分页显示

最新推荐文章于 2021-04-23 14:04:01 发布

lixiaotong_123

最新推荐文章于 2021-04-23 14:04:01 发布

阅读量9.9k

点赞数 3

分类专栏： php 文章标签： php分页显示

本文链接：https://blog.csdn.net/lixiaotong_123/article/details/79620228

版权

php 专栏收录该内容

7 篇文章 1 订阅

订阅专栏

<?php
header("content-type:text/html;charset=utf-8");
$currentpage = 1;
if(isset($_GET['page']))
$currentpage = $_GET['page'];

//连接数据库
$link = mysql_connect("localhost","root","") or die('连接失败');
mysql_select_db('myschool');
mysql_query('set names utf8');

$sql ="SELECT count(*) as 'count' from student";//查询记录的sql语句
$result = mysql_query($sql);
$arr = mysql_fetch_array($result);
$count = $arr['count'];
$pagesize = 3;
$pages = ceil($count/$pagesize);//共多少页

$prepage = $currentpage -1;
if($prepage<=0)
$prepage=1;

$nextpage = $currentpage+1;
if($nextpage >= $pages){
$nextpage = $pages;
}

$start =($currentpage-1) * $pagesize;//起始位置
$sql = "SELECT * from student limit $start,$pagesize";
echo $sql;

// $sql = "select * from student";
$result = mysql_query($sql);
?>

//html部分
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>
<table border="1">
<tr>
<td>学号</td>
<td>姓名</td>
<td>性别</td>
<td>年龄</td>
</tr>
<?php while($arr=mysql_fetch_array($result)){ ?>
<td><?php echo $arr['number']; ?></td>
<td><?php echo $arr['name']; ?></td>
<td><?php echo $arr['sex']; ?></td>
<td><?php echo $arr['age']; ?></td>
</tr>
<?php } ?>
</table>
<a href="<?php echo $_SERVER['PHP_SELF'].'?page='.$prepage; ?>">上一页</a>  <a href="<?php echo $_SERVER['PHP_SELF'].'?page='.$nextpage; ?>">下一页</a>
</body>

</html>

//当一个文件中有php和html两种时，php文件必须有结束标记

lixiaotong_123

关注

3
点赞
踩
13

收藏

觉得还不错? 一键收藏
0
评论
PHP中如何做分页显示

&lt;?phpheader("content-type:text/html;charset=utf-8");$currentpage = 1;if(isset($_GET['page'])) $currentpage = $_GET['page'];//连接数据库$link = mysql_connect("localhost","root","") or die('连接失败');mysq...
复制链接

扫一扫

专栏目录