/PHP/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

25 votes122 views2 answers
Clear cache without using composer in laravel 8
PHP
2 votes132 views3 answers
Php laravel dump
PHP
0 vote174 views1 answer
Code cesar php
PHP
0 vote116 views1 answer
Preared request pdo
PHP
2 votes129 views1 answer
Wordpress theme development boilerplate
PHP
8 votes255 views5 answers
Redirect in codeigniter
PHP CodeIgniter
8 votes158 views1 answer
Laravel symlink command
PHP
0 vote140 views2 answers
Laravel pdf export
PHP Laravel
0 vote188 views1 answer
Symfony form submit on refresh
PHP Symfony
0 vote144 views1 answer
Laravel project in css
PHP