/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

3 votes186 views2 answers
Order number generate laravel
PHP Laravel
0 vote162 views2 answers
Laravel filesystem
PHP Laravel
0 vote171 views2 answers
Where () laravel Eloquent
PHP Laravel
0 vote198 views1 answer
Remove controller cache laravel
PHP Laravel
0 vote176 views3 answers
When you click on the search button, it is moved to the page laravel
PHP Laravel
17 votes184 views4 answers
Laravel with trashed
PHP Laravel
45 votes190 views6 answers
Laravel outer join
PHP Laravel
0 vote177 views2 answers
Laravel file path
PHP Laravel
0 vote131 views1 answer
Laravel collection take
PHP Laravel
9 votes199 views2 answers
Laravel query count raw
PHP Laravel