Page 1 of 1

Pagination without using connection object

Posted: Wed Dec 09, 2009 10:24 pm
by jishcem
Hello there,
I would like to know whether there is any trick to paginate with out using mysql operations. Most of the pagination script available on the net is using connection object.
I would like to paginate without using that. Because I am calling a function which returns an array of objects which will contain the field values of the database.

Hoping for reply.

Regards, Ajeesh.

Re: Pagination without using connection object

Posted: Wed Dec 09, 2009 11:02 pm
by pcoder
You can go through the different UI stuffs. For a small recordset, you can use the jQuery Tablesorter plugin.
But remember, for a huge recordset, it would be better to fetch the defined rows at a time. 8)

Re: Pagination without using connection object

Posted: Thu Dec 10, 2009 12:59 am
by jishcem
Thanks

Re: Pagination without using connection object

Posted: Thu Dec 10, 2009 11:13 am
by pickle
array_slice() might be handy.