How to solve TP5 native sql paging

This article focuses on "how to solve TP5 native sql pagination", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to solve TP5 native sql paging.

Incredible demand: TP5 native sql paging can only be solved!

Thinkphp5 native sql pagination to address the needs of abnormal customers

Recently, a home improvement website is being developed, and there is a lot of customer demand.

You need to use native sql to solve this.

Tp5's order does not support coquettish operation, which is filtered out by default.

/ / use think\ paginator\ driver\ Bootstrap; remember to introduce $pageSize=8;// 8 items per page $currPage=input ('page',1); $list = Db::query ("select * from osc_sms order by id limit?,?", [($currPage-1) * $pageSize,$pageSize]); $total = Db::query ("select count (*) cnt from osc_sms") [0] [' cnt'] $pagernator = Bootstrap::make ($list,$pageSize,$currPage,$total,false, ['path'= > Bootstrap::getCurrentPath (),' query'= > request ()-> param ()]); $page = $pagernator- > render (); now that you have a better understanding of "how to solve TP5 native sql pagination", you might as well do it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!