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:

<optgroup label="Date">
	<option value="date:<?php
                                        echo date('m/d/y', strtotime("last week monday"));
                                        echo ":";
                                        echo date('m/d/y', strtotime("last week sunday"));
                                        ?>
                    ">Last Week</option>
	<option value="date:<?php
                                        echo date('m/d/y', strtotime("this week monday"));
                                        echo ":";
                                        echo date('m/d/y', strtotime("this week sunday"));
                                        ?>
                    ">This Week</option>
	<option value="date:<?php
                                        echo date('m/d/y', strtotime("first day of last month"));
                                        echo ":";
                                        echo date('m/d/y', strtotime("last day of last month"));
                                        ?>
                    ">Last Month</option>
	<option value="date:<?php
                                        echo date('m/d/y', strtotime("first day of this month"));
                                        echo ":";
                                        echo trim(date('m/d/y')); ?>
                    ">This Month</option>
</optgroup>

Notice that the displaydate was formatted as `09/23/20`. We used [strtotime](https://www.php.net/manual/en/function.strtotime.php) to get the date that was required from a given string.

If the current day was `09/21/20`, `strtotime("last week monday")` would be converted to `09/14/20`. We can live test this [here](https://strtotime.co.uk/?str=last+week+monday).



> **Note:** We are defining a range for our date filter, for example, from `09/14/20` to `09/20/20`.

We have nothing to do with the controller, so let’s go to the model.

Because we will need to implement filtering by at least three options, we’ll use `switch/case` instead of `if/else`.

```
if (is_array($filter)) {
       switch ($filter[0]) {
           case 'project':
                 $where = ' WHERE p.id = ?';
                 break;
           case 'date':
                 $where = ' WHERE DATE_FORMAT(t.date_task, "%m/%d/%y") >= ?  AND DATE_FORMAT(t.date_task, "%m/%d/%y" ) <= ?';
                 break;
            }
        }
```
Now we can bind the placeholder values for the date like this:

```
if ($filter[0] == 'date') {
                $tasks->bindValue(1, $filter[1], PDO::PARAM_STR);
                $tasks->bindValue(2, trim($filter[2]), PDO::PARAM_STR);
            }
```
That’s all. Now we can go to the browser and see how it works.

# Run the code
In case you need a review, you can find the code used throughout this chapter here. 

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