/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 vote320 views1 answer
Toast in laravel
PHP Laravel
0 vote347 views1 answer
Laravel collection prepend
PHP Laravel
0 vote301 views4 answers
Laravel 8: bootstrap
PHP Laravel
10 votes314 views6 answers
Format time laravel
PHP Laravel
0 vote317 views2 answers
Login with email and phone laravel
PHP Laravel
4 votes293 views4 answers
Search in laravel 8
PHP Laravel
18 votes313 views5 answers
If statement in laravel blade
PHP Laravel
1 vote333 views1 answer
How convert big text to array that text have br in laravel
PHP Laravel
0 vote394 views1 answer
Composer require rtconner/laravel-tagging
PHP Laravel
-1 vote319 views1 answer
Clear Caching of Queries Laravel Specific Model Cache
PHP Laravel