Home>Courses>Hands-on PHP & MySQL: Build a CRUD Application

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
Course Overview
What You'll Learn
Course Content
Apply Your Skills

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
Learning a programming language is one thing and using it to build something great is another. I've been teaching code newbies 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.
Acquire the basic knowledge needed for studying more advanced courses on PHP.

Show more

Course Content

1.

Introduction

2 Lessons

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

2.

App Initialization

2 Lessons

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

3.

Create and Read Records

5 Lessons

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

5.

PHP Data Validation

3 Lessons

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

6.

Generate Reports

4 Lessons

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

7.

Update and Delete Records

6 Lessons

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

8.

PHP Router

3 Lessons

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

9.

Conclusion

1 Lessons

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 2.5 million developers working at companies

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

Adaptive Learning

Explain with AI

AI Code Mentor

Free Resources

FOR TEAMS

Interested in this course for your business or team?

Unlock this course (and 1,000+ more) for your entire org with DevPath