收藏
批改状态：合格
老师批语：
html：
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>函数封装</title>
<style>
table,th,td{
border: 1px solid black;
text-align: center;
}
table{
border-collapse: collapse;
width: 80%;
margin:30px auto;
}
th{
background-color: #00f07f;
}
h3{
text-align: center;
}
a{
margin-left: 10px;
text-decoration: none;
border: 1px solid black;
background-color: lightgreen;
display: inline-block;
min-width: 30px;
height: 30px;
padding: 0 10px;
line-height: 30px;
}
a:hover,.active{
color: white;
background-color: red;
}
form{
display: inline-block;
}
</style>
</head>
<body>
<?php
//连接数据库
require 'lib/func_page.php';
$db = mysqli_connect('127.0.0.1','root','root','php');
$page = isset($_GET['p']) ? ($_GET['p']) : 1;
$num =5;
$table = 'staff';
$data = func_page($db,$table,$page,$num);
$rows = $data['rows'];
$pages = $data['pages'];
//如果当前是第0页
$page = ($page==0) ? 1 : $page;
//如果是最后一页
$page = ($page>$pages) ? $pages : $page;
?>
<table>
<caption><h2>员工信息表</h2></caption>
<tr>
<th>id</th>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
<th>电话码号</th>
</tr>
<?php foreach ($rows as $row) : ?>
<tr>
<td><?php echo $row['id'] ?></td>
<td><?php echo $row['name'] ?></td>
<td><?php echo $row['sex'] ?></td>
<td><?php echo $row['age'] ?></td>
<td><?php echo $row['phone_number'] ?></td>
</tr>
<?php endforeach;?>
</table>
<h3>
<?php if($page != 1) :?>
<a href="http://www.demo.com/demo/php/0427/demo6.php">首页</a>
<a href="http://www.demo.com/demo/php/0427/demo6.php?p=<?php echo $page; ?>">上一页</a>
<?php endif;?>
<!-- 中间页码-->
<?php for ($i=1;$i<=$pages;$i++) : ?>
<a class="<?php if($page==$i) echo 'active'; ?>" href="http://www.demo.com/demo/php/0427/demo6.php?p=<?php echo $i; ?>"><?php echo $i; ?></a>
<?php endfor;?>
<?php if($page != $pages) :?>
<a href="http://www.demo.com/demo/php/0427/demo6.php?p=<?php echo $page; ?>">下一页</a>
<a href="http://www.demo.com/demo/php/0427/demo6.php?p=<?php echo $pages; ?>">尾页</a>
<?php endif;?>
<form action="" method="get">
第 <select name="p">
<?php for ($i=1;$i<=$pages;$i++) : ?>
<option value="<?php echo $i; ?>" <?php if($page==$i) echo 'selected';?>><?php echo $i; ?></option>
<?php endfor;?>
</select>页
<button>跳转</button>
</form>
</h3>
</body>点击 "运行实例" 按钮查看在线实例
函数页：
<?php
/医院
* 分页函数
*/
if(!function_exists('func_page'))
{
function func_page($db,$table,$page,$num=5)
{
$offset = ($page-1)*$num;
$sql = "SELECT * FROM {$table} LIMIT {$offset},{$num};";
$res = mysqli_query($db,$sql);
$rows = mysqli_fetch_all($res,MYSQLI_ASSOC);
//计算表的总页数
$number = mysqli_query($db,"SELECT COUNT(*) FROM {$table}");
list($total) = mysqli_fetch_row($number);
$pages = ceil($total / $num);
//返回当前分页的结果集和总页数
return ['rows'=>$rows,'pages'=>$pages];
}
}点击 "运行实例" 按钮查看在线实例
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
