/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 votes221 views2 answers
Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes) laravel
PHP Laravel
3 votes210 views1 answer
Laravel eloquent get column
PHP Laravel
1 vote213 views1 answer
Using middleware auth laravel in controller constructor
PHP Laravel
0 vote205 views3 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table many to many in laravel
PHP Laravel
12 votes227 views4 answers
Bcrypt laravel
PHP Laravel
6 votes235 views6 answers
Composer install laravel
PHP Laravel
7 votes220 views3 answers
Laravel random query
PHP Laravel
1 vote220 views2 answers
Pass image path in laravel blade
PHP Laravel
2 votes207 views1 answer
Get user ip laravel
PHP Laravel
0 vote253 views1 answer
Laravel new line in language file
PHP Laravel