Home > Article > Backend Development > thinkphp implementation of array paging example_PHP tutorial
Paging is implemented under the thinkphp framework . The company's website is based on the Thinkphp framework. I have been hearing about thinkphp for a long time and finally had the opportunity to put it into practice. thinkphp is based on MVC architecture. MVC is familiar to any ITers, model-view-controller. It handles logic and data separately, eliminating a lot of tedious processes. In fact, the official information has introduced in detail how to paginate, portal: http://document.thinkphp.cn/manual_3_2.html#data_page
, but it does not apply when the data has been taken out from the DB. And when converting to an array, I have been exposed to PHP for a full 2 months, and I have been exposed to thinkphp for only 3 weeks. I spent a lot of time on official documents to get familiar with thinkphp. It can be regarded as a worker who sharpens his sword and chops firewood. Here the official documents are explained as a comparison:
(only the first method in the document is cited): Using the Page class and the limit method, the code is as follows:
$count= $User->where('status=1')->count();// Query the total number of records that meet the requirements
$Page = new ThinkPage($count,25);//Instantiate the paging class and pass in the total number of records and the number of records displayed on each page (25)
$show = $Page->show();// Display output in paging
// Perform paging data query. Note that the parameters of the limit method must use the attributes of the Page class
$list = $User->where('status=1')->order('create_time')->limit($Page->firstRow.','.$Page->listRows )->select();
$this->assign('list',$list);//Assign data set
$this->assign('page',$show);// Assign paging output
$this->display(); // Output template
The basic idea is to first calculate the total number of records, and then divide the pages according to the set number of records displayed on each page. It can be easily implemented using the Page class encapsulated by Thinkphp. The focus of the implementation is on line 11. The limit method extracts data from the query data according to certain rules. But what should I do if the data has been taken out?
We used the function array_slice() that comes with PHP. The definition is here: http://www.php.net/manual/en/function.array-slice.php
In fact, it is the array version of the limit method. Well, now that the tool is found, implementation is easy. Directly upload the code:
The code has been deleted, only the implementation details are retained.
The getNodeLists method in line 3 retrieves data from the database and assigns it to the array nodelist.
Line 5 count calculates the number of array elements.
Line 6 passes in parameters to the Page class.
The array_slice function on line 7 replaces the limit method. The principle is the same.
Line 9 uses the assign method to assign a value to the template. The definition is here: http://document.thinkphp.cn/manual_3_2.html#assign
The same goes for line 10.
The following is the code in the view:
{$page}
private $config= array(
'header' => 'Total %TOTAL_ROW% records',
'prev' => 'Previous page',
'next' => 'Next page',
'first'=> 'First page',
'last' => '...%TOTAL_PAGE%',
'theme'=> '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%',
Add spaces before and after the page number. Now you can see the effect:
It goes well with the background. Of course, you can set different effects according to your own situation.