/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

0 vote152 views1 answer
Indirect modification of overloaded property has no effect laravel
PHP Laravel
1 vote152 views1 answer
How to define variable as object in blade laravel
PHP Laravel
0 vote147 views1 answer
Appserviceprovider laravel auth user
PHP Laravel
11 votes161 views3 answers
Blade condition if else laravel
PHP Laravel
1 vote145 views1 answer
Laravel query get big table records
PHP Laravel
0 vote145 views1 answer
Laravel bd query
PHP Laravel
2 votes151 views2 answers
Laravel now date
PHP Laravel
0 vote145 views1 answer
Laravel notification attach file
PHP Laravel
0 vote147 views1 answer
Laravel array length
PHP Laravel
2 votes157 views2 answers
Laravel validation if data exists
PHP Laravel