/PHP/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

8 votes199 views5 answers
Laravel belongs to
PHP
0 vote259 views1 answer
Laravel get previous route without domain
PHP
2 votes166 views1 answer
Php code to increase maximum execution time
PHP
1 vote177 views1 answer
How to fetch all defined constant in php
PHP
16 votes169 views4 answers
Get user ip in php
PHP
0 vote159 views1 answer
Laravel asset resolving to http not https
PHP
0 vote211 views1 answer
Job execute async laravel
PHP Laravel
0 vote196 views2 answers
How to use php in laravel blade
PHP
1 vote181 views2 answers
Redrectnh to https n laravel
PHP Laravel
6 votes133 views3 answers
Laravel unique validation
PHP