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

To filter by date, we can use the parameters as::
- Last week.
- The present week.
- Last month.
- The present month.


Let’s see how we can filter the data by date.

## Feature implementation


In our view, we can add this:

To filter by date, we can use the parameters as::
- Last week.
- The present week.
- Last month.
- The present month.


Let’s see how we can filter the data by date.

# Feature implementation


In our view, we can add this:

Write the code to filter by date —last week, this week, last month, this month…, and so on.

Introduction

App Initialization

Create and Read Records

Refactor the Application

PHP Data Validation

Generate Reports

Update and Delete Records

PHP Router

Conclusion

Appendix

Filter by Date

Feature implementation