/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

21 votes159 views4 answers
Laravel where not
PHP Laravel
4 votes166 views2 answers
Laravel collection count
PHP Laravel
5 votes166 views6 answers
Laravel sort collection
PHP Laravel
0 vote175 views1 answer
How to add page link in laravel
PHP Laravel
1 vote192 views2 answers
Many to many relationship laravel example
PHP Laravel
0 vote183 views2 answers
Laravel migration change column order
PHP Laravel
1 vote181 views1 answer
Integer nullable laravel
PHP Laravel
0 vote182 views1 answer
Laravel Add regx on password
PHP Laravel
14 votes163 views6 answers
Transaction in laravel
PHP Laravel
0 vote164 views1 answer
Query without chaining not working - Laravel
PHP Laravel