Overview
-
Learn how to efficiently interact with databases using object-oriented PHP code.
Syllabus
-
Introduction
- Welcome
- How to use the exercise files
- What you need to know
- Project overview
- Create a project database
- Create a database table
- Project files
- Database credentials
- Connect to the database
- MySQLi methods and properties
- Query using OOP
- Disconnect from the database
- Active record design patterns
- Set the database
- Define query methods
- Build objects using record values
- Find a single record
- Display a detail page
- 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
- 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
- Pagination concepts
- Define a pagination class
- Paginate bicycles
- Previous and next page links
- Numbered page links
- Next steps
