/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

0 vote318 views3 answers
Valet switch php version
PHP
0 vote321 views1 answer
Favicon php
PHP
0 vote387 views1 answer
Laravel new line in language file
PHP Laravel
0 vote366 views1 answer
Download any version of xampp
PHP
2 votes354 views2 answers
Carbon difference between two dates
PHP
1 vote300 views2 answers
Password_hash
PHP
11 votes358 views2 answers
Command laravel for php artisan make :auth
PHP
1 vote290 views1 answer
Create resources laravel
PHP
0 vote334 views2 answers
Laravel get average from a column
PHP
0 vote331 views1 answer
Phpserver
PHP