PHP: Object-Oriented Programming with Databases

Course details

Learn how to interact with databases using object-oriented PHP code. In this intermediate course, Kevin Skoglund teaches powerful PHP techniques that streamline interactions with MySQL databases. PHP developers will benefit from the efficient, well-organized, reusable, and easy-to-understand code that object-oriented programming (OOP) offers. Kevin shows how OOP techniques can optimize database queries, help manage sessions, and simplify user logins. He provides practical examples and tips to create objects that interact seamlessly with database rows, to build a content management system with HTML forms, to authenticate users, and to break up long lists of database data into smaller 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.

Learning objectives
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

Concepts

0. Introduction

01 - Welcome
02 - How to use the exercise files
03 - What you need to know

1. Overview and Project Setup

04 - Project overview
05 - Create a project database
06 - Create a database table
07 - Project files

2. The Database Connection

08 - Database credentials
09 - Connect to the database
10 - MySQLi methods and properties
11 - Query using OOP
12 - Disconnect from the database

3. Define a Database-Driven Class

13 - Active record design patterns
14 - Set the database
15 - Define query methods
16 - Build objects using record values
17 - Find a single record
18 - Display a detail page

4. Object-Oriented CRUD

19 - CRUD operations
20 - Create a record
21 - Dynamic attribute list
22 - Sanitize values for database
23 - Find record to update
24 - Update a record
25 - HTML forms for OOP
26 - Validations and errors
27 - Delete a record
28 - Create inheritable code

5. Object-Oriented Authentication

29 - Admin class
30 - Hashing passwords
31 - Admin validations
32 - Find by username
33 - Verify password
34 - Define a session class
35 - Add page access control
36 - Improve the session class
37 - Session messages

6. Object-Oriented Pagination

38 - Pagination concepts
39 - Define a pagination class
40 - Paginate bicycles
41 - Previous and next page links
42 - Numbered page links

Conclusion

43 - Next steps

PHP: Object-Oriented Programming with Databases

Authors

Kevin Skoglund