/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 vote164 views1 answer
Laravel phpdoc collection of model
PHP Laravel
1 vote148 views2 answers
How set field after another field in migration in laravel
PHP Laravel
64 votes332 views6 answers
Delete cache laravel
PHP Laravel
26 votes157 views6 answers
Laravel validation integer
PHP Laravel
0 vote156 views1 answer
Show data from a table in laravel 8
PHP Laravel
0 vote168 views1 answer
Laravel delete file after download
PHP Laravel
0 vote170 views1 answer
PaymentIntent::create laravel
PHP Laravel
28 votes232 views12 answers
Laravel middleware
PHP Laravel
-1 vote158 views4 answers
How to include file in laravel blade
PHP Laravel
2 votes164 views3 answers
Get request uri from request laravel 7
PHP Laravel