Learn how to efficiently interact with databases using object-oriented PHP code.
- [Kevin] Welcome to PHP Object-Oriented Programming with Databases. My name is Kevin Skoglund and I'm excited to teach you how to use PHP's object-oriented programming techniques to work with databases. In this course we will learn the object-oriented syntax for PHP's built-in MySQL adapter. We will learn about the active record design pattern and use it to create objects and database rows which interact seamlessly, and we'll build a content management system to make it easy to create, read, update, and delete records using HTML pages and forms.
We'll use object-oriented techniques to implement user authentication so that only administrators with a valid username and password will be able to access and update records and we'll break up tables which has many records into pages by using a pagination class to simplify handling of the variables, calculation, and links that we need to display for the user. This is an intermediate course which will assume that you already know the basics of PHP. If you need to review your skills, PHP Essential Training, PHP with MySQL Essential Training parts one and two, and PHP Object-Oriented Programming will prepare you with everything you need to know for this course.
Once you're ready, let's get started learning PHP Object-Oriented Programming with Databases.
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.