/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

1 vote130 views3 answers
Laravel eloquent where date today
PHP Laravel
13 votes112 views2 answers
Php rename files in directory
PHP
2 votes139 views2 answers
Laravel migration alter column unique
PHP Laravel
0 vote103 views1 answer
Erreur php
PHP
0 vote64 views2 answers
Laravel guzzle use request to post to api
PHP
0 vote169 views1 answer
Twig filter line break
PHP
1 vote95 views2 answers
Show comma separated numbers in php
PHP
0 vote112 views1 answer
Enumerations - PHP 8.1
PHP
0 vote100 views1 answer
Remove MainWP Child phpmyadmin
PHP
100 votes113 views6 answers
Replace in php
PHP