/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 vote226 views1 answer
Laravel + join 2 eloquent queries
PHP Laravel
6 votes256 views4 answers
Laravel url previous
PHP Laravel
0 vote231 views1 answer
Require and include difference in laravel
PHP Laravel
0 vote225 views1 answer
Update session laravel
PHP Laravel
5 votes219 views4 answers
Laravel response redirect
PHP Laravel
2 votes217 views2 answers
Laravel insert timestamp now
PHP Laravel
12 votes271 views2 answers
Creating a Basic Route in Laravel 8
PHP Laravel
1 vote249 views1 answer
Laravel command parameter optional
PHP Laravel
0 vote253 views1 answer
Get data from 2 table in response laravel
PHP Laravel
19 votes226 views6 answers
Laravel logger
PHP Laravel