/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

0 vote241 views1 answer
Order by array like sql php
PHP
0 vote237 views1 answer
How to reduce time taken by php script on server
PHP
5 votes243 views2 answers
Laravel print exception message
PHP
0 vote317 views1 answer
Symfony 3.4 cache control
PHP Symfony
1 vote303 views1 answer
Laravel php artisan make:controller in subfolder
PHP Laravel
2 votes241 views2 answers
Php extract last n words of string
PHP
8 votes309 views1 answer
Laravel symlink command
PHP Laravel
1 vote252 views2 answers
Get template part pass variable
PHP
0 vote267 views1 answer
Php session name
PHP
0 vote262 views1 answer
Laravel disable config cache
PHP