/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

7 votes267 views6 answers
Laravel loop index
PHP Laravel
0 vote217 views1 answer
Laravel form validation based on another field value
PHP Laravel
0 vote273 views1 answer
Laravel eloquent where value less then 5 and greter then 0
PHP Laravel
1 vote200 views1 answer
How to set a validation on a value if its not null in laravel php
PHP Laravel
1 vote332 views1 answer
How to add property to the request object in laravel
PHP Laravel
3 votes249 views3 answers
Clear laravel.log
PHP Laravel
0 vote323 views1 answer
Users not having any role laravel spatie
PHP Laravel
0 vote217 views1 answer
Laravel sanctum axios Unauthenticated
PHP Laravel
5 votes250 views4 answers
Update column type laravel migration
PHP Laravel
0 vote294 views1 answer
Pass array from controller laravel with compact
PHP Laravel