/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

2 votes310 views2 answers
How uninstall the laravel
PHP Laravel
24 votes275 views6 answers
Laravel create method
PHP Laravel
0 vote293 views5 answers
Date format change in laravel
PHP Laravel
0 vote299 views1 answer
Laravel curl request
PHP Laravel
12 votes270 views6 answers
Run seeder in migration laravel
PHP Laravel
0 vote296 views1 answer
Custom timestamp column laravel
PHP Laravel
16 votes276 views3 answers
Laravel request validate
PHP Laravel
1 vote272 views1 answer
How delete the table in laravel in the commend
PHP Laravel
0 vote315 views1 answer
Make controller laravel history open link
PHP Laravel
34 votes301 views6 answers
Laravel create controller with methods
PHP Laravel