/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

0 vote293 views1 answer
Maintaining serial number in laravel pagination table
PHP Laravel
-1 vote287 views2 answers
Laravel model save get id
PHP Laravel
1 vote290 views1 answer
Where date laravel
PHP Laravel
8 votes276 views3 answers
Laravel check record exists
PHP Laravel
0 vote308 views1 answer
Curl error (code 3) url malformed laravel
PHP Laravel
1 vote308 views1 answer
Laravel validateexception no error description
PHP Laravel
0 vote266 views1 answer
Laravel valet subdomain
PHP Laravel
2 votes316 views2 answers
Laravel many to many update all pivot
PHP Laravel
0 vote241 views1 answer
How can we check in the table in comma separated values in laravel
PHP Laravel
0 vote296 views1 answer
Howw to see if a value is posted laravel
PHP Laravel