Intermediate
16h 30min
Updated 1 month ago
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.
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.
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
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.
4.
Refactor the Application
10 Lessons
Break down the steps to refactor into MVC, improve operations, and enhance security.
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
Developed by MAANG Engineers
Trusted by 2.8 million developers working at companies
"These are high-quality courses. Trust me. I own around 10 and the price is worth it for the content quality. EducativeInc came at the right time in my career. I'm understanding topics better than with any book or online video tutorial I've done. Truly made for developers. Thanks"
Anthony Walker
@_webarchitect_
"Just finished my first full #ML course: Machine learning for Software Engineers from Educative, Inc. ... Highly recommend!"
Evan Dunbar
ML Engineer
"You guys are the gold standard of crash-courses... Narrow enough that it doesn't need years of study or a full blown book to get the gist, but broad enough that an afternoon of Googling doesn't cut it."
Software Developer
Carlos Matias La Borde
"I spend my days and nights on Educative. It is indispensable. It is such a unique and reader-friendly site"
Souvik Kundu
Front-end Developer
"Your courses are simply awesome, the depth they go into and the breadth of coverage is so good that I don't have to refer to 10 different websites looking for interview topics and content."
Vinay Krishnaiah
Software Developer
Hands-on Learning Powered by AI
See how Educative uses AI to make your learning more immersive than ever before.
AI Prompt
Code Feedback
Explain with AI
AI Code Mentor
Free Resources
