/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

3 votes139 views3 answers
Laravel notification
PHP Laravel
38 votes127 views6 answers
Create seed file laravel
PHP Laravel
6 votes119 views4 answers
Install laravel on windows
PHP Laravel
0 vote120 views1 answer
Combine 2 columns search query laravel
PHP Laravel
0 vote122 views1 answer
Laravel project create with version
PHP Laravel
0 vote139 views1 answer
Laravel simplexmlelement not found
PHP Laravel
0 vote132 views3 answers
Laravel collection each
PHP Laravel
2 votes130 views3 answers
Laravel Create Custom Artisan Command
PHP Laravel
6 votes130 views3 answers
Laravel foreach loop index from 1
PHP Laravel
5 votes125 views2 answers
Laravel 5 use env variable in blade
PHP Laravel