PHP / MySQL分页还是jQuery？

Question

Just a quick question. If I use a Pagination for my website and am expecting a lot of results, is it better to use jQuery or just a basic PHP/MySQL one that just loads a new page?

If I use jQuery and I have over 300 results from the database, will it have to load it all at once on the initial page load? That might take a long time to load. Or can you make it load only the first 10, and then when you go to Page 2 it will load the next 10?

Just wondering if you have any suggestions for my situation, and if you recommend any good scripts I can use for it.

Thanks!

Answer 1

You've tagged your question with ajax, that's the answer... You should use a combo of PHP/MySQL + Ajax to make the things faster and smoother.

Here is a very popular plugin which implement the client interface: JQGrid