/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

5 votes216 views3 answers
Merge collections laravel
PHP Laravel
14 votes197 views6 answers
How to install laravel
PHP Laravel
1 vote188 views1 answer
How to add dummy records using factory in laravel 8
PHP Laravel
1 vote195 views1 answer
Redirect http to https htaccess laravel 8
PHP Laravel
0 vote209 views2 answers
How to use flash message in laravel
PHP Laravel
0 vote177 views4 answers
How i can send by database table in laravel full calendar
PHP Laravel
1 vote179 views2 answers
Laravel, return view with Request::old
PHP Laravel
8 votes142 views1 answer
Laravel get variable from url
PHP Laravel
0 vote167 views3 answers
When you click on the search button, it is moved to the page laravel
PHP Laravel
1 vote191 views2 answers
Get the unique rows from table laravel
PHP Laravel