/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 vote349 views1 answer
Laravel eloquent many to many query using whereHas
PHP Laravel
11 votes341 views4 answers
Redirect back with input laravel in request
PHP Laravel
1 vote360 views1 answer
Increament single column laravel current value + 1
PHP Laravel
9 votes352 views4 answers
Composer laravel ui
PHP Laravel
1 vote341 views4 answers
Laravel create multiple rows
PHP Laravel
2 votes369 views3 answers
Spartie all user with role get laravel
PHP Laravel
0 vote350 views2 answers
Laravel loop variable
PHP Laravel
0 vote356 views1 answer
Laravel orm latest()
PHP Laravel
14 votes363 views5 answers
Laravel model tablename
PHP Laravel
0 vote354 views1 answer
Multipart json test laravel
PHP Laravel