Web Development with Database: PHP
This course is tailored for individuals aiming to elevate their PHP programming skills by delving into object-oriented programming (OOP) principles and integrating PHP with databases. Participants will learn how to design and implement robust, scalable web applications using PHP, object-oriented methodologies, and effective database interactions
Module 1. Overview and Project Setup
Module 2. The Database Connection
Module 3. Define a Database-Driven Class
-
10Active record design patterns
Active record design patterns
-
11Set the database
Set the database
-
12Define query methods
Define query methods
-
13Build objects using record values
Build objects using record values
-
14Find a single record
Find a single record
-
15Display a detail page
Display a detail page
Module 4. Object-Oriented CRUD
-
16CRUD operations
CRUD operations
-
17Create a record
Create a record
-
18Dynamic attribute list
Dynamic attribute list
-
19Sanitize values for database
Sanitize values for database
-
20Find record to update
Find record to update
-
21HTML forms for OOP
HTML forms for OOP
-
22Validations and errors
Validations and errors
-
23Create inheritable code
Create inheritable code
Module 5. Object-Oriented Authentication
-
24Admin class
Admin class
-
25Hashing passwords
Hashing passwords
-
26Admin validations
Admin validations
-
27Find by username
Find by username
-
28Verify password
Verify password
-
29Define a session class
Define a session class
-
30Add page access control
Add page access control
-
31Improve the session class
Improve the session class