/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 vote200 views1 answer
Laravel store blob image into database
PHP Laravel
0 vote183 views1 answer
How to use union and intersection in laravel query
PHP Laravel
29 votes203 views3 answers
Laravel clear page cache
PHP Laravel
1 vote202 views1 answer
Check if url is https laravel
PHP Laravel
3 votes188 views1 answer
Laravel web.php auth Undefined type 'Auth'.
PHP Laravel
0 vote191 views2 answers
Laravel apiresource
PHP Laravel
1 vote235 views1 answer
Laravel collection toJson
PHP Laravel
1 vote189 views1 answer
Laravel model created_at format edit
PHP Laravel
7 votes228 views3 answers
Laravel migration seed fresh
PHP Laravel
2 votes213 views2 answers
Laravel many to many update all pivot
PHP Laravel