/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

2 votes321 views2 answers
Laravel dump
PHP Laravel
0 vote368 views1 answer
Start someones laravel project
PHP Laravel
0 vote360 views1 answer
Route pattern cannot reference variable name more than once. laravel
PHP Laravel
9 votes332 views4 answers
Add another field in existing migration laravel
PHP Laravel
1 vote373 views2 answers
Cart::subtotal in laravel
PHP Laravel
0 vote360 views1 answer
Validate rule if row exist laravel
PHP Laravel
0 vote345 views1 answer
Comment php laravel template blade
PHP Laravel
0 vote385 views1 answer
Laravel blade get array count in Blade
PHP Laravel
34 votes376 views4 answers
Make:controller in laravel 8
PHP Laravel
0 vote380 views1 answer
Laravel where and blade
PHP Laravel