/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

0 vote313 views2 answers
Php curl ssl verify
PHP
2 votes301 views1 answer
Php code to increase maximum execution time
PHP
0 vote318 views2 answers
Laravel santum
PHP Laravel
13 votes354 views3 answers
How to change existing migration laravel
PHP Laravel
8 votes298 views3 answers
How to check if user is logged in wordpress
PHP
0 vote341 views1 answer
Laravel validate number to be at least 3 digits
PHP Laravel
1 vote292 views1 answer
How get the latest data in database in laravel
PHP
0 vote322 views1 answer
Php get json objects by key without indez
PHP
0 vote282 views1 answer
Laravel controller data update
PHP
3 votes355 views3 answers
Laravel if database has table
PHP Laravel