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 vote281 views1 answer
How-to-generate-an-xlsx-using-php
PHP
0 vote307 views1 answer
Invalid oauth access token instagram
PHP
8 votes293 views3 answers
What is route namespace in laravel
PHP
0 vote306 views1 answer
Php open url
PHP
0 vote297 views2 answers
Php header pdf
PHP
21 votes286 views6 answers
Carbon parse timestamp
PHP
1 vote286 views1 answer
Feof
PHP
29 votes320 views6 answers
Laravel timestamp
PHP
0 vote289 views1 answer
Php receive get
PHP
0 vote338 views1 answer
How to see with page reuested in laravel
PHP Laravel