php教程--案例14（分页显示信息）

最新推荐文章于 2021-03-18 06:42:19 发布

虾米大王

最新推荐文章于 2021-03-18 06:42:19 发布

阅读量857

点赞数 1

分类专栏： php 文章标签：案例

本文链接：https://blog.csdn.net/modern358/article/details/108202736

版权

php 专栏收录该内容

177 篇文章 19 订阅

订阅专栏

<?php
//case 14 分页显示信息

/*
 *建立数据表的sql语句
 *
 * create table emp_info(
    emp_id int unsigned auto_increment primary key,
    emp_name varchar(20) not null,
    emp_dept varchar(20) not null,
    date_birth timestamp not null,
    date_entry timestamp not null
)charset = utf8;

insert into emp_info values(1,'张三','推广部','1980-05-01','2020-01-10');
insert into emp_info values(2,'李四','人资部','1980-05-01','2020-01-10');
insert into emp_info values(3,'王五','公关部','1980-05-01','2020-01-10');
insert into emp_info values(4,'麻六','销售部','1980-05-01','2020-01-10');
insert into emp_info values(5,'小兰','人事部','1989-4-5','2015-1-4');
insert into emp_info values(6,'小新','广告部','1993-8-19','2016-2-24');
insert into emp_info values(7,'小白','财务部','1991-10-5','2017-8-14');
insert into emp_info values(8,'小智','运维部','1978-11-25','2000-3-19');
 *
 */

header('Content-type:text/html;charset=utf8');
//数据库连接
$connect = mysqli_connect('localhost','root','mysql123','test');
//连接失败
if(!$connect)
{
    die('数据库连接失败！'.mysqli_error());
}
//设置字符集
//mysql中字符集是utf8，不是uft-8
mysqli_query($connect,"set names utf8");
//当前页
$page = 1;
//每页容量
$page_size = 2;
//获取记录总数
$res = mysqli_query($connect,"select count(*) from emp_info");
//放入数组
$count = mysqli_fetch_row($res);
//计算最大页数
$max_page = ceil($count[0]/$page_size);
//判断当前页
$page = isset($_GET['page'])?intval($_GET['page']):1;
$page = ($page > $max_page)?$max_page:$page;
$page = ($page < 1)?1:$page;
//分页形成
$page_html = "<a href='".$_SERVER['PHP_SELF']."?page=1'>首页</a>&nbsp;";
$page_html .= "<a href='".$_SERVER['PHP_SELF']."?page=".(($page -1) > 0 ?($page - 1):1)."'>上一页</a>&nbsp;";
$page_html .= "<a href='".$_SERVER['PHP_SELF']."?page=".(($page + 1) < $max_page ?($page + 1):$max_page)."'>下一页</a>&nbsp;";
$page_html .= "<a href='".$_SERVER['PHP_SELF']."?page={$max_page}'>尾页</a>";
//查询语句限制条件
$limit = ($page - 1) * $page_size;
//拼装查询语句
$sql = "select * from emp_info "." limit $limit,$page_size";
$result = mysqli_query($connect,$sql);
$emp_info = array();
while($row = mysqli_fetch_assoc($result))
{
    $emp_info[] = $row;
}

?>

<html>
<head>
    <meta charset="UTF-8">
    <title>员工信息列表</title>
</head>
<body>
<div>员工信息列表</div>
<form method="get" action="">
    <table border="1" cellspacing="0" cellpadding="0" width="50%" style="text-align: center;">
        <tr>
            <th>ID</th>
            <th>姓名</th>
            <th>部门</th>
            <th>出生日期</th>
            <th>入职时间</th>
            <th>相关操作</th>
        </tr>
        <?php
        if(!empty($emp_info))
        {
            foreach ($emp_info as $row1)
            {
                echo "<tr>";
                echo "<td>{$row1['emp_id']}</td>";
                echo "<td>{$row1['emp_name']}</td>";
                echo "<td>{$row1['emp_dept']}</td>";
                echo "<td>{$row1['date_birth']}</td>";
                echo "<td>{$row1['date_entry']}</td>";
                echo "<td><span>编辑&nbsp;&nbsp;删除</span></td>";
                echo "</tr>";
            }
        }
        else
        {
            echo "<tr><td colspan='6'>暂无员工数据！</td></tr>";
        }

        mysqli_free_result($result);
        mysqli_close($connect);

        ?>
    </table>
    <hr>
    <div><?php echo $page_html;?></div>
</form>

</body>
</html>

虾米大王

关注

1
点赞
踩
6

收藏

觉得还不错? 一键收藏
打赏
0
评论
php教程--案例14（分页显示信息）

<?php//case 14 分页显示信息/* *建立数据表的sql语句 * * create table emp_info( emp_id int unsigned auto_increment primary key, emp_name varchar(20) not null, emp_dept varchar(20) not null, date_birth timestamp not null, date_entry timestamp .
复制链接

扫一扫