/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 vote368 views2 answers
Laravel get namespace
PHP Laravel
0 vote377 views1 answer
Show sender name laravel
PHP Laravel
5 votes376 views2 answers
Laravel migration price
PHP Laravel
0 vote365 views1 answer
Test a single file laravel
PHP Laravel
0 vote387 views1 answer
Laravel passport vue 401 Unauthorized
PHP Laravel
1 vote333 views2 answers
Laravel return response view
PHP Laravel
0 vote410 views1 answer
Laravel imap - Get message attachments
PHP Laravel
0 vote388 views1 answer
Laravel orm latest()
PHP Laravel
0 vote374 views2 answers
Request get query string laravel
PHP Laravel
1 vote344 views3 answers
Laravel get input from request
PHP Laravel