/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 vote323 views1 answer
Password validation rules laravel
PHP Laravel
0 vote370 views1 answer
What is actullay work model in laravel
PHP Laravel
1 vote315 views4 answers
Laravel module package
PHP Laravel
0 vote335 views1 answer
Laravel chain query builder
PHP Laravel
0 vote353 views3 answers
Permissions for laravel deployment
PHP Laravel
2 votes358 views1 answer
Laravel check if session variable exists
PHP Laravel
0 vote385 views1 answer
Laravel nova field required
PHP Laravel
0 vote341 views1 answer
Laravel migrate if not exists
PHP Laravel
0 vote393 views1 answer
Extensions for laravel command ubuntu 20.04
PHP Laravel
0 vote349 views1 answer
Laravel excel set cell height
PHP Laravel