Hands-on PHP & MySQL: Build a CRUD Application/

...

Filter by Date

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

We'll cover the following...

Feature implementation
Run the code

Press + to interact

<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>

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