/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 vote305 views1 answer
Reverse array laravel
PHP Laravel
0 vote179 views1 answer
Laravel collection partition
PHP
0 vote177 views1 answer
Laravel post index method
PHP
0 vote664 views1 answer
How to remove words in contain integer php
PHP
0 vote203 views1 answer
Wordpress html classes
PHP Wordpress
2 votes209 views2 answers
Laravel read json file from storage
PHP
45 votes212 views6 answers
Foreach loop in php
PHP
0 vote218 views1 answer
Verzeichnis einlesen php
PHP
0 vote206 views1 answer
Country code validation in laravel
PHP Laravel
0 vote166 views1 answer
Wordpress register_post_type capability gutenberg
PHP