/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

1 vote194 views1 answer
Laravel export make comman
PHP Laravel
4 votes180 views6 answers
Laravel 8 authentication
PHP Laravel
2 votes223 views2 answers
Laravel validate form data unique
PHP Laravel
0 vote199 views1 answer
Laravel return a single dimensional array
PHP Laravel
3 votes191 views3 answers
Where with and and or in a laravel
PHP Laravel
0 vote185 views1 answer
Laravel validation rules for video upload
PHP Laravel
2 votes192 views1 answer
Carbon time ago laravel
PHP Laravel
29 votes198 views3 answers
Laravel clear page cache
PHP Laravel
0 vote195 views1 answer
Laravel make view command
PHP Laravel
1 vote202 views1 answer
Laravel pusher broadcasting/auth 403
PHP Laravel