Laravel Eloquent makes it very easy to grab records for different set of conditions. In this short post, let’s see how it is to get all the records in your table that are created today, created yesterday, or created in this month.
Consider you have a Post model and the associated posts table in the database.
1. Get all the Posts created today.
Post::whereDate('created_at', Carbon::today())->get();
2. Get all the Posts created yesterday.
Post::whereDate('created_at', Carbon::yesterday())->get();
3. Get all the Posts created in this month.
Post::whereMonth('created_at', Carbon::now()->month)->get();
Make sure to include the following line at the top of your file to import the Carbon class:
use Carbon\Carbon;
Note that the get() method is used at the end of each query to retrieve the results. If you want to retrieve a single record, you can use the first() method instead of get().