/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

23 votes329 views6 answers
Laravel model insert
PHP Laravel
0 vote341 views1 answer
Laravel display the date the participation was created
PHP Laravel
4 votes350 views4 answers
Multiple middleware laravel
PHP Laravel
0 vote322 views1 answer
Get return value from another function laravel
PHP Laravel
0 vote369 views1 answer
Laravel eloquent pass to next element
PHP Laravel
3 votes319 views6 answers
Laravel find query
PHP Laravel
0 vote349 views1 answer
Laravel 404 not found not showing error
PHP Laravel
0 vote346 views1 answer
__invoke in laravel
PHP Laravel
5 votes315 views2 answers
Laravel collection chunk
PHP Laravel
1 vote355 views1 answer
Laravel validateexception no error description
PHP Laravel