HomeCoursesHands-on PHP & MySQL: Build a CRUD Application

Save

Hands-on PHP & MySQL: Build a CRUD Application

Name: Hands-on PHP & MySQL: Build a CRUD Application
Price: 59 USD
Author: Abel Lifaefi Mbula

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.

What's included

38 lessons across 10 modules
3 quizzes with instant feedback
on every lesson

Join 3.1 million developers at

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.

Learning Roadmap

38 Lessons3 Quizzes

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

5 Lessons

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

Refactor the Application

10 Lessons

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

PHP Data Validation

3 Lessons

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

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

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

Summary and Perspectives

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.

Show License and Attributions

About this course

WHY I WROTE 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.

Learn more about Abel

Trusted by 3.1 million developers working at companies

These are high-quality courses. Trust me the price is worth it for the content quality. Educative 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

FOR TEAMS

Interested in this course for your business or team?

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