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.

Build a CRUD Database App with PHP & MySQL-01.png

lamp.tar.gz

lamp

lamp-copy

lamp-new

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.

Hands-on PHP & MySQL: Build a CRUD Application

Hey there! Thank you so much for joining us in this hands-on course to learn how to practice your PHP and MySQL skills. We hope that you’ll find this course fun!

# What we’ll learn
The following topics are included in this course:
* How to connect a PHP application to an SQL-like database with PDO
* How to add or read data in or from a database
* How to update and delete data
* The MVC architecture
* How to secure a PHP application


# Topics included
 We’ll cover the below skills in this course:
* PDO
* SELECT, INSERT, UPDATE, and DELETE
* MVC pattern
* PHP I/O security
* PHP router

# Intended audience
This course is not designed as a beginner or introductory course. This course gives us the opportunity to practice what we already know in a professional setting, so it is written with the assumption that the learner is already familiar with PHP and MySQL. 



In case you need a refresher, there are  [PHP](https://www.educative.io/courses/learn-php-from-scratch) and [MySQL](https://www.educative.io/courses/introductory-guide-to-sql) introductory courses on the Educative platform.

Review the course topics and learning outcomes. 

Introduction

App Initialization

Create and Read Records

Refactor the Application

PHP Data Validation

Generate Reports

Update and Delete Records

PHP Router

Conclusion

Appendix

About the Course