/PHP/Laravel/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 vote135 views1 answer
Laravel compile assets
PHP Laravel
0 vote157 views1 answer
Spatie laravel pdf image
PHP Laravel
1 vote138 views1 answer
Get data based on date in laravel
PHP Laravel
0 vote170 views1 answer
Diffforhumans laravel
PHP Laravel
10 votes172 views4 answers
Laravel migration change column default
PHP Laravel
2 votes146 views1 answer
Multiple routes same controller laravel
PHP Laravel
50 votes296 views6 answers
Laravel database seeder
PHP Laravel
2 votes156 views3 answers
How to change the colum type in migration laravel
PHP Laravel
0 vote130 views1 answer
Laravel vue build production
PHP Laravel
4 votes140 views2 answers
Laravel kill current session
PHP Laravel