/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

2 votes262 views2 answers
How to use vue 3 in laravel 8
PHP Laravel
1 vote235 views1 answer
Start server in laravel
PHP Laravel
25 votes234 views2 answers
Clear cache without using composer in laravel 8
PHP Laravel
0 vote230 views1 answer
Laravel This package is not auto-updated. Please set up the GitHub Hook for Packagist so that it gets updated whenever you push!
PHP Laravel
7 votes238 views2 answers
Laravel get session variable in controller
PHP Laravel
1 vote245 views1 answer
Laravel form action with parameter
PHP Laravel
29 votes247 views3 answers
Laravel clear page cache
PHP Laravel
0 vote232 views1 answer
Laravel seed timestamps columns
PHP Laravel
2 votes351 views1 answer
How to set field type of date of birth in laravel
PHP Laravel
1 vote230 views1 answer
Integer default value laravel
PHP Laravel