/PHP/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

28 votes192 views5 answers
Laravel whereRaw
PHP
1 vote201 views1 answer
Php decode html special characters
PHP
0 vote207 views2 answers
Wp max revisions
PHP
2 votes216 views2 answers
Laravel validation unique email except self
PHP Laravel
6 votes218 views3 answers
Laravel passport login with username
PHP Laravel
0 vote301 views1 answer
Artisan::call for all catch clear in laravel
PHP Laravel
0 vote214 views1 answer
Laravel make view command
PHP Laravel
9 votes223 views4 answers
Laravel group route controller
PHP Laravel
0 vote179 views2 answers
Php polymorphism
PHP
0 vote194 views1 answer
Composer in serveur ionos
PHP