/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

1 vote235 views4 answers
Laravel object to array
PHP Laravel
1 vote220 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_api.sessions' doesn't exist (SQL: select * from `sessions` where `id` = sXWuwluhxC2HlCzzq7jDyPGJFriLGdxQj8bPtcgC limit 1)
PHP Laravel
0 vote211 views1 answer
Laravel blade array seearch select box
PHP Laravel
2 votes225 views2 answers
Laravel get random number of data from database
PHP Laravel
7 votes202 views2 answers
Php laravel between dates
PHP Laravel
0 vote226 views1 answer
Was loaded over https, but requested an insecure xmlhttprequest endpoint laravel
PHP Laravel
22 votes230 views6 answers
Log Laravel
PHP Laravel
46 votes306 views3 answers
How to check laravel version in cmd
PHP Laravel
1 vote219 views2 answers
Laravel blade dump
PHP Laravel
0 vote214 views1 answer
Laravel app service provider why eloquent model error
PHP Laravel