lovelycesar Posted March 30, 2012 Share Posted March 30, 2012 I would like to know what is the best method (the most intelligent and comfortable for users) to paginate a result table with PHP/MySQL? Provided I have a result set of 100 pages. Method 1: <select> <option>1</option> .... </select> Method 2: Link on Page 1, 2, 3 ... 100 If there is any algorithm with PHP for automated these displays, please demonstrate it. Quote Link to comment https://forums.phpfreaks.com/topic/259990-pagination-of-results-from-phpmysql-what-is-the-best-method/ Share on other sites More sharing options...
arenaninja Posted March 30, 2012 Share Posted March 30, 2012 Last night I implemented this: http://www.sitepoint.com/perfect-php-pagination/ into my design. I like how it fetches results from the database only once and the rest is handled by the logic. It isn't fancy and you should be able to work out a much better interface in an hour or two if that's your thing, but I found it very straightforward and easy to implement. Quote Link to comment https://forums.phpfreaks.com/topic/259990-pagination-of-results-from-phpmysql-what-is-the-best-method/#findComment-1332593 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.