/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 vote259 views1 answer
Handling deadlocks laravel
PHP Laravel
9 votes232 views3 answers
Laravel where closure
PHP Laravel
0 vote283 views2 answers
Access paginator object attribute in laravel
PHP Laravel
4 votes261 views3 answers
Laravel 7 eloquent on delete set null schema
PHP Laravel
12 votes280 views2 answers
Laravel query with trashed
PHP Laravel
0 vote278 views1 answer
Subdomain in laravel and xampp
PHP Laravel
0 vote245 views1 answer
Laravel carbon first day of month
PHP Laravel
0 vote271 views1 answer
Current URL without url site laravel
PHP Laravel
0 vote268 views1 answer
Show user only those products which he hasn't buyed laravel eloquent
PHP Laravel
2 votes275 views1 answer
Base64 encode laravel
PHP Laravel