Home  >  Article  >  Backend Development  >  php query paging code

php query paging code

陈政宽~
陈政宽~Original
2017-06-28 13:30:181689browse

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>

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>

The third step is JS

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

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();
}


Effect

The above is the entire content of this article. I hope it will be helpful to everyone’s study and I hope you will support me a lot. Script House.

The above is the detailed content of php query paging code. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn