/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 vote277 views1 answer
Valet laravel
PHP Laravel
-1 vote309 views1 answer
Laravel remove index.php from url
PHP Laravel
0 vote307 views1 answer
Show selected value in dropdown laravel
PHP Laravel
0 vote307 views1 answer
Laravel checkbox checked
PHP Laravel
7 votes345 views5 answers
Laravel model update table
PHP Laravel
15 votes298 views3 answers
Laravel timezone
PHP Laravel
9 votes305 views1 answer
Laravel 6 link storage with public
PHP Laravel
1 vote314 views1 answer
Stack once laravel
PHP Laravel
3 votes291 views1 answer
Check file size validation laravel
PHP Laravel
-4 votes328 views1 answer
Alert laravel 7
PHP Laravel