/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 vote153 views1 answer
Break and continue in laravel
PHP Laravel
1 vote194 views1 answer
How laravel return the old value
PHP Laravel
-1 vote119 views4 answers
Laravel collection find
PHP Laravel
4 votes122 views2 answers
Laravel get authorization bearer token
PHP Laravel
1 vote136 views1 answer
Laravel images mimetypes validatiion
PHP Laravel
0 vote132 views1 answer
Laravel require vendor autoload
PHP Laravel
-1 vote208 views1 answer
Laravel seo
PHP Laravel
1 vote82 views1 answer
Laravel model find one
PHP Laravel
2 votes77 views1 answer
Laravel create txt file
PHP Laravel
0 vote144 views2 answers
View blade not found in laravel
PHP Laravel