Hands-on PHP & MySQL: Build a CRUD Application

Gain insights into building a modern, production-ready PHP app. Delve into CRUD operations, I/O security, routing, and more. Discover how to effectively use PHP and MySQL for database applications.

Intermediate

38 Lessons

16h 30min

Certificate of Completion

Gain insights into building a modern, production-ready PHP app. Delve into CRUD operations, I/O security, routing, and more. Discover how to effectively use PHP and MySQL for database applications.

AI-POWERED

Explanations

AI-POWERED

Explanations

This course includes

33 Playgrounds

This course includes

33 Playgrounds

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 resources on the Internet are out-of-date, misleading, or don't provide real hands-on practice. I've built this course to fix the issues above. You'll learn a better way to build a modern and production-ready PHP app connected to a ...Show More

What You'll Learn

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.

What You'll Learn

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

Course Content

Introduction

Get familiar with PHP & MySQL skills, LAMP stack, and professional web development frameworks.

About the Course Introduction to the LAMP Stack

App Initialization

Get started with initializing a MySQL database and connecting with PHP using PDO.

Database Definition Database Connection With PDO

Create and Read Records

Go hands-on with creating and reading records in a CRUD app using PHP and MySQL.

Introduction List All Project List All Tasks Add a Project Add a Task

Refactor the Application

Break down the steps to refactor into MVC, improve operations, and enhance security.

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

PHP Data Validation

Solve problems in PHP data validation to ensure user input accuracy and security.

Introduction Front-end Validation Back-end Validation

Generate Reports

4 Lessons

See how it works to generate and verify reports, filter tasks by project or date.

Update and Delete Records

6 Lessons

Practice using PHP and MySQL to update and delete database records in a CRUD application.

PHP Router

3 Lessons

Try out creating a PHP router to manage and secure application routes effectively.

Conclusion

1 Lesson

Get started with core PHP skills, PDO, MVC, validation, and project-based practice.

10.

Appendix

2 Lessons

Go hands-on with setting up a PHP development environment and Apache virtual host configuration.

Course Author

Show License and Attributions

Trusted by 1.4 million developers working at companies

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Evan Dunbar

ML Engineer

Carlos Matias La Borde

Software Developer

Souvik Kundu

Front-end Developer

Vinay Krishnaiah

Software Developer

Eric Downs

Musician/Entrepeneur

Kenan Eyvazov

DevOps Engineer

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Hands-on Learning Powered by AI

See how Educative uses AI to make your learning more immersive than ever before.

Instant Code Feedback

Evaluate and debug your code with the click of a button. Get real-time feedback on test cases, including time and space complexity of your solutions.

AI-Powered Mock Interviews

Put your skills to the test in a simulated interview setting. Receive personalized feedback based on your performance. Available in Premium & Premium Plus plans.

Adaptive Learning

At various checkpoints throughout Educative courses, you will be prompted to take a quick assessment. Receive a condensed curriculum tailored to your strengths and skill gaps.

Explain with AI

Select any text within any Educative course, and get an instant explanation — without ever leaving your browser.

AI Code Mentor

AI Code Mentor helps you quickly identify errors in your code, learn from your mistakes, and nudge you in the right direction — just like a 1:1 tutor!