/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

0 vote234 views1 answer
Upgrade php linux
PHP
1 vote246 views1 answer
Php upload file via curl
PHP
0 vote270 views2 answers
Carbon Format date with timezone in views Laravel
PHP Laravel
0 vote237 views2 answers
Unique sql queries laravel
PHP
0 vote208 views1 answer
Wordpress options
PHP
0 vote219 views1 answer
Php conditionally remove element from array
PHP
3 votes229 views2 answers
Laravel collection find duplicates
PHP
1 vote221 views1 answer
Acf repeater example count
PHP
1 vote229 views1 answer
Getoriginal laravel
PHP
1 vote227 views1 answer
Why storage link do not work in host for laravel
PHP