Pagination?

[JiminSA]

Looking through the documentation, I wasn't able to find out if AdminPack has a pagination facility (my database is growing quite large). If possible, I would like some advice on how to achieve this, hopefully not having to re-invent the wheel...

[thruska]

Pagination? What's that?

Just kidding. There are ways around pagination such as writing a search engine. As a user, are you really going to peruse more than 200 items looking for what you want to find? And where users want to "peruse" said listings, pagination frequently defeats the purpose of the find feature in most web browsers - quickly searching for a specific string. And pagination does weird things such as the last page containing one measly entry.

Article and comments worth reading:

http://www.codinghorror.com/blog/2012/03...ation.html

As to implementing pagination in AdminPack, I've not done anything in this regard. If a complete database listing will be unwieldy to work with, I develop a search engine that displays a limited - but reasonable - number of results. Typically 200 to 300 results for a desktop web browser and 25 to 50 results for mobile. To date, no one has complained about those limits, so either no one has noticed or users who hit the limits just go back and refine their search parameters to reduce the number of results.

If you still want to do pagination, you could put the paging options in 'htmldesc' for the table but you'll have to invent the wheel since I've not done so.

[JiminSA]

Cool Thomas... I've already sorted a script, but integrating it will prove interesting! Incidently I want it for a search; a specific order listing I've put in and the normal listing.

[JiminSA]

The pagination integrated very smoothly - I simply put the code in the main page db action=="manage" section and having checked for the URL 'page' variable produced by the inserted code.
Just one question - having put the pagination 'menu' in the htmldesc for the table, is it possible to display this after the 'listing' at the bottom?

[thruska]

A 'custom' field with the content being the pagination options.

This may or may not be useful:

http://www.datatables.net/index

I ran into that today and thought it was a pretty slick solution for pagination.

[JiminSA]

Lovely, Thomas Looks very professional now!

I have a query regarding MySql db backup, which I'll post in a new thread...