How to limit number of result in pagination?

Need Help
1

This is my action:

public function index()
{
$this->paginate = [
‘page’ => 1,
‘limit’ => 12,
‘maxLimit’ => 12
];
$suppliers =$this->Suppliers->find(‘all’)
->order([‘Suppliers.description’=>‘asc’]);
$suppliers = $this->paginate($suppliers);
$this->set(compact(‘suppliers’));
$this->set(’_serialize’, [‘suppliers’]);
}

No matters value I put on limit, max limit… he always give me all record from my database…

2

No need to write $suppliers =$this->Suppliers->find('all') ->order(['Suppliers.description'=>'asc']);.

The only code that you require after the paginate settings is
$suppliers = $this->paginate($this->Suppliers);

If you want additional conditions you can write it in the paginate settings array.

3

Thanks for your advice you are right…but can you help with my ‘limit’ problem?

4

I am not seeing any issue with this syntax. This code should work.

5

If I have 200 records in my database and if I set
$this->paginate = [ ‘page’ => 1, ‘limit’ => 10, ‘maxLimit’ => 10 ];
in my view I see 20 page with 10 record per page.

6

Yes this is the flow.

7

If I just want to show the last 20 result of the paginate? 2 page 10 record per page?

8

@markstory Can you please guide us. This seems an issue with CakePHP-3. I also tried and seems the maxLimit option not working.

9

What do you mean with: “Can you please guide us.” What do you need to know?

10

I raised an issue and asked to CakePHP members. You can see the discussion here https://github.com/cakephp/cakephp/issues/9446

11

Many thanks for your help…