How to Limit the paginate in cakephp

Question

How to Limit the paginate in cakephp ?

Assume that i have 400 records.
I need to get only 25 records from 50th record to 75th record and need to display 5 records per page.
How i can do this in paginate ?

Sample Code:

        $this->paginate = array(
                'contain'=>array('User'),
                'recursive' => 2,
                'order' => array('Profile.winning' => 'DESC'),
                'limit' =>5

            );

pawelmysior · Accepted Answer · 2011-05-27T14:53:41.303

10

You can set conditions for the pagination.

function listRecords()
  {
  $this->paginate = array(
    'conditions' => array('Model.id >=' => 50, 'Model.id <=' => 75),
    'limit' => 5
    );
  $this->paginate('Model');
  );

EDIT:

A solution from here:

$this->paginate = array(
  'limit' => 20,
  'totallimit' => 1000
  );

And then in the Model:

public function paginateCount($conditions = null, $recursive = 0, $extra = array())
  {
  if( isset($extra['totallimit']) ) return $extra['totallimit'];
  }

edited May 27 '11 at 14:53

answered May 27 '11 at 13:23

pawelmysior

3,190
3
28
37

I am using order by so i cant give 'Model.id' in conditions... my result need to display only last 25 records according to high 'Profile.winning' – AnNaMaLaI May 27 '11 at 14:25
Oh, that's a completely different story. Not so easy to do that in Cake as it turns out. – pawelmysior May 27 '11 at 14:51
Edited the answer. Not liking it too much though. It just seems strange that Cake doesn't have a built-in, core solution for that... – pawelmysior May 27 '11 at 14:54
2nd solution works! Just bit inconvenience need to edit both model & controller – neobie Apr 05 '12 at 01:06
also unfortunately it must return a totallimit value; and if the records is less than totallimit, the paging still stick to totallimit value – neobie Apr 05 '12 at 01:16

score 2 · Answer 2 · answered Apr 05 '12 at 01:25

Improved version with reference of: http://www.mainelydesign.com/blog/view/best-paginatecount-cakephp-with-group-by-support

This return the correct total count base on whichever is less.

public function paginateCount($conditions = null, $recursive = 0, $extra = array()) 
    {
        $conditions = compact('conditions');
        if ($recursive != $this->recursive) {
            $conditions['recursive'] = $recursive;
        }
        unset( $extra['contain'] );
        $count = $this->find('count', array_merge($conditions, $extra));

        if (isset($extra['group'])) {
            $count = $this->getAffectedRows();
        }

        if (isset($extra['totallimit']) && $extra['totallimit'] < $count) {
            return $extra['totallimit'];
        }

        return $count;
    }

score 1 · Answer 3 · answered Apr 28 '13 at 07:14

1

Use maxLimit in CakePHP v2.x .

public $paginate = array(
    // other keys here.
    'maxLimit' => 10
);

read more about it here.

answered Apr 28 '13 at 07:14

score 0 · Answer 4 · answered Nov 25 '17 at 01:28

0

$query = $this->User->find('all', [
    'recursive' => 2,
    'order' => array('Profile.winning' => 'DESC'),
    'limit' => 25, 
    'offset' => 50
]);
$this->paginate = array(
    $query,
    'limit' => 5
);

answered Nov 25 '17 at 01:28

Marcelo Quispe Ortega

1

4

Please add an explanation that explains what this code does to solve the problem. – Leopold Joy Nov 25 '17 at 01:59

score 0 · Answer 5 · answered Dec 30 '20 at 12:06

In cakephp 4.x version we have to call like below

 public function index()
    {
        $this->loadComponent('Paginator');
        $settings = array(
            'limit' => 50
        );
        $prices = $this->Paginator->paginate($this->Prices->find(), $settings);
        $this->set(compact('prices'));
    }

How to Limit the paginate in cakephp

5 Answers5

EDIT:

Linked