/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 votes158 views1 answer
Return back in blade laravel
PHP Laravel
1 vote144 views1 answer
Laravel set field unique
PHP Laravel
1 vote156 views3 answers
How to create controller in specific folder laravel
PHP Laravel
9 votes165 views3 answers
Laravel documentation
PHP Laravel
0 vote142 views1 answer
Country code validation in laravel
PHP Laravel
9 votes143 views3 answers
Laravel validation image or file
PHP Laravel
0 vote99 views1 answer
If notexists in laravel query
PHP Laravel
0 vote154 views2 answers
Nested array in laravel
PHP Laravel
1 vote149 views2 answers
Laravel query relationship nested
PHP Laravel
23 votes151 views4 answers
Laravel carbon isoformat
PHP Laravel