/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

8 votes119 views4 answers
Laravel unique validation on multiple columns
PHP Laravel
2 votes126 views2 answers
Laravel get random number of data from database
PHP Laravel
0 vote128 views1 answer
Multiple databases user validation in Laravel
PHP Laravel
5 votes118 views5 answers
Install laravel 8 with composer
PHP Laravel
0 vote112 views1 answer
Laravel breeze rquire
PHP Laravel
1 vote115 views1 answer
Laravel add crf token form
PHP Laravel
1 vote94 views1 answer
Function in first collection laravel
PHP Laravel
0 vote129 views1 answer
Laravel orm latest()
PHP Laravel
1 vote121 views1 answer
Using middleware auth laravel in controller constructor
PHP Laravel
0 vote144 views1 answer
Pdf watermark dengan laravel
PHP Laravel