php query paging code-PHP Tutorial-php.cn

php query paging code

陈政宽～

Release： 2023-03-11 20:04:01

Original

1735 people have browsed it

This article mainly introduces the implementation code of PHP query paging in detail. It has certain reference value. Interested friends can refer to it.

The example in this article shares with everyone the PHP query paging code. The specific code, the back-end is based on thinkphp framework, for your reference, the specific content is as follows

The front-end requires the dataTables plug-in: Portal download address

HTML code

The first step is to introduce the plug-in

<!-- DataTables CSS -->
<link rel="stylesheet" type="text/css" href="http://cdn.datatables.net/1.10.15/css/jquery.dataTables.css" rel="external nofollow" >
<!-- jQuery -->
<script type="text/javascript" charset="utf8" src="http://code.jquery.com/jquery-1.10.2.min.js"></script>
<!-- DataTables -->
<script type="text/javascript" charset="utf8" src="http://cdn.datatables.net/1.10.15/js/jquery.dataTables.js"></script>

Copy after login

The second step is to add

<table id="table_id_example" class="display">
 <thead>
 <tr>
  <th>ID</th>
  <th>发布时间</th>
  <th>发布IP</th>
  <th>公告内容</th>
 </tr>
 </thead>
 <tbody>
  <volist name="notice" id="vo">
   <tr>
   <td>{$vo.id}</td>
   <td>{$vo.create_time}</td>
   <td>{$vo.create_ip}</td>
   <td>{$vo.notice_content}</td>
   </tr>
  </volist>
 </tbody>
</table>

Copy after login

The third step is JS

 <script>
 $(document).ready( function () {
  $(&#39;#table_id_example&#39;).DataTable();
 } );
 </script>

Copy after login

PHP code

 public function gonggaochakan(){
 /* 公告查看
  */
 $dbNotice = M(&#39;notice&#39;);//实例化dbNotice对象
 $count  = $dbNotice->count();// 查询满足要求的总记录数
 $Page  = new \Think\Page($count,$count);// 实例化分页类 传入总记录数和每页显示的记录数(全部记录)
 $data = $dbNotice->order(&#39;create_time&#39;)->limit($Page->firstRow.&#39;,&#39;.$Page->listRows)->select();//获得所有记录
 $this->assign(&#39;notice&#39;,$data);//传给模板
 $this->show();
}

Copy after login

Effect