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

In the previous lesson, we learned how to escape HTML tags with the `htmlspecialchars()` function and how to avoid the duplication of content.

Now it's time for us to test these two functionalities.


First, we’ll open the task form by clicking the “Add task” button and enter the following: `<script>alert('Hello world')</script>`. After that, we’ll go to the task list by clicking the “Task list” button. We’ll then see that the script is not executed.

Lastly, we’ll open the project form and try to add the “Learn Node.js” title twice. We should see that it is no longer possible to enter the same title twice.


Let’s practice what we learned in the previous lesson.

Introduction

App Initialization

Create and Read Records

Refactor the Application

PHP Data Validation

Generate Reports

Update and Delete Records

PHP Router

Conclusion

Appendix

Verify Security Refactoring