/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

17 votes318 views6 answers
Laravel auth user in constructor
PHP Laravel
0 vote357 views1 answer
Array helper array_push laravel
PHP Laravel
7 votes323 views2 answers
Laravel carbon get month number
PHP Laravel
8 votes298 views6 answers
Laravel validation date
PHP Laravel
0 vote329 views1 answer
Laravel get current action name
PHP Laravel
1 vote322 views1 answer
Bootstrap doesn't work in laravel
PHP Laravel
1 vote311 views1 answer
Orderby text values eliquent laravel
PHP Laravel
6 votes290 views2 answers
How many products can a laravel ecommerce handle
PHP Laravel
7 votes301 views4 answers
Laravel chunk
PHP Laravel
2 votes319 views3 answers
Laravel public static variable
PHP Laravel