/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

0 vote149 views1 answer
Import facade URL laravel
PHP Laravel
0 vote155 views2 answers
Gate and policy in laravel
PHP Laravel
1 vote161 views5 answers
Laravel jobs tutorial
PHP Laravel
2 votes167 views2 answers
Target class [AppHttpControllersRegisterController] does not exist. laravel 8
PHP Laravel
0 vote184 views2 answers
Send html from datatable in laravel
PHP Laravel
0 vote174 views1 answer
Laravelda urlga requestlarni cheklash
PHP Laravel
0 vote147 views1 answer
Dump die laravel
PHP Laravel
1 vote151 views1 answer
Laravel ErrorException Undefined variable: _SESSION
PHP Laravel
0 vote134 views1 answer
Use app http models in laravel 8
PHP Laravel
6 votes149 views3 answers
Laravel blade route redirect back
PHP Laravel