/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 vote198 views3 answers
Move_uploaded_file
PHP
0 vote169 views1 answer
Php send 204
PHP
0 vote156 views1 answer
How to create compomemt in laravel livewire
PHP
0 vote192 views1 answer
Wp retrieve acf by category name
PHP Wordpress
-1 vote164 views4 answers
How to include file in laravel blade
PHP
10 votes180 views1 answer
Php sort array by subarray value
PHP
0 vote197 views2 answers
Laravel query where and
PHP Laravel
3 votes204 views2 answers
Php convert unix time to date
PHP
0 vote171 views1 answer
Heroku deploy php
PHP
0 vote185 views2 answers
Laravel blade components
PHP