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

We’ve learned a lot throughout this course. Here are some key takeaways:
- To connect to the database in PHP, use the PDO extension like this: `$connection = new PDO($dsn, $username, $password, $options);`
- To run a query, we either use the `PDO::query` method if no variable is going to be used in the query or the `prepare()` and `execute()` functions if at least one variable is going to be used.
- It doesn’t really matter if we’re running our query with the `SELECT`, `INSERT`, `UPDATE`, or `DELETE` statement.
- MVC is an architectural pattern that is used to break up code into three logical components: model, view, and controller.
- We should never trust user-submitted data. We should always check for validation, both on the client-side and the server-side.
- Routing consists of mapping an HTTP request to a request handler, which can either be a function or a method.


# Next step
We are grateful to you for learning with us. This course was only a small step towards the more advanced topics in PHP. There are still many things you may need to learn to feel more comfortable working with PHP.

But remember, grasping the concepts of programming takes time and practice. As they say, Rome wasn’t built in a day. Every professional developer that you know, or meet will have taken the same path.


## Keep on practicing
We all know that practice makes perfect. So, if you want to become more confident as a PHP developer,  practice your craft on a regular basis. In particular, we urge you to start building a personal project right now. This is the best way to stay focused and create something meaningful while having fun along the way. You may already have a project idea in the back of your mind. If not, here are a few ideas:
* A medicine dose tracker web application, like the one described [here](https://www.codementor.io/projects/web/medicine-dose-tracker-b6evlas194).
* A CMS, like WordPress. Get inspiration [here](https://ilovephp.jondh.me.uk/en/tutorial/make-your-own-blog).
* Other PHP projects in this [Github repository](https://github.com/danistefanovic/build-your-own-x).

We’ve learned a lot throughout this course. Here are some key takeaways:
- To connect to the database in PHP, use the PDO extension like this: `＄connection = new PDO(＄dsn, ＄username, ＄password, ＄options);`
- To run a query, we either use the `PDO::query` method if no variable is going to be used in the query or the `prepare()` and `execute()` functions if at least one variable is going to be used.
- It doesn’t really matter if we’re running our query with the `SELECT`, `INSERT`, `UPDATE`, or `DELETE` statement.
- MVC is an architectural pattern that is used to break up code into three logical components: model, view, and controller.
- We should never trust user-submitted data. We should always check for validation, both on the client-side and the server-side.
- Routing consists of mapping an HTTP request to a request handler, which can either be a function or a method.


# Next step
We are grateful to you for learning with us. This course was only a small step towards the more advanced topics in PHP. There are still many things you may need to learn to feel more comfortable working with PHP.

But remember, grasping the concepts of programming takes time and practice. As they say, Rome wasn’t built in a day. Every professional developer that you know, or meet will have taken the same path.


## Keep on practicing
We all know that practice makes perfect. So, if you want to become more confident as a PHP developer,  practice your craft on a regular basis. In particular, we urge you to start building a personal project right now. This is the best way to stay focused and create something meaningful while having fun along the way. You may already have a project idea in the back of your mind. If not, here are a few ideas:
* A medicine dose tracker web application, like the one described [here](https://www.codementor.io/projects/web/medicine-dose-tracker-b6evlas194).
* A CMS, like WordPress. Get inspiration [here](https://ilovephp.jondh.me.uk/en/tutorial/make-your-own-blog).
* Other PHP projects in this [Github repository](https://github.com/danistefanovic/build-your-own-x).

This lesson summarizes everything that we have covered in this course.

Introduction

App Initialization

Create and Read Records

Refactor the Application

PHP Data Validation

Generate Reports

Update and Delete Records

PHP Router

Conclusion

Appendix

Summary and Perspectives