/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 vote394 views1 answer
Laravel update all relations
PHP Laravel
1 vote391 views1 answer
How match array in laravel collection
PHP Laravel
2 votes357 views1 answer
Global laravel request()
PHP Laravel
0 vote394 views4 answers
How to redirect to another page after login in laravel
PHP Laravel
6 votes368 views3 answers
Laravel ide-helper
PHP Laravel
0 vote368 views1 answer
Laravel optional params
PHP Laravel
26 votes397 views6 answers
Laravel make model with migration and controller
PHP Laravel
0 vote340 views2 answers
Laravel get request in blade
PHP Laravel
0 vote401 views1 answer
Laravel range query
PHP Laravel
2 votes321 views5 answers
Laravel drop table migration
PHP Laravel