Gain an overview of the concepts behind paginating records. Discover the key variables necessary to make pagination calculations.
- In this chapter we're going to learn…how to do object-oriented pagination.…We will begin by talking about…some of the underlying concepts that make pagination work.…The reason we need pagination…is to manage large sets of data.…Let's imagine that…instead of having just 10 bicycles in our database,…we had 1,000, or even 10,000, or 100,000.…We probably would not want to view all of those bicycles…on a single page at one time.…It would be visually overwhelming,…but it also requires server to do a lot of work…to retrieve that many records from the database,…and then to instantiate them,…and turn them into PHP objects.…
It would take a lot of time and a lot of memory.…We probably don't want to do that.…So instead, pagination allows us…to just show a subset of records,…and then, when we want to see more records,…there are links that will take us…to other pages of the results.…Typically you would have previous or next…to take you to the previous or next pages of results,…or you might have a list of numbers…showing you the different pages…
Note: This is an intermediate-level training course that assumes you have existing knowledge of PHP. To refresh your skills, check out PHP Essential Training and PHP: Object-Oriented Programming.
- Creating a project database and tables
- Connecting to the database
- Database queries with OOP
- The active record design pattern
- Defining a database-driven class
- Performing common database tasks with OOP
- Creating inheritable and reusable code
- Object-oriented user authentication
- Object-oriented pagination
Skill Level Intermediate
Consuming RESTful APIs in PHP with Guzzlewith Justin Yost2h 12m Intermediate
PHP: Accessing Databases with PDO and MySQLiwith David Powers3h 47m Intermediate
1. Overview and Project Setup
2. The Database Connection
3. Define a Database-Driven Class
4. Object-Oriented CRUD
5. Object-Oriented Authentication
6. Object-Oriented Pagination
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.