/PHP/Laravel/Laravel eloquent get 3 months

Laravel eloquent get 3 months

$dateS = Carbon::now()->startOfMonth()->subMonth(3);
$dateE = Carbon::now()->startOfMonth(); 
$TotalSpent = DB::table('orders')
->select('total_cost','placed_at')
->whereBetween('placed_at',[$dateS,$dateE])
->where(['deleted' => '0', 'delivery_address_id' => $DeliveryAddress->id])
->sum('total_cost');

Source: stackoverflow.com

Similar codes

3 votes196 views2 answers
Laravel find by field
PHP Laravel
0 vote198 views1 answer
How to get post by comment in laravel
PHP Laravel
0 vote189 views1 answer
Laravel password require one letter and one number
PHP Laravel
4 votes190 views5 answers
Laravel get first record
PHP Laravel
0 vote221 views1 answer
Array helper array_push laravel
PHP Laravel
4 votes192 views4 answers
Installing laravel 8
PHP Laravel
13 votes201 views6 answers
Prefix laravel route
PHP Laravel
33 votes186 views6 answers
How to run a specific migration in laravel
PHP Laravel
0 vote200 views1 answer
Modifier laravel migration to add a comment a column (MySQL/PostgreSQL)
PHP Laravel
11 votes200 views6 answers
Laravel create resource
PHP Laravel