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

No matter how complex of a client-side validation we perform, server-side validation is just as crucial and important.

Front-end validation can be bypassed if:

> **Curious to know how front-end validation can be bypassed?** 
> - A malicious user turns off JavaScript on their browser.
> - Middlemen attacks occur, which change the data after the request is submitted by a user, but before it is received by the server.


We’ve been practicing back-end validation in the previous lessons. Let’s recall how to conduct some of those validations:

## Prepared statements

In the event  that we need to rely on user inputs to perform database tasks:

No matter how complex of a client-side validation we perform, server-side validation is just as crucial and important.

Front-end validation can be bypassed if:

> **Curious to know how front-end validation can be bypassed?** 
> - A malicious user turns off JavaScript on their browser.
> - Middlemen attacks occur, which change the data after the request is submitted by a user, but before it is received by the server.


We’ve been practicing back-end validation in the previous lessons. Let’s recall how to conduct some of those validations:

# Prepared statements

In the event  that we need to rely on user inputs to perform database tasks:

Learn about prepared statements for database operations, input sanitization, and validation.

Introduction

App Initialization

Create and Read Records

Refactor the Application

PHP Data Validation

Generate Reports

Update and Delete Records

PHP Router

Conclusion

Appendix

Back-end Validation

Prepared statements