Pagination on custom Array in CakePHP 3

Question

I am having custom array like:

[business] => Array
(
    [55] => Array
    (
        [id] => 1
        [name] => abc
        [contact] => 1325467897
    ),
    [96] => Array
    (
        [id] => 5
        [name] => xyz
        [contact] => 9876543210
    )

)

This array is derived from conditional (if-else) multiple queries. So, I just want to add pagination on array. Can somebody suggest me how to add custom pagination on this type of array using standard paginator of CakePHP 3.

There's a tutorial in the CakePHP3-Book: http://book.cakephp.org/3.0/en/controllers/components/pagination.html — mario.van.zadel, Oct 14 '15 at 05:26
I think you did'nt get my question completely. Try reading again. — user3801590, Oct 14 '15 at 05:32

score -2 · Answer 1 · answered Jul 19 '16 at 11:23

The PaginatorComponent can take a Cake\ORM\Query as it's thing to paginate, so I would suggest passing your compiled query object to the paginator.

So in your controller you could do something like the following.

public function example()
{
    $this->paginate = ['limit' => 5];

    $query = $this->Examples->find();

    if ($something === 'foo') {
        $query->where(['foo' => $something]);
    }

    if ($wtfbbq) {
        $query->contain(['Wtfs', 'Barbeques']);
    }

    $results = $this->paginate($query);
}

This will produce a Cake\ORM\Query with the pagination built in. Then you can adjust the pagination parameters as you see fit, by checking the book page on the Paginator.

Pagination on custom Array in CakePHP 3

1 Answers1