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

Our application works quite well. However, it’s not professional yet. This is because we’re calling the corresponding file in the URL for each page request. This is a problem. Let’s see why.

# The problem
The way that our application is handling the HTTP request is not very smart:
- The URI is not elegant.
- It allows for security issues since we’re revealing the internal structure of our files.


Let's take an example of the `projects list` URI: 
```
local.tracker.com/controllers/project_list.php
```
As we can see, the URI is too long and passes the exact path to the file.

We would prefer for our code to be simple like we see on many sites or applications:

```
local.tracker.com/list
```
or to distinguish it from `tasks list`:
```
local.tracker.com/projects/list
```

Here, we're no longer directly calling any file in the URI.

# The solution: routing
Simply speaking, the routing consists of mapping an HTTP request to a request handler, which can be a function or a method.

Let’s take an example and break it down so that we can understand how the routing system works.


```
local.tracker.com/list
```

1. The application receives the request, via the `router` or frontal controller.
2. It decomposes the request (header) to determine the method (`GET`, `POST`…), path, host, and so on.
3. The application will look for a defined route that matches the request.
4. Once found, it will take the defined action and return a response to the user.

As we can see from the steps listed above, we need to create a router and redirect all the requests there.

Although in a real-world application, we’ll need to use a robust routing system like that of [Symfony](https://symfony.com/doc/current/routing.html), in this course, we’ll build the system from scratch so that we learn how routing works in most frameworks.






We defined a GET route for the `/list` URI which returns a response when, when a user calls it. In our case, it returns the list view.

Learn how to handle user requests and call the appropriate file (content).

Introduction

App Initialization

Create and Read Records

Refactor the Application

PHP Data Validation

Generate Reports

Update and Delete Records

PHP Router

Conclusion

Appendix

Introduction to PHP Router