Pagination with Jquery/Javascript/Ajax and PHP/Mysql

Question

Does anyone know of a link to a site that has a tutorial/code on good way to paginate information coming from a database? (without page refresh) I have spent the better part of the day looking for a site that has what I need. Most are dealing with static/fixed data in the forms of lists etc. I need one that has something like this for my tables:

Data          Data          Data          Data          

Data          Data          Data          Data          


Records 1 to 8 of 27  First  Previous Next Last

Shea Daniels · Accepted Answer · 2011-02-08 19:40:43Z

1

We just implemented a few things using this plugin for JQuery:

Datatables.net

It works on basic html tables and has support for AJAX. Basically you would just write a PHP page that returns a partial result from your database in JSON, etc. The plugin will handle making the AJAX call and displaying the data.

answered Feb 8, 2011 at 19:40

Shea Daniels

3,2783 gold badges25 silver badges28 bronze badges

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

2 Comments

Kinyanjui Kamau Over a year ago

Thanks for the reply. Im checking it out

Shea Daniels Over a year ago

I think this page even has some sample PHP.

Kyle Humfeld · Accepted Answer · 2011-02-08 19:40:07Z

0

This is only a very partial answer (sorry, not much time atm) but look for the 'LIMIT' command in mysql. It lets you pull back only a certain set of records, say records 11-20. I use that when I do pagination.

Again, this isn't complete, but hopefully it'll help!

answered Feb 8, 2011 at 19:40

Kyle Humfeld

1,8974 gold badges24 silver badges29 bronze badges

1 Comment

Kinyanjui Kamau Over a year ago

Thanks for they reply. Unfortunately that is not the problem. I guess I'm looking for a jQuery,Ajax plugin or tutorial

eleete · Accepted Answer · 2011-02-08 19:50:21Z

0

I've worked with this one quite a bit. jQgrid... seems to be pretty well maintained. http://www.trirand.com/blog/

answered Feb 8, 2011 at 19:50

eleete

566 bronze badges

Collectives™ on Stack Overflow

Pagination with Jquery/Javascript/Ajax and PHP/Mysql

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related