HomeCoursesHands-on PHP & MySQL: Build a CRUD Application

Intermediate

16h 30min

Hands-on PHP & MySQL: Build a CRUD Application
Save for later

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.
Join 2.6 million developers at
Table of Contents
Learner Reviews

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.
Certificate of Completion
Showcase your accomplishment by sharing your certificate of completion.

Course Author:

Show License and Attributions

Join 2.6 million learners and start transforming your career today

Trusted by 2.6 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