/PHP/Laravel/How to get yearly chart in laravel

How to get yearly chart in laravel

    public function getYearlyVisits()
    {
        $monthlyVisitors = DB::table('shorteners')
            ->select([
                DB::raw('YEAR(created_at) as year'),
                DB::raw('count(total_visits as total_visits'),
            ])
            ->groupBy('year')
            ->get();
    }

Source: stackoverflow.com

Similar codes

0 vote375 views1 answer
Show all laravel valet folders
PHP Laravel
1 vote373 views3 answers
Difference between guard and fillable laravel
PHP Laravel
11 votes347 views4 answers
Laravel 8 password confirmation validation
PHP Laravel
15 votes355 views3 answers
Laravel timezone
PHP Laravel
11 votes356 views4 answers
Redirect back with input laravel in request
PHP Laravel
6 votes365 views2 answers
How to set tinyint default 0 laravel migration
PHP Laravel
1 vote376 views1 answer
Increament single column laravel current value + 1
PHP Laravel
2 votes324 views2 answers
Laravel list of models
PHP Laravel
0 vote383 views1 answer
Laravel faker value or null
PHP Laravel
1 vote356 views1 answer
'cross-env' is not recognized as an internal or external command, laravel
PHP Laravel