PHP Techniques: Pagination

Learn how to paginate a list of items or database records using PHP.

Introduction

• Showing posts in pages using PHP
• Using the exercise files on GitHub

1. Pagination Fundamentals

• Pagination overview
• Finding the pagination variables
• Using total record count

2. Database Record Pagination

• Setting up the project database
• SQL LIMIT, OFFSET, and COUNT
• Paginating database records

3. Links to Paginated Pages

• Adding links to previous and next pages
• Creating pagination links
• Showing an excerpt of the page list
• Remembering the current page

4. Object-Oriented Pagination

• Defining a pagination class
• Outputting links for previous and next pages
• Outputting pagination links

Conclusion

• Next steps