/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

2 votes253 views2 answers
How to make doctrine schema update in symfony 2.8
PHP Symfony
17 votes222 views5 answers
Wordpress debug mode
PHP Wordpress
0 vote156 views1 answer
Data type for price in laravel
PHP Laravel
7 votes156 views10 answers
Php .com
PHP
1 vote141 views1 answer
Laravel Validation check array size min and max
PHP
0 vote150 views1 answer
Laravel migration type to store html
PHP
2 votes133 views2 answers
Payizone
PHP
7 votes127 views2 answers
Laravel 8 query builder, Inner Join Clause
PHP
23 votes156 views4 answers
Laravel carbon isoformat
PHP Laravel
0 vote142 views1 answer
Url() inside laravel config files
PHP