/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 vote170 views1 answer
Laravel mcq questions
PHP Laravel
1 vote183 views3 answers
Difference between guard and fillable laravel
PHP Laravel
0 vote184 views1 answer
Query relationships laravel and select some columns
PHP Laravel
6 votes177 views1 answer
PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes") laravel 8
PHP Laravel
0 vote165 views1 answer
Laravel project htaccess redirect to public path
PHP Laravel
0 vote170 views1 answer
Publish Spatie Laravel Permission
PHP Laravel
0 vote178 views2 answers
Laravel storage link without command line
PHP Laravel
0 vote193 views1 answer
Laravel sanctum Provoking tokens
PHP Laravel
4 votes178 views4 answers
Laravel meta csrf
PHP Laravel
0 vote188 views1 answer
Remove controller cache laravel
PHP Laravel