/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

2 votes179 views1 answer
Extend laravel blade
PHP Laravel
4 votes219 views4 answers
Laravel carbon get day name
PHP Laravel
5 votes191 views3 answers
Laravel eloquent duplicate record
PHP Laravel
0 vote183 views1 answer
Laravel schedule kernel code sample
PHP Laravel
0 vote214 views1 answer
Nova laravel image
PHP Laravel
0 vote221 views1 answer
Laravel array in lang
PHP Laravel
0 vote206 views1 answer
Get url parameter laravel 5.2 constructor
PHP Laravel
2 votes225 views2 answers
Laravel relationship with for single data
PHP Laravel
0 vote213 views1 answer
Laravel collection namespace
PHP Laravel
4 votes214 views1 answer
How to check query execution time in laravel
PHP Laravel