/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 vote133 views1 answer
Laravel return a single dimensional array
PHP Laravel
9 votes138 views3 answers
Laravel join 2 tables eloquent
PHP Laravel
1 vote155 views1 answer
How match array in laravel collection
PHP Laravel
1 vote86 views2 answers
Laravel loop counter
PHP Laravel
4 votes141 views2 answers
Laravel please provide a valid cache path
PHP Laravel
0 vote128 views1 answer
Order table in laravel
PHP Laravel
0 vote96 views1 answer
Appserviceprovider laravel share common settings for all controllers
PHP Laravel
29 votes147 views6 answers
Laravel timestamp
PHP Laravel
0 vote142 views1 answer
Laravel - Query Builder Raw Query selectRaw
PHP Laravel
0 vote143 views4 answers
Installing bootstrap on laravel8
PHP Laravel