Home PHP Framework ThinkPHP How to implement the paging function of ThinkPHP6

How to implement the paging function of ThinkPHP6

Jun 20, 2023 pm 09:15 PM
thinkphp accomplish Paging function

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"
}
Copy after login

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();
Copy after login

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']);   //获取当前页码数
}
Copy after login

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();
Copy after login

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');
Copy after login

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>
Copy after login

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%');
Copy after login

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');
    }
}
Copy after login

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 of this Website
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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Chat Commands and How to Use Them
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to implement dual WeChat login on Huawei mobile phones? How to implement dual WeChat login on Huawei mobile phones? Mar 24, 2024 am 11:27 AM

How to implement dual WeChat login on Huawei mobile phones? With the rise of social media, WeChat has become one of the indispensable communication tools in people's daily lives. However, many people may encounter a problem: logging into multiple WeChat accounts at the same time on the same mobile phone. For Huawei mobile phone users, it is not difficult to achieve dual WeChat login. This article will introduce how to achieve dual WeChat login on Huawei mobile phones. First of all, the EMUI system that comes with Huawei mobile phones provides a very convenient function - dual application opening. Through the application dual opening function, users can simultaneously

How to run thinkphp project How to run thinkphp project Apr 09, 2024 pm 05:33 PM

To run the ThinkPHP project, you need to: install Composer; use Composer to create the project; enter the project directory and execute php bin/console serve; visit http://localhost:8000 to view the welcome page.

There are several versions of thinkphp There are several versions of thinkphp Apr 09, 2024 pm 06:09 PM

ThinkPHP has multiple versions designed for different PHP versions. Major versions include 3.2, 5.0, 5.1, and 6.0, while minor versions are used to fix bugs and provide new features. The latest stable version is ThinkPHP 6.0.16. When choosing a version, consider the PHP version, feature requirements, and community support. It is recommended to use the latest stable version for best performance and support.

How to run thinkphp How to run thinkphp Apr 09, 2024 pm 05:39 PM

Steps to run ThinkPHP Framework locally: Download and unzip ThinkPHP Framework to a local directory. Create a virtual host (optional) pointing to the ThinkPHP root directory. Configure database connection parameters. Start the web server. Initialize the ThinkPHP application. Access the ThinkPHP application URL and run it.

PHP Programming Guide: Methods to Implement Fibonacci Sequence PHP Programming Guide: Methods to Implement Fibonacci Sequence Mar 20, 2024 pm 04:54 PM

The programming language PHP is a powerful tool for web development, capable of supporting a variety of different programming logics and algorithms. Among them, implementing the Fibonacci sequence is a common and classic programming problem. In this article, we will introduce how to use the PHP programming language to implement the Fibonacci sequence, and attach specific code examples. The Fibonacci sequence is a mathematical sequence defined as follows: the first and second elements of the sequence are 1, and starting from the third element, the value of each element is equal to the sum of the previous two elements. The first few elements of the sequence

How to implement the WeChat clone function on Huawei mobile phones How to implement the WeChat clone function on Huawei mobile phones Mar 24, 2024 pm 06:03 PM

How to implement the WeChat clone function on Huawei mobile phones With the popularity of social software and people's increasing emphasis on privacy and security, the WeChat clone function has gradually become the focus of people's attention. The WeChat clone function can help users log in to multiple WeChat accounts on the same mobile phone at the same time, making it easier to manage and use. It is not difficult to implement the WeChat clone function on Huawei mobile phones. You only need to follow the following steps. Step 1: Make sure that the mobile phone system version and WeChat version meet the requirements. First, make sure that your Huawei mobile phone system version has been updated to the latest version, as well as the WeChat App.

Which one is better, laravel or thinkphp? Which one is better, laravel or thinkphp? Apr 09, 2024 pm 03:18 PM

Performance comparison of Laravel and ThinkPHP frameworks: ThinkPHP generally performs better than Laravel, focusing on optimization and caching. Laravel performs well, but for complex applications, ThinkPHP may be a better fit.

How to install thinkphp How to install thinkphp Apr 09, 2024 pm 05:42 PM

ThinkPHP installation steps: Prepare PHP, Composer, and MySQL environments. Create projects using Composer. Install the ThinkPHP framework and dependencies. Configure database connection. Generate application code. Launch the application and visit http://localhost:8000.

See all articles