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

8 votes366 views4 answers
Array flip php
PHP
0 vote319 views10 answers
Loop
PHP
0 vote313 views1 answer
Php explode and get first value
PHP
0 vote281 views1 answer
Laravel secure route
PHP Laravel
9 votes320 views3 answers
Image validate in laravel validater
PHP
7 votes318 views2 answers
Laravel ui
PHP
2 votes328 views2 answers
Laravel get column field name
PHP
1 vote309 views1 answer
Laravel use references in other tables
PHP
0 vote342 views1 answer
Laravel route name with parameters
PHP
1 vote314 views2 answers
Run shell script from php file
PHP