/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 vote240 views1 answer
How to create module in laravel
PHP Laravel
9 votes220 views4 answers
Laravel soft delete example
PHP Laravel
0 vote211 views1 answer
Expression #1 of ORDER BY contains aggregate function and applies to the result of a non-aggregated query laravel
PHP Laravel
7 votes208 views3 answers
Laravel search function
PHP Laravel
0 vote221 views2 answers
Laravel collection collect
PHP Laravel
0 vote208 views1 answer
Using laravel passport with mongodb
PHP Laravel
26 votes246 views6 answers
Carbon in laravel
PHP Laravel
2 votes215 views1 answer
Delete confirmation destroy laravel
PHP Laravel
0 vote201 views1 answer
Laravel controller constructor auth user null
PHP Laravel
5 votes198 views3 answers
Laravel get parameters from request
PHP Laravel