/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 vote228 views1 answer
At C:\Users\Kamyar\web-pages\telebot\vendor\symfony\process\Pipes\WindowsPipes.php:63 laravel error
PHP Laravel
11 votes216 views5 answers
Resource route laravel
PHP Laravel
44 votes318 views2 answers
Laravel version command
PHP Laravel
0 vote292 views1 answer
Nova laravel image
PHP Laravel
1 vote282 views1 answer
Laravel parent child same table
PHP Laravel
2 votes238 views2 answers
Laravel relationship with for single data
PHP Laravel
2 votes205 views4 answers
Laravel storage get file path
PHP Laravel
0 vote217 views1 answer
Laravel reset autoload
PHP Laravel
10 votes213 views3 answers
Get current date carbon laravel
PHP Laravel
0 vote293 views1 answer
Get deleted value laravel
PHP Laravel