Hands-on PHP & MySQL: Build a CRUD Application

Description

In this course, you will :

• Learn how to build a modern, production-ready PHP app that is connected to a database like a pro. The CRUD app will also include advanced features such as I/O security, a router, and more.
• Learn the fundamentals of PHP before moving on to more advanced courses.
• Step by step, create a functional PHP CRUD database application.
• Learn about PHP concepts such as routers and I/O security.

Syllabus :

1. App Initialization

• Database Definition
• Database Connection With PDO

 

2. Create and Read Records

• List All Project
• List All Tasks
• Add a Project
• Add a Task

 

3. Refactor the Application

• MVC Pattern in a Nutshell
• Adopt MVC Architecture
• Verify the MVC Architecture
• Read Records
• Verify the "Read Records" Feature
• Create Records
• Verify the Add Records Feature
• Security Refactoring
• Verify Security Refactoring

 

4. PHP Data Validation

• Front-end Validation
• Back-end Validation

 

5. Generate Reports

• General Report
• Verify the General Report Feature
• Filter by Project
• Filter by Date

 

6. Update and Delete Records

• Update Records
• More on Update Records
• Exercise: Update
• Remove Records

 

7. PHP Router

• Introduction to PHP Router
• Create a Router for our Project

Show more