PHP Tutorials: Pagination (Part 2)
Posted on 21 March 2010 by Abidoon
Visit the forum for help! phpacademy.info Follow on Twitter! twitter.com Paginating results from a mysql database. This is a (almost) simple method of showing paginated results effectively.
Tags | Pagination, Part, Tutorials
do you want a footrub mylord?
Great tutorial! I am using pagination to display the results from a seach and this tutorial saved my life. Bravo!
awesome tutorial bro, i was stumped trying to do this on my own but i got it down now!
You should make the Object oriented version of this tutoria. Thanks though.
What if I wanted to show a range of pages? How would I do that?
That was extremely helpful as was the first part. Thank-you for taking your time to explain what everything was doing in a very clear way.
@iamtheboat Put
if($record_count > $per_page);
{
directly after the //show page numbers comment.
Then put a } directly before the //show next button comment.
I learned more from you than watching that Lynda tutorial because you explain each step clearly and show us what happens if we mess up or if there is something lacking in our code. You are indeed a great teacher. Keep it up!
I found these EXTREMELY useful, thank you so much! One question though:
If there are fewer records returned than the maximum amount we want to display per page, is there an easy way of hiding the ’1′? The ‘next’ link doesn’t show up, which is good, but there’s still that ’1′ sitting there.
Thanks
Liam
Thank you this video was perfect. Keep up with the videos.
Great tutorial, and I think what you were looking for at ~3:40 was 0,4 5,9 etc.
Works good unless users changes the url start-variable by themself.
The best way of doing it is actually by having a page-variable instead of start, then if users changes it to 2 it would still show page 2, mysql rows 5-9. If a user changes the start-variable to 2, as the navigation works now, it would show mysql row 2-6.
But why would users do that
Thanks for another great tutorial!! Looking forward to part 3!!
thanks for sharing Alex.
Alex your a true god! Any chance of merging search engine with pagination? ive tried fiddling with it but nothing is working, thank you
I Love Your Forum
I totally agree. I love they way he explains each part of the code so well. I learned most of the php from him and next semester I’m doing php so ill be like pro at it thanks to you tho.. = )
best php teacher on the internet!
Thanks for the tutorial. It’s useful for my webpage now, especially on the news section.
5 star again!!!
awesome tutorial alex!!!
Hi, Alex. Wow, you made that very easy. Mind was very messy and complicated. Do you like the idea of OOP PHP? Just wondering. xD
Is it possible to limit the number of link ? to 10 for an example?
Prev 1 2 3 4 5 6 7 8 9 10 next
If you’re on page 11
Prev 11 12 13 14… 21 next
omg omg omg!!!11