/PHP/Laravel/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

2 votes173 views1 answer
Laravel slug route
PHP Laravel
0 vote245 views1 answer
Laravel how to address to git repo for develop packages
PHP Laravel
2 votes215 views1 answer
Laravel check if session variable exists
PHP Laravel
0 vote202 views1 answer
Get url parameter laravel 5.2 constructor
PHP Laravel
0 vote215 views2 answers
Laravel collection search by value
PHP Laravel
0 vote203 views2 answers
Laravel download file from s3
PHP Laravel
21 votes241 views2 answers
Long text in laravel migration
PHP Laravel
0 vote218 views2 answers
Loop foreach laravel with number
PHP Laravel
5 votes278 views3 answers
Display all errors in blade laravel
PHP Laravel
0 vote201 views1 answer
Laravel replace white space with dash
PHP Laravel