/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

2 votes214 views1 answer
Path of app directory in controller laravel
PHP Laravel
2 votes146 views1 answer
Varchar max length define laravel migration
PHP Laravel
1 vote253 views2 answers
Join multiple query in laravel
PHP Laravel
14 votes210 views6 answers
Laravel migration set default value
PHP Laravel
0 vote215 views1 answer
Send multiple db notification same function in laravel
PHP Laravel
0 vote201 views1 answer
Laravel collection flatMap
PHP Laravel
1 vote311 views1 answer
How to use old for select in blade laravel
PHP Laravel
2 votes200 views1 answer
Laravel delete route
PHP Laravel
0 vote202 views2 answers
Laravel project make
PHP Laravel
0 vote215 views1 answer
Access-control-allow-origin php laravel
PHP Laravel