/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

1 vote129 views1 answer
Unless blade laravel
PHP Laravel
7 votes121 views3 answers
Laravel 8 – Remove Public from URL
PHP Laravel
15 votes136 views3 answers
Foreign id laravel migration
PHP Laravel
0 vote161 views1 answer
Laravel append parameter to links
PHP Laravel
1 vote112 views2 answers
Laravel generate unique db token
PHP Laravel
0 vote216 views1 answer
Relationship on the base of condition in laravel
PHP Laravel
0 vote125 views1 answer
Laravel max length format
PHP Laravel
0 vote134 views1 answer
Eager load relationships by default in the model laravel
PHP Laravel
0 vote119 views1 answer
How to merge 2 laravel eloquent records
PHP Laravel
0 vote131 views2 answers
Laravel undefined index
PHP Laravel