/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

1 vote113 views1 answer
Valet laravel
PHP Laravel
0 vote127 views1 answer
Laravel one session per user
PHP Laravel
0 vote115 views1 answer
Laravel Read multiple file extensions
PHP Laravel
1 vote115 views2 answers
Php password_hash decrypt online
PHP
0 vote107 views1 answer
Magento 2 laravel valet 502 bad gateway
PHP
2 votes91 views2 answers
Dir name php
PHP
0 vote96 views2 answers
Wordpress disable editor
PHP
0 vote108 views1 answer
Rawbetween in laravel
PHP Laravel
0 vote107 views1 answer
How to free session variable in php codeigniter
PHP
1 vote101 views1 answer
Linux nohup write other file
PHP