/PHP/Laravel/Laravel Eloquent, group by month/year

Laravel Eloquent, group by month/year

$model->select(DB::raw('count(id) as `data`'), DB::raw("DATE_FORMAT(created_at, '%m-%Y') new_date"),  DB::raw('YEAR(created_at) year, MONTH(created_at) month'))
->groupby('year','month')
->get();

Similar codes

5 votes165 views5 answers
Install laravel 8 with composer
PHP Laravel
12 votes153 views2 answers
Debug bar laravel print array
PHP Laravel
1 vote164 views1 answer
How to catch query exception in laravel 8
PHP Laravel
3 votes158 views1 answer
Enie letter validation laravel regex
PHP Laravel
0 vote188 views1 answer
Laravel eloquent where value less then 5 and greter then 0
PHP Laravel
0 vote147 views1 answer
Laravel carbon subtract minutes to current time
PHP Laravel
0 vote165 views2 answers
Laravel file path
PHP Laravel
0 vote124 views1 answer
Laravel migrate patth
PHP Laravel
3 votes158 views3 answers
Laravel make view
PHP Laravel
0 vote163 views1 answer
Laravel value eloquent
PHP Laravel