/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

0 vote117 views1 answer
Laravel weekly data
PHP
0 vote116 views2 answers
Old codestar text field
PHP
1 vote124 views1 answer
How create page 419 in laravel
PHP Laravel
0 vote120 views2 answers
Remove decimal php
PHP
0 vote143 views1 answer
Laravel npm build production
PHP Laravel
0 vote113 views1 answer
Wordpress remove taxonomy from post
PHP
52 votes128 views6 answers
Php now
PHP
0 vote129 views1 answer
Igaster\Laravel Theme\Exceptions\theme Already Exists
PHP Laravel
2 votes133 views1 answer
Wordpress display all variables
PHP
0 vote111 views1 answer
Laravel Mix npm run production error
PHP