/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

44 votes307 views6 answers
How to make controller in laravel
PHP Laravel
0 vote275 views1 answer
The uploaded file exceeds the upload_max_filesize in laravel
PHP Laravel
0 vote268 views2 answers
How to get just the first row from a table in laravel
PHP Laravel
0 vote293 views1 answer
Access denied for user 'accessor access'@'localhost' (using password: NO) cpanel laravel
PHP Laravel
13 votes258 views6 answers
Laravel migration change column type
PHP Laravel
0 vote302 views1 answer
Add multi product at the same time using repearter default view laravel
PHP Laravel
0 vote277 views1 answer
Laravel store multiple files
PHP Laravel
0 vote321 views1 answer
Laravelda urlga requestlarni cheklash
PHP Laravel
7 votes273 views2 answers
Laravel collection isEmpty
PHP Laravel
0 vote283 views4 answers
How to redirect to another page after login in laravel
PHP Laravel