/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 vote248 views1 answer
Non-static method Barryvdh\DomPDF\PDF::loadView() should not be called statically
PHP
1 vote151 views2 answers
Laravel view with data in blade
PHP
-1 vote139 views2 answers
Php 8 "<?="
PHP
0 vote159 views1 answer
Query without chaining not working - Laravel
PHP Laravel
8 votes135 views3 answers
How to check if user is logged in wordpress
PHP
0 vote156 views2 answers
Check method in laravel
PHP
8 votes132 views1 answer
If any error in blade laravel
PHP
0 vote129 views1 answer
Laravel, if ->get() array is not emtpy
PHP
24 votes161 views3 answers
Difference of two dates in seconds php
PHP
0 vote157 views1 answer
Laravel mysql specified key was too long
PHP