thinkphp pagination how to restrict the display

When you output the page, you use the key+1 of the array as the ordinal number. You need to use limit(offset, length) to get the data of the current page, right, you just need to put key+1+offset.

$user = m('user');Instantiate the user object.

count = $user->where('status=1')->count();Query the total number of records that meet the requirements.

page = new \think\page($count,25);Instantiated pagination class The total number of records and the number of records displayed per page (25) are passed in

show = $page->show();Pagination displays the output.

Querying pagination data Note that the parameters of the limit method should use the properties of the page class.

list = $user->where('status=1')->order('create_time')->limit($page->firstrow.','.$page->listrows)->select();

this->assign('list',$list);Assign a value dataset.

this->assign('page',$show);Assign a paging output.

this->display();Output templates.

Direct use at the front desk.

$d->limit

What is this?

The sql statement is written like this.

sql="select*from guestbook limit".$d->firstrow.','.$d->listrows

Put $d->limit, echo it out and you'll know it's wrong. Please check.

Thinkphp's page class is correct and there is no problem.

Please lz to check $page = new page($count,5); Check whether the count value is correct.

I think it's still your **'s problem, there may be a problem when calculating the total quantity.

Please paste your implementation**.

Query criteria are pagination.

In the previous section, "ThinkPHP pagination in detail and pagination application examples", we only talked about the reference of ordinary query pagination, and its query parameters are relatively fixed. In many cases, pagination also brings in query criteria, which tend to be variable. For example, common searches need to be retrieved according to the keywords queried by users, and when there are too many search results, the search results need to be reasonably paginated.

ThinkPHP pagination makes it easy to implement support for non-fixed query parameters. The specific implementation is to assign a value to the parameter property of the pagination class or pass in the query parameters when the pagination class is directly instantiated. Here's an example.

parameter property.

For example, if you want to retrieve a user with status 1 (status=1) and an electronic presence of 163 in the user table, when you submit a form (note that the form is submitted in GET mode), the URL address will look like this:

This is self-defined.

dao = m("customer");

map['company_id'] = $_session['company_id'];The search history is limited to the company ID.

count = $dao->where($map)->count();Calculate the total.

p = new \think\page($count, 15);Pagination thinkphp version 15 is the number of entries per page, defined by yourself.

list=$dao

where($map)

limit($p->firstrow.','.$p->listrows)

select();

page = $p->show();The output variable of the pagination navigation bar.

this->assign("page", $page);

this->assign("customerlist", $list);Data loop variables.

this->display();

You can set as many as you want.

1，$page = new \think\page($total, $listrows, $request);

2，$page->totalpages

This will get the total number of pages.