/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

4 votes114 views1 answer
Refresh a specific migration in laravel
PHP Laravel
1 vote118 views3 answers
Laravel function to check if image exist or not
PHP Laravel
0 vote108 views2 answers
Laravel run schedule only on production
PHP Laravel
5 votes121 views2 answers
Laravel print exception message
PHP Laravel
26 votes115 views6 answers
Laravel model with migration
PHP Laravel
0 vote106 views1 answer
Refresh web route laravel
PHP Laravel
1 vote116 views4 answers
Create json laravel
PHP Laravel
2 votes114 views3 answers
How to change the colum type in migration laravel
PHP Laravel
0 vote109 views1 answer
Laravel get only validated data
PHP Laravel
2 votes117 views4 answers
How to create controller inside folder in laravel
PHP Laravel