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

Let’s start our journey by implementing the first two features of our CRUD application, which are represented by the letters “C” and “R.” In the next couple of chapters, we’ll learn how to create, read,  and insert data.

# What we’ll learn
In short, we'll learn to:

* Fetch data from the database.
* Handle an HTML form submission with PHP.
* Insert data into the database.

# What to expect
This chapter consists of the following lessons:

**List All Tasks**

This lesson consists of how to fetch `tasks` from the tasks database table and display them in an unordered list with the help of the `foreach` loop. The generated list is ordered by date.

**Add a Project**

In this lesson, we’ll start writing in the database. We’ll learn how to handle an HTML form and use the `INSERT INTO SQL` statement in a `PHP` program. We’ll specifically write code for inserting projects into the `projects` table.
**Add a Task**
In this lesson, we’ll learn how to write code to insert tasks into the `tasks` table.

Learn what we’ll cover in this chapter.

Introduction

App Initialization

Create and Read Records

Refactor the Application

PHP Data Validation

Generate Reports

Update and Delete Records

PHP Router

Conclusion

Appendix

Introduction