
Get last week data in Laravel
You can get last week data in Laravel. Sometimes you have to get the records which are created at previous week of the current month, in that case you can use whereBetween() method to get the last week records from the database table.
Answers 2
-
Get last week (Saturday to Sunday) created users record in Laravel
--PATH routes\web.phpRoute::get('/get-last-week-users', function(){ $previous_week = strtotime("-1 week +1 day"); $start_week = strtotime("last sunday midnight",$previous_week); $end_week = strtotime("next saturday",$start_week); $start_week = date("Y-m-d",$start_week); $end_week = date("Y-m-d",$end_week); $users = App\Models\User::whereBetween('created_at', [$start_week, $end_week])->get(); dd($users); });
0 -
Get previous 7 days data using today() and subDays() method on Carbon in Laravel
$date = \Carbon\Carbon::today()->subDays(7); $users = App\Models\User::where('created_at','>=',$date)->get(); dd($users);
0
Random Code Snippet Queries: Laravel
- How to create controller in laravel
- Get content from web URL in laravel
- Drop foreign key column in Laravel using migration
- Class 'App\Rules\Hash' not found in Laravel
- Ajax GET request in laravel
- The use statement with non-compound name 'Auth' has no effect
- How to create laravel project using composer
- How to restore multiple records after soft-deletes in Laravel
- How to get only time from created_at in laravel
- How to get list of all views file in laravel
- Link storage folder in laravel 8
- How to call Laravel route in jQuery
- Permission denied error while creating storage link in Laravel
- Get ids in array from users table
- After image selected get validation error in laravel
- How to run a specific seeder class in laravel
- Update email with unique validation in laravel
- Get laravel version
- Remove several global scope from query
- SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key
- How to display user profile after login in laravel
- Import/Use Storage facade in laravel
- How to delete record in Laravel with ajax
- Laravel save object to database
- How to get single column value in laravel