/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

0 vote251 views2 answers
Wherebetween in laravel
PHP Laravel
5 votes267 views2 answers
Laravel - Send mail using mail class
PHP Laravel
0 vote258 views1 answer
Laravel convert querybuilder to string
PHP Laravel
6 votes263 views1 answer
How to add new column in table laravel
PHP Laravel
0 vote245 views1 answer
Call to a member function delete() on null laravel 8
PHP Laravel
3 votes220 views1 answer
Laravel middleware route
PHP Laravel
8 votes227 views1 answer
Laravel validation string type
PHP Laravel
0 vote261 views1 answer
Paygate logout session on callback laravel
PHP Laravel
0 vote211 views1 answer
Laravel login shows 404
PHP Laravel
0 vote230 views1 answer
Publish laravel scout
PHP Laravel