Cakephp 2.x: how to paginate data from an existing array (json, etc)?

Question

I use a remote API to retrieve data (in xml, json format), which I'm caching. But I need to properly paginate this data before render.

I don't want to store this data in database.

I'm OK to recreate a PHPPaginator component and do the data manipulation by myself (Hash::sort, filtering, etc) like mentioned here but I would love to reuse the Pagination helper.

I tried to understand how the Paginator component transmits data to the Paginator helper but I couldn't find where it was instantiated and where the data was set.

I saw the $this->Paginator->settings gives for a classic model:

array(
'page' => (int) 1,
'current' => (int) 100,
'count' => (int) 341,
'prevPage' => false,
'nextPage' => true,
'pageCount' => (int) 4,
'order' => 'Model.created DESC',
'limit' => (int) 100,
'options' => array(),
'paramType' => 'named'
)

How should I instantiate the Paginator helper for it to autobuild all the links in the very same way as it does with normal data?

floriank · Accepted Answer · 2015-01-21 15:27:07Z

1

Use the Array Data Source from this repository. Just turn your json file into an array or create your own Json Data Source based on it.

https://github.com/cakephp/datasources

The paginator just takes the URL params and turns them into a find('all') and find('count'). The helper just deals with generating some link in the view with the params for the paginator component. The real pagination happens by the find all and count using a model object.

edited Jan 21, 2015 at 15:27

answered Jan 21, 2015 at 15:22

floriank

25.7k9 gold badges47 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mattspain Over a year ago

Thanks this is the exact solution I was looking for.

Collectives™ on Stack Overflow

Cakephp 2.x: how to paginate data from an existing array (json, etc)?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related