/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

5 votes262 views1 answer
Php foreach echo key value
PHP
0 vote261 views2 answers
All() in laravel
PHP Laravel
0 vote286 views1 answer
Php usort two columns
PHP
-1 vote234 views1 answer
Get the url without the query string php
PHP
0 vote245 views1 answer
Js unserialize
PHP
46 votes307 views3 answers
How to check laravel version in cmd
PHP Laravel
0 vote239 views1 answer
Example of valid php variables
PHP
0 vote217 views1 answer
Laravel Google Line Chart
PHP
0 vote227 views1 answer
Htaccess new date timestamp
PHP
0 vote275 views1 answer
Get previous url symfony 4 in formpage
PHP Symfony