PHP: Object-Oriented Programming With Databases

SOON
INTRODUCTION
1
Introduction
2
How To Use The Exercise Files
OVERVIEW AND PROJECT SETUP
1
Project Overview
2
Create A Project Database
3
Create A Database Table
4
Project Files
THE DATABASE CONNECTION
1
Database Credentials
2
Connect To The Database
3
Mysqli Methods And Properties
4
Query Using Oop
5
Disconnect From The Database
DEFINE A DATABASE-DRIVEN CLASS
1
Active Record Design Patterns
2
Set The Database
3
Define Query Methods
4
Build Objects Using Record Values
5
Find A Single Record
6
Display A Detail Page
OBJECT-ORIENTED CRUD
1
Crud Operations
2
Create A Record
3
Dynamic Attribute List
4
Sanitize Values For Database
5
Find Record To Update
6
Update A Record
7
Html Forms For Oop
8
Validations And Errors
9
Delete A Record
10
Create Inheritable Code
OBJECT-ORIENTED AUTHENTICATION
1
Admin Class
2
Hashing Passwords
3
Admin Validations
4
Find By Username
5
Verify Password
6
Define A Session Class
7
Add Page Access Control
8
Improve The Session Class
9
Session Messages
OBJECT-ORIENTED PAGINATION
1
Pagination Concepts
2
Define A Pagination Class
3
Paginate Bicycles
4
Previous And Next Page Links
5
Numbered Page Links
CONCLUSION
1
Conclusion