PHP: Object-Oriented Programming with Databases

Learn how to efficiently interact with databases using object-oriented PHP code.

Introduction

• Welcome
• How to use the exercise files
• What you need to know

1. Overview and Project Setup

• Project overview
• Create a project database
• Create a database table
• Project files

2. The Database Connection

• Database credentials
• Connect to the database
• MySQLi methods and properties
• Query using OOP
• Disconnect from the database

3. Define a Database-Driven Class

• Active record design patterns
• Set the database
• Define query methods
• Build objects using record values
• Find a single record
• Display a detail page

4. Object-Oriented CRUD

• CRUD operations
• Create a record
• Dynamic attribute list
• Sanitize values for database
• Find record to update
• Update a record
• HTML forms for OOP
• Validations and errors
• Delete a record
• Create inheritable code

5. Object-Oriented Authentication

• Admin class
• Hashing passwords
• Admin validations
• Find by username
• Verify password
• Define a session class
• Add page access control
• Improve the session class
• Session messages

6. Object-Oriented Pagination

• Pagination concepts
• Define a pagination class
• Paginate bicycles
• Previous and next page links
• Numbered page links

Conclusion

• Next steps