Answers for "how to list all months in the year with values in laravel 8"

PHP
0

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');
Posted by: Guest on June-07-2020
1

where year month laravel

$q->whereDay('created_at', '=', date('d'));
$q->whereMonth('created_at', '=', date('m'));
$q->whereYear('created_at', '=', date('Y'));
Posted by: Guest on July-11-2020

Code answers related to "how to list all months in the year with values in laravel 8"

Browse Popular Code Answers by Language