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




# What's wrong with the actual code?
If we look at our codebase, we’ll quickly realize that it’s not well organized at all. It’s spaghetti code,  meaning that the code is difficult to understand, maintain, and debug. These three qualities are important considerations for beginner PHP developers.

This course is meant to teach learners how to become professional developers, so we’ll go over some tips and tricks to write professional code. Let’s get started!

# MVC to the rescue!
**MVC** stands for **Model View Controller** and is a pattern used to separate application concerns. Let’s break down what each component of MVC means:
* “M” represents the data or business logic.
* “V” represents the presentation.
* “C”  acts between M and V.

In the upcoming lessons, we’ll discuss:
* The MVC pattern in a nutshell.
* The installer script refactored.
- The create and read operations.
- The security refactoring.

      
          


Cover the problems within our application code and what steps can be taken to refactor it.

Introduction

App Initialization

Create and Read Records

Refactor the Application

PHP Data Validation

Generate Reports

Update and Delete Records

PHP Router

Conclusion

Appendix

Introduction

What’s wrong with the actual code?