Review the four primary database operations: create, read, update, delete. Add initial PHP pages for managing the content of the bicycle table from a staff area.
- In this chapter,…we'll be learning to perform…the remaining database operations…so that we can implement the object oriented…active record design pattern.…We're going to be looking at four main operations,…and the abbreviation for these is CRUD, c-r-u-d.…C is for create, R is for read,…U is for update, and D is for delete.…Those are the four primary ways…that we interact with the database.…We create new records, we read existing records,…we update existing records, or we delete records.…So far, we've already seen how we can read…from the database when we learned…how to do find all and find by ID.…
Now we need to learn how to implement the other three.…The way that we're going to add that to our project…is that we're going to create a staff area,…a content management system…that'll allow the Chain Gang staff…to log in…and be able to update…the inventory of bicycles using a web interface.…They'll be able to create records,…update records, delete records, and so on.…So the code work that lies ahead of us…to implement the active record part of this…
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.