Get 30 days older records from table in laravel
Get 30 days older records from table in laravel
In this session, we’ll try our hand at solving the "Get 30 days older records from table in laravel" puzzle by using the computer language.
Sometimes you have to get the 30 days older records from table in laravel. In the case, this code snippet will help you to get the 30 days older records from the current date from a table.-
Laravel eloquent to get 30 days older records from today's date
//1. WhereRaw() Eloquent Query: $users = \App\Models\User::whereRaw('DATEDIFF(NOW(), created_at) > 30')->get(); dd($users); //2. whereDate() Eloquent Query: $users = \App\Models\User::whereDate('created_at', '<=', now()->subDays(30))->get(); dd($users);
This code snippet will helps you to get all the records which are 30 days older from today's date and return the records as output. You can use any one of the provided code snippet to get all the records which are 30 days older from current date.
-
Get 30 days older records from current date using whereBetween method in Laravel
$startDate = Carbon\Carbon::now()->subDays(30); $endDate = Carbon\Carbon::now(); $users = App\Models\User::select("*")->whereBetween('created_at', [$startDate, $endDate])->get(); dd($users);
This code snippet will help you to get the records from users table which are created between current date and created 30 days before of current date.
If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.
Don't forget to share this article! Help us spread the word by clicking the share button below.
We appreciate your support and are committed to providing you valuable and informative content.
We are thankful for your never ending support.
Random Code Snippet Queries: Laravel
- PhpMyAdmin - Error The mysqli extension is missing
- Get count of filter data, while return a small set of records
- How to insert value to additional columns in pivot table in laravel
- Extra Filter Query on Relationships in Laravel
- Store logged in user details in session and display in view in laravel
- Create project factory and seed data in laravel
- Class 'App\Providers\Auth' not found
- How to get database name in Laravel 9 ?
- How to remove package from laravel
- Seed database using SQL file in Laravel
- There are no commands defined in the "route:" namespace
- Add [name] to fillable property to allow mass assignment on [App\Models\Project]
- Create a record if not exist in laravel
- How to create static page in Laravel
- How to create and run user seeder in laravel
- Laravel URL validation not working
- Method Illuminate\Database\Eloquent\Collection::appends does not exist
- Laravel pagination links with query string
- Sample .htaccess file and index.php file under public directory in laravel
- How to insert multiple rows in mysql using loop in laravel?
- If no route matched route::fallback in laravel
- Laravel form request validation
- Get posts belongs to a specific user in Laravel
- Where to use whereNotNull eloquent in laravel
- How to create project_user pivot table in laravel