AI-powered learning
Save this course
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.
38 Lessons
16h 30min
Join 2.9 million developers at
Join 2.9 million developers at
LEARNING OBJECTIVES
- 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.
Learning Roadmap
1.
Introduction
Introduction
Get familiar with PHP & MySQL skills, LAMP stack, and professional web development frameworks.
2.
App Initialization
App Initialization
Get started with initializing a MySQL database and connecting with PHP using PDO.
3.
Create and Read Records
Create and Read Records
5 Lessons
5 Lessons
Go hands-on with creating and reading records in a CRUD app using PHP and MySQL.
4.
Refactor the Application
Refactor the Application
10 Lessons
10 Lessons
Break down the steps to refactor into MVC, improve operations, and enhance security.
5.
PHP Data Validation
PHP Data Validation
3 Lessons
3 Lessons
Solve problems in PHP data validation to ensure user input accuracy and security.
6.
Generate Reports
Generate Reports
4 Lessons
4 Lessons
See how it works to generate and verify reports, filter tasks by project or date.
7.
Update and Delete Records
Update and Delete Records
6 Lessons
6 Lessons
Practice using PHP and MySQL to update and delete database records in a CRUD application.
8.
PHP Router
PHP Router
3 Lessons
3 Lessons
Try out creating a PHP router to manage and secure application routes effectively.
10.
Appendix
Appendix
2 Lessons
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.
Complete more lessons to unlock your certificate
Show License and Attributions
Developed by MAANG Engineers
ABOUT THIS COURSE
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 database like a pro. The app, a CRUD one, will also have some more advanced features like I/O security, router, and more.
At the end of this course, you'll be well equipped to build database apps with PHP.
ABOUT THE AUTHOR
Abel Lifaefi Mbula
Abel is an educator and a software engineer who enjoys sharing his knowledge with the community as a way for giving back to this community.
Trusted by 2.9 million developers working at companies
A
Anthony Walker
@_webarchitect_
E
Evan Dunbar
ML Engineer
S
Software Developer
Carlos Matias La Borde
S
Souvik Kundu
Front-end Developer
V
Vinay Krishnaiah
Software Developer
Built for 10x Developers
No Passive Learning
Learn by building with project-based lessons and in-browser code editor
Personalized Roadmaps
The platform adapts to your strengths & skills gaps as you go
Future-proof Your Career
Get hands-on with in-demand skills
AI Code Mentor
Write better code with AI feedback, smart debugging, and "Ask AI"
MAANG+ Interview Prep
AI Mock Interviews simulate every technical loop at top companies
Free Resources
