/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 vote290 views1 answer
Multiplication des variables sur laravel
PHP Laravel
0 vote292 views1 answer
Laravel datepicker date format
PHP Laravel
1 vote269 views1 answer
Laravel Squashing Migrations
PHP Laravel
0 vote284 views1 answer
How to get a particular column in laravel 8
PHP Laravel
11 votes303 views5 answers
Laravel check auth
PHP Laravel
6 votes284 views2 answers
Laravel findorfail
PHP Laravel
4 votes300 views1 answer
Password match laravel
PHP Laravel
0 vote291 views1 answer
Laravel query foreach
PHP Laravel
1 vote272 views3 answers
Laravel invoice toturial
PHP Laravel
0 vote293 views1 answer
Laravel database engine innodb
PHP Laravel