/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 vote137 views1 answer
Laravel move/rename file ftp
PHP Laravel
26 votes131 views4 answers
Carbon date time laravel
PHP Laravel
2 votes149 views2 answers
Laravel websockets
PHP Laravel
6 votes145 views3 answers
Previous url laravel
PHP Laravel
1 vote141 views1 answer
How check if variable is resgister in laravel
PHP Laravel
6 votes157 views1 answer
Laravel route param blade
PHP Laravel
2 votes142 views1 answer
Laravel sluggable
PHP Laravel
0 vote199 views1 answer
Laravel include files
PHP Laravel
3 votes143 views2 answers
Laravel eloquent search query 2020
PHP Laravel
5 votes136 views3 answers
Enum table in laravel
PHP Laravel