Heres a simple example of how to paginate a controller action in Cakephp3;
public function index()
{
$this->paginate = [
'order' => [
'controller' => 'asc'
],
'maxLimit' => 20
];
$menus = $this->paginate($this->Menus);
$this->set(compact('menus'));
$this->set('_serialize', ['menus']);
}
If you wanted to sort a Model by a certain field in this case take the field “created” which is a date. We can simply tell cakePHP to pagnate entries by the order they were created by the following example.
public function index() {
// we prepare our query, the cakephp way!
$this->paginate = array(
'limit' => 20,
'order' => array('created' => 'desc')
);
$this->Link->recursive = 0;
$this->set('links', $this->Paginator->paginate());
}
More Examples can be found here;
https://www.codeofaninja.com/2013/07/pagination-in-cakephp.html