/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 vote361 views1 answer
Laravel date rule before 18 years ago
PHP
2 votes337 views4 answers
Laravel storage get file path
PHP Laravel
0 vote344 views1 answer
How to see with page reuested in laravel
PHP
4 votes342 views3 answers
How to hide .php in url
PHP
0 vote399 views1 answer
Divide page in pdf with page break using php
PHP
0 vote326 views1 answer
Convert am pm time to 24 hour in php
PHP
40 votes314 views5 answers
Print date in php
PHP
0 vote337 views1 answer
Php compare strings case insensitive
PHP
0 vote341 views2 answers
Laravel notification database
PHP
0 vote339 views2 answers
Update user role wordpress
PHP