1 <?php
2 try {
3 $dsn = "mysql:host=localhost;dbname=数据库名";
4 $username = "数据库名";
5 $password = "数据库密码";
6 $pdo = new PDO($dsn, $username, $password);
7 } catch(PDOException $e) {
8 echo "Connection failed: " . $e->getMessage();
9 }
10
11 //计算总记录数
12 $total=$pdo->query('SELECT COUNT(1) FROM `表名`')->fetchColumn();
13 //每页显示记录数
14 $pageSize=10;
15 //计算总页数
16 $pageCount=ceil($total/$pageSize);
17 //当前页码,默认为第一页
18 $pageNum=isset($_GET['page']) ? $_GET['page'] : 1;
19 //起始记录数
20 $start=($pageNum-1)*$pageSize;
21 //查询分页数据
22 $sql="SELECT * FROM `表名` LIMIT {$start},{$pageSize}";
23 $stmt=$pdo->query($sql);
24 $list=$stmt->fetchAll(PDO::FETCH_ASSOC);
25 ?>
26
27 <!DOCTYPE html>
28 <html>
29 <head>
30 <meta charset="utf-8">
31 <title>PHP+Layui分页</title>
32 <link rel="stylesheet" >
33 </head>
34 <body>
35 <div class="layui-container">
36 <br>
37 <br>
38 <center>
39 <h3>超简单php+layui分页</h3>
40 </center>
41 <table class="layui-table">
42 <thead>
43 <tr>
44 <th>ID</th>
45 <th>产品名</th>
46 <th>产品库存</th>
47 <th>操作</th>
48 </tr>
49 </thead>
50 <tbody>
51 <?php foreach($list as $vo){ ?>
52 <tr>
53 <td><?php echo $vo['id']; ?></td>
54 <td>产品<?php echo $vo['id']; ?></td>
55 <td>库存<?php echo $vo['id']; ?></td>
56 <td><a href=delete.php?id=<?php echo $vo['id']; ?> </a>删除</td>
57 </tr>
58 <?php } ?>
59 </tbody>
60 </table>
61 <div id="demo"></div>
62 </div>
63 <script src="https://cdn.staticfile.org/layui/2.5.6/layui.min.js"></script>
64 <script>
65 layui.use(['laypage'], function(){
66 var laypage = layui.laypage;
67 laypage.render({
68 elem: 'demo',
69 count: <?php echo $total; ?>,
70 limit: <?php echo $pageSize; ?>,
71 curr: <?php echo $pageNum; ?>,
72 jump: function(obj,first){
73 if(!first){
74 window.location.href = '?page='+obj.curr;
75 }
76 }
77 });
78 });
79 </script>
80 </body>
81 </html>
04-25
2万+
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交