/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 vote136 views1 answer
Scirvere su file php
PHP
1 vote154 views1 answer
Insert data using model in laravel 8
PHP Laravel
3 votes174 views1 answer
Codeigniter check insert
PHP CodeIgniter
0 vote133 views1 answer
How to make a simple mail system in Laravel without view or notification
PHP
3 votes186 views3 answers
Laravel carbon count days between dates
PHP Laravel
0 vote156 views1 answer
Verzeichnis einlesen php
PHP
0 vote127 views1 answer
What’s New in PHP 8
PHP
1 vote141 views1 answer
Shorttime php
PHP
0 vote135 views1 answer
Beautify var_dump
PHP
1 vote155 views4 answers
Laravel unique id
PHP Laravel