/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

1 vote160 views1 answer
Convert any phone number in us number format php
PHP
-1 vote169 views1 answer
How to get data in phpp
PHP
0 vote182 views1 answer
Laravel import xml to database
PHP Laravel
0 vote143 views2 answers
Send data using ajax in laravel
PHP Laravel
0 vote169 views1 answer
.htaccess Prevent access to php.ini
PHP
0 vote220 views2 answers
Hide Categories - Woocommerce Product Page
PHP
5 votes160 views3 answers
How to execute cmd command in php
PHP
1 vote177 views2 answers
Get current term id
PHP
0 vote166 views1 answer
Include navbar or part in layout in laravel blade template
PHP
0 vote189 views1 answer
Check if value exists in object php
PHP