/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

4 votes334 views2 answers
Laravel migration update table column type
PHP Laravel
3 votes314 views2 answers
Laravel tinker generate password
PHP Laravel
8 votes326 views4 answers
Laravel unique validation on multiple columns
PHP Laravel
0 vote325 views1 answer
Laravel-5-on-shared-hosting-wrong-public-path
PHP Laravel
6 votes317 views3 answers
Disable foreign key laravel
PHP Laravel
15 votes311 views4 answers
Change existing migration laravel
PHP Laravel
6 votes318 views1 answer
Laravel route param blade
PHP Laravel
43 votes290 views6 answers
Laravel cache
PHP Laravel
0 vote323 views1 answer
How to separate admin and user login in laravel
PHP Laravel
3 votes315 views1 answer
Laravel validation pdf
PHP Laravel