/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

12 votes311 views6 answers
Laravel validation
PHP Laravel
0 vote323 views1 answer
Laravel collection pull
PHP
1 vote288 views1 answer
Php function exists
PHP
3 votes345 views2 answers
Return last inserted id in laravel
PHP Laravel
2 votes388 views2 answers
Get session id in laravel
PHP Laravel
-1 vote258 views2 answers
What does !count mean laravel
PHP
3 votes241 views2 answers
How to uninstall laravel
PHP
0 vote321 views2 answers
Laravel get url without domain in blade
PHP
0 vote318 views1 answer
Check which device is used to open webpage php
PHP
0 vote314 views2 answers
Php glob
PHP