/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 vote222 views1 answer
Add query string to url laravel
PHP Laravel
2 votes239 views4 answers
Laravel run schedule locally
PHP Laravel
1 vote234 views1 answer
Laravel @canany
PHP Laravel
18 votes240 views4 answers
Use if in laravel blade
PHP Laravel
0 vote267 views1 answer
Laravel resourece type
PHP Laravel
17 votes247 views6 answers
Laravel auth user in constructor
PHP Laravel
0 vote250 views1 answer
Diffforhumans laravel
PHP Laravel
4 votes242 views4 answers
Raw queries in laravel
PHP Laravel
0 vote266 views1 answer
Subdomain in laravel and xampp
PHP Laravel
22 votes261 views5 answers
Get logged user id laravel
PHP Laravel