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 this appendix, we’ll discuss the tools that we need to run PHP projects on our local machines.

In short, we’ll discuss:
- The LAMP stack that we can use.
- The editor.
- The version control.
- The browser.



# The LAMP stack
There are two main ways to set up an “AMP” stack on your computer:

- We can install each component separately. This approach is loved by many folks in GNU/Linux. 
- We can also use a ready-to-use bundle or package. This approach is preferred by folks who use Windows or Mac.

Let’s see some examples of the most used “AMP-like” software bundles:


* **[XAMPP](https://www.apachefriends.org/index.html)**, which is available on all major OSs
* **[WAMPServer](https://www.wampserver.com/)** or **[Laragon](https://laragon.org/)**, which is available only on Windows
* **[MAMP](https://www.mamp.info/en/downloads/)**, which is available on Windows and Mac OSs

> **Note:** We should also consider using the Docker solution.

Before we continue, let’s ensure that we can successfully run the following code snippet:


```php
<p>Hello, world! The date of today is <?php echo date("d-m-Y"); ?>.</p>
```
We’ll create an `index.php` file and put the code given above inside it.

We can also test our integrated environment by clicking the “Run” button below:

Learn how to set up a local environment for PHP development.

Introduction

App Initialization

Create and Read Records

Refactor the Application

PHP Data Validation

Generate Reports

Update and Delete Records

PHP Router

Conclusion

Appendix

PHP Development Environment

The LAMP stack