/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 vote294 views2 answers
How to rollback if one table in laravel didn't save data successfully
PHP Laravel
0 vote315 views2 answers
Wherebetween in laravel
PHP Laravel
2 votes337 views2 answers
Laravel forcefill
PHP Laravel
4 votes314 views2 answers
Display all errors at once in laravel
PHP Laravel
2 votes313 views1 answer
Laravel set appends
PHP Laravel
0 vote307 views1 answer
Using laravel passport with mongodb
PHP Laravel
0 vote323 views1 answer
Laravel 404 not found not showing error
PHP Laravel
1 vote354 views1 answer
Edit data using model in laravel 8
PHP Laravel
1 vote329 views4 answers
How to fix 419 page expired in laravel
PHP Laravel
3 votes360 views2 answers
Get image width and height in laravel
PHP Laravel