/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 vote373 views1 answer
Getoriginal laravel
PHP Laravel
0 vote371 views1 answer
Stdclass not found laravel
PHP Laravel
0 vote327 views1 answer
RequestCriteria laravel
PHP Laravel
0 vote371 views2 answers
Laravel limit foreach
PHP Laravel
4 votes281 views1 answer
Withcookie laravel
PHP Laravel
0 vote345 views1 answer
Laravel model where set fields laravel
PHP Laravel
0 vote349 views1 answer
Exists:categories,id except a value laravel
PHP Laravel
0 vote375 views2 answers
What is composer in laravel
PHP Laravel
0 vote355 views1 answer
Laravel adding new items to config run time
PHP Laravel
3 votes377 views1 answer
Run laravel cron job on cpanel
PHP Laravel