/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

1 vote338 views1 answer
Laravel inverse seeder
PHP Laravel
0 vote388 views1 answer
Laravel imap - Get message attachments
PHP Laravel
1 vote362 views3 answers
Laravel artisan command run in route
PHP Laravel
3 votes335 views2 answers
Insert into laravel 8
PHP Laravel
9 votes355 views2 answers
Laravel query count raw
PHP Laravel
2 votes351 views3 answers
Laravel public static variable
PHP Laravel
18 votes391 views4 answers
Laravel create model controller and migration on line
PHP Laravel
1 vote379 views1 answer
Laravel ErrorException Undefined variable: _SESSION
PHP Laravel
0 vote309 views1 answer
Laravel schedule run
PHP Laravel
16 votes352 views6 answers
Laravel redirect back
PHP Laravel