/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

4 votes234 views4 answers
Nginx codeigniter remove index.php
PHP
0 vote240 views1 answer
Php date text in middle
PHP
1 vote281 views2 answers
Laravel add attribute to model
PHP Laravel
7 votes266 views6 answers
Set session in laravel
PHP Laravel
6 votes243 views6 answers
Array to String Conversion in PHP
PHP
0 vote262 views1 answer
Artisan laravel require bootstrap
PHP
1 vote268 views1 answer
Laravel add (s) at the end of text based on how many data
PHP
3 votes230 views3 answers
Laravel description substring
PHP
0 vote283 views1 answer
Laravel get all old input
PHP Laravel
0 vote231 views1 answer
Refresh_ttl
PHP