/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 vote126 views1 answer
Replace header template from plugin
PHP
0 vote120 views1 answer
Call to undefined method Illuminate\\Database\\Eloquent\\Relations\\HasMany::attach()
PHP
1 vote112 views2 answers
Php echo number with decimal
PHP
0 vote151 views1 answer
Add button next to "ADD TO CART" on product archive
PHP
0 vote151 views2 answers
Fetch data based on month and year in laravel
PHP Laravel
0 vote128 views1 answer
If condtion in varibale value how to change in loop in php
PHP
0 vote115 views1 answer
Variable "$id" is not defined by operation "GetPost".
PHP
5 votes160 views1 answer
Wordpress get taxonomy of a post
PHP Wordpress
0 vote136 views1 answer
Laravel controller create command in a folder
PHP Laravel
7 votes134 views5 answers
Show featured image in post wordpress
PHP