Hands-on PHP & MySQL: Build a CRUD Application

Takeaway Skills

Acquire the basic knowledge needed for studying more advanced courses on PHP.

Develop a working PHP CRUD database application, step by step.

Learn about PHP concepts like router, I/O security, and so on.

Acquire the basic knowledge needed for studying more advanced courses on PHP.

Develop a working PHP CRUD database application, step by step.

Learn about PHP concepts like router, I/O security, and so on.

Course Overview

Learning a programming language is one thing and using it to build something great is another. I've been teaching code newbies and aspiring developers for a long time and I see many of them struggling to put into practice their newly acquired skills. I've also noticed that many resourc... See More

How You'll Learn

Hands-on coding environments

You don’t get better at swimming by watching others. Coding is no different. Practice as you learn with live code environments inside your browser.

Faster than videos

Videos are holding you back. The average video tutorial is spoken at 150 words per minute, while you can read at 250. That‘s why our courses are text-based.

No set-up required

Start learning immediately instead of fiddling with SDKs and IDEs. It‘s all on the cloud.

Progress you can show

Built in assessments let you test your skills. Completion certificates let you show them off.

Hands-on coding environments

You don’t get better at swimming by watching others. Coding is no different. Practice as you learn with live code environments inside your browser.

Faster than videos

Videos are holding you back. The average video tutorial is spoken at 150 words per minute, while you can read at 250. That‘s why our courses are text-based.

No set-up required

Start learning immediately instead of fiddling with SDKs and IDEs. It‘s all on the cloud.

Progress you can show

Built in assessments let you test your skills. Completion certificates let you show them off.

Course Contents

Hide All

Hide All Lessons

1. Introduction

About the Course

Introduction to the LAMP Stack

2. App Initialization

Database Definition

Database Connection With PDO

3. Create and Read Records

Introduction

List All Project

List All Tasks

Add a Project

Add a Task

4. Refactor the Application

Introduction

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

5. PHP Data Validation

Introduction

Front-end Validation

Back-end Validation

6. Generate Reports

General Report

Verify the General Report Feature

Filter by Project

Filter by Date

7. Update and Delete Records

Introduction

Update Records

More on Update Records

Exercise: Update

Remove Records

Exercise: Delete

8. PHP Router

Introduction to PHP Router

Create a Router for our Project

Exercise

9. Conclusion

Summary and Perspectives

10. Appendix

PHP Development Environment

Apache Virtual Host Setup