Home  >  Article  >  PHP Framework  >  How to implement the paging function of ThinkPHP6

How to implement the paging function of ThinkPHP6

WBOY
WBOYOriginal
2023-06-20 21:15:142630browse

ThinkPHP is a very popular PHP development framework, and its latest version, ThinkPHP6, has been greatly improved in terms of performance and ease of use. The paging function is a very common function in web development, and ThinkPHP6 also provides a very convenient paging method. This article will introduce how to implement the paging function of ThinkPHP6.

1. Understand the paging function

In web applications, when the data set is very large, displaying all the results on one page will cause the page to load too slowly, and it will also cause the page to load too slowly. It is inconvenient for users to view and manage data. The paging function is to divide the data set into multiple pages, and each page only displays a part of the data. This can greatly reduce page loading time, while also making it easier for users to browse and manage data.

2. Implement the paging function of ThinkPHP6

ThinkPHP6 provides a very convenient paging method, which can be implemented in just a few simple steps.

  1. Install Pagination component

ThinkPHP6 provides a Pagination component. You need to add the following code to the composer.json file:

"require": {
    "topthink/think-pagination": "^1.0"
}

Then use the commandcomposer updateInstall components.

  1. Using paging in the controller

The steps to use paging in the controller are as follows:

First, get the total number of records in the data table. Use the following code:

$total = Db::name('user')->count();

Among them, Db is the database operation class in ThinkPHP6, name('user') means to obtain the data of the user table, and count() means to obtain the total number of data.

Next, set the number of records displayed on each page and the current page number. Use the following code:

$pageSize = 10;   //每页显示10条记录
$pageNo = 1;      //默认显示第1页
if (!empty($_GET['page'])) {
    $pageNo = intval($_GET['page']);   //获取当前页码数
}

Among them, the intval() function is used to convert a string to an integer.

Next, calculate the record range that needs to be displayed based on the number of records displayed on each page and the current page number. Use the following code:

$offset = ($pageNo - 1) * $pageSize;
$rows = Db::name('user')->limit($offset, $pageSize)->select();

Among them, the limit() method is used to limit the range of query results. The first parameter represents the offset, and the second parameter represents the number of records obtained.

Finally, pass the obtained records to the view and call the Pagination component for paging display. Use the following code:

$this->assign('rows', $rows);
$this->assign('total', $total);
$this->assign('pageSize', $pageSize);
$this->assign('pageNo', $pageNo);
return $this->fetch()->extend('pagination');

Among them, the assign() method is used to pass variables to the template, the fetch() method is used to call the template file, and extend('pagination') means to use the Pagination component for pagination display.

  1. Implement paging in the view

The steps to implement paging in the view file are as follows:

First, display the paging bar at the bottom of the page. Use the following code:

<div class="pagination">
    {$page->render()}
</div>

Among them, $page represents the Pagination instance, and the render() method is used to generate pagination HTML code.

Next, set the paging style. Use the following code:

    hinkacadeView::getPager()->setConfig('prev', '上一页');
    hinkacadeView::getPager()->setConfig('next', '下一页');
    hinkacadeView::getPager()->setConfig('theme', '%totalRow% %header% %upPage% %downPage% %first% %prePage% %linkPage% %nextPage% %end%');

Among them, the setConfig() method is used to set the paging style. %totalRow% represents the total number of records displayed, %header% represents the current page number, %upPage% represents the previous page, %downPage% represents the next page, %first% represents the first page, %prePage% represents the previous page number, % linkPage% represents the current page number group, %nextPage% represents the next group of page numbers, and %end% represents the last page.

Note: Before setting the paging style, you need to call use thinkPaginator; namespace.

  1. Complete code example

The following is a complete code example to implement the paging function of ThinkPHP6:

use thinkDb;
use thinkPaginator;

class UserController extends Controller
{
    public function index()
    {
        $total = Db::name('user')->count();
        $pageSize = 10;   //每页显示10条记录
        $pageNo = 1;      //默认显示第1页
        if (!empty($_GET['page'])) {
            $pageNo = intval($_GET['page']);   //获取当前页码数
        }
        $offset = ($pageNo - 1) * $pageSize;
        $rows = Db::name('user')->limit($offset, $pageSize)->select();
        $this->assign('rows', $rows);
        $this->assign('total', $total);
        $this->assign('pageSize', $pageSize);
        $this->assign('pageNo', $pageNo);
        Paginator::useBootstrap();
        Paginator::currentPageResolver(function () use ($pageNo) {
            return $pageNo;
        });
        Paginator::pagination($total, $pageSize, $pageNo);
            hinkacadeView::getPager()->setConfig('prev', '上一页');
            hinkacadeView::getPager()->setConfig('next', '下一页');
            hinkacadeView::getPager()->setConfig('theme', '%totalRow% %header% %upPage% %downPage% %first% %prePage% %linkPage% %nextPage% %end%');
        return $this->fetch()->extend('pagination');
    }
}

3. Summary

Passed In the above steps, we successfully implemented the paging function of ThinkPHP6. I believe that through the introduction in this article, readers can easily add paging functions to their websites and improve the user experience of the website.

The above is the detailed content of How to implement the paging function of ThinkPHP6. 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