Pagination using an array in CakePHP

Question

Actually, I need to do pagination.

How do I do pagination by using a bunch of array data in CakePHP?

For an urgent fix I have handled my code by using JavaScript pagination. Is it only possible by using the model? Can't we do pagination with array data?

Doesn't the last stored ID maximum? If yes, look at [this](http://stackoverflow.com/questions/8898020/oracle-taking-the-record-with-the-max-date). — Farhad Jabiyev, Dec 31 '14 at 05:31
Negative voter Please comment why you have given negative vote. Can you please explain — KARTHI SRV, Sep 16 '16 at 09:49

score 1 · Answer 1 · edited Sep 17 '16 at 19:00

1

In Oracle 12c or later, you can write:

select *
from table
order by id desc
fetch first 1 row only

edited Sep 17 '16 at 19:00

Peter Mortensen

30,738
21
105
131

answered Dec 31 '14 at 15:16

Hassan Abbasi

272
1
3

score 0 · Answer 2 · answered Dec 31 '14 at 06:55

0

Try select * from YourtableName where rowid in (select max(rowid) from YourtableName)

answered Dec 31 '14 at 06:55

mayowa ogundele

475
2
6
19

Pagination using an array in CakePHP

2 Answers2