/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

53 votes515 views6 answers
Laravel where in
PHP Laravel
2 votes200 views2 answers
Laravel eloquent randomise data from database
PHP Laravel
5 votes216 views2 answers
Laravel APP_ENV config
PHP Laravel
0 vote180 views1 answer
Optimize clear laravel not working
PHP Laravel
0 vote202 views1 answer
Laravel list get x amount in a collection
PHP Laravel
0 vote191 views1 answer
Laravel asset resolving to http not https
PHP Laravel
2 votes199 views2 answers
Laravel get random number of data from database
PHP Laravel
0 vote194 views1 answer
Laravel datatable render html
PHP Laravel
17 votes195 views10 answers
Laravel where and where
PHP Laravel
0 vote213 views1 answer
Laravel old value not working in textarea
PHP Laravel