/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

35 votes284 views5 answers
Remove the Last Character From a String in PHP
PHP
2 votes296 views2 answers
Cache for php website
PHP
21 votes302 views3 answers
Implode example in php
PHP
0 vote306 views1 answer
Add execute time php
PHP
1 vote309 views1 answer
Validate timestamp php
PHP
0 vote303 views1 answer
12 months service expiary in php
PHP
0 vote267 views1 answer
Php named parameters
PHP
3 votes272 views2 answers
Laravel migration on delete set null
PHP Laravel
0 vote303 views2 answers
Laravel collection search
PHP
7 votes287 views2 answers
Reset wordpress password in database
PHP