/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

1 vote349 views2 answers
Php browser detection script
PHP
0 vote324 views1 answer
Php month single digit
PHP
3 votes330 views1 answer
Generate autodump laravel
PHP
2 votes312 views3 answers
Laravel get input from request
PHP
20 votes337 views3 answers
Ucfirst meaning in php
PHP
0 vote358 views5 answers
Download file laravel s3
PHP Laravel
6 votes316 views2 answers
Php empty object
PHP
0 vote356 views2 answers
Global variable in laravel controller
PHP Laravel
2 votes299 views2 answers
Hide wp admin bar for subscribers
PHP
0 vote373 views1 answer
Aws s3 laravel package
PHP Laravel