I obtain a series of records from my SQL database. I need to show a listview of all records in my PhoneGap based mobile app, but there can be 100's of records returned (which include image references) which makes for slow loading, so I need the data paginated so users can cycle through the returned data one page at a time.
I have a skeleton framework of src code I provide. You must modify what I provide to support pagination, not create an implementation from scratch. This service needs to fit into an existing project.
The skeleton framework consists of:
- Connection to DB (PHP)
- Population of DB (text file with SQL queries)
- [url removed, login to view] of phonegap based app
- PHP script invoked by from mobile app to get entries and populate jQuery Listview.
The supported pagination buttons should be "First", "Prev", "Next", "Last"; that's it.