/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 vote121 views1 answer
Write if and else in one line laravel
PHP
9 votes164 views3 answers
Laravel enum migration example
PHP Laravel
4 votes119 views1 answer
Php set alternatives
PHP
-2 votes123 views1 answer
Laravel add user
PHP
16 votes148 views4 answers
Get user ip in php
PHP
3 votes137 views1 answer
Wordpress get domain
PHP Wordpress
40 votes127 views2 answers
$dom->getElementById
PHP
2 votes133 views2 answers
Image upload form
PHP
0 vote140 views1 answer
Get absolute path php file
PHP
0 vote148 views1 answer
Laravel mail success or failure
PHP Laravel