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

So far we’ve worked on creating or inserting data into the database and reading or selecting it. We still have things to do in order to completely finish with the implementation of our CRUD database application, such as updating, editing, or deleting features.

In this chapter, we’ll learn how to overwrite a record in the database and completely remove it from the database.


# Update records
Once a record is inserted in the database, we want to give the possibility to our users to modify the record if needed.

The user will have to send the `id` of the record they want to edit and specify which `id` will be used in the backend to update the record with the `UPDATE SQL` statement. To make it easier for the user to pass the record `id`, we’ll refactor the list of records (tasks or projects) in such a way that they are clickable.

# Delete a record
Sometimes editing a record is not enough —we may need to remove it completely and re-enter a new record. That’s where the last letter of our acronym, `D`, comes from.

The main keyword here is `DELETE`.

We will add a “Delete” button from the list of records that we’ll handle in the controller.

Introduction

App Initialization

Create and Read Records

Refactor the Application

PHP Data Validation

Generate Reports

Update and Delete Records

PHP Router

Conclusion

Appendix

Introduction