/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 vote214 views1 answer
How to increase request timeout in laravel
PHP Laravel
0 vote242 views1 answer
Create char laravel migration
PHP Laravel
0 vote329 views2 answers
Asset function in laravel not working
PHP Laravel
0 vote259 views4 answers
Upload image in laravel
PHP Laravel
2 votes244 views2 answers
How to show limited text in laravel on page
PHP Laravel
1 vote201 views1 answer
Trim laravel
PHP Laravel
0 vote232 views1 answer
Laravel array length
PHP Laravel
8 votes349 views2 answers
Laravel drop multiple columns
PHP Laravel
8 votes307 views5 answers
Wherebetween laravel
PHP Laravel
9 votes220 views3 answers
Laravel with select
PHP Laravel