/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 vote221 views1 answer
Write if and else in one line laravel
PHP Laravel
13 votes198 views6 answers
Find auth laravel
PHP Laravel
3 votes220 views2 answers
Create variable in laravel blade
PHP Laravel
1 vote215 views3 answers
Check table exists in db laravel
PHP Laravel
7 votes233 views1 answer
Laravel wher in
PHP Laravel
25 votes196 views6 answers
Laravel use cache
PHP Laravel
0 vote221 views1 answer
Laravel Auth::logoutOtherDevices
PHP Laravel
10 votes220 views4 answers
Laravel migration set default value
PHP Laravel
0 vote197 views1 answer
Laravel truncate string laravel 8
PHP Laravel
0 vote222 views1 answer
Show user only those products which he hasn't buyed laravel eloquent
PHP Laravel