/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

6 votes290 views2 answers
How many products can a laravel ecommerce handle
PHP Laravel
26 votes309 views6 answers
Laravel validation integer
PHP Laravel
2 votes276 views1 answer
Get the current route in laravel
PHP Laravel
0 vote316 views1 answer
Laravel collection all
PHP Laravel
44 votes297 views4 answers
Laravel random string
PHP Laravel
13 votes327 views5 answers
Laravel get last record
PHP Laravel
0 vote329 views1 answer
Load differenet .env file in laravel
PHP Laravel
0 vote354 views1 answer
Laravel app service provider why eloquent model error
PHP Laravel
0 vote328 views2 answers
Laravel "query()->find"
PHP Laravel
6 votes340 views1 answer
Laravel eloquent whereDateBetween
PHP Laravel