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 votes142 views1 answer
Laravel string key
PHP Laravel
4 votes143 views3 answers
Php sleep milliseconds
PHP
1 vote127 views1 answer
Add post meta wordpress
PHP
0 vote130 views1 answer
Laravel face-auth
PHP
0 vote158 views1 answer
Laravel access request in provider
PHP Laravel
0 vote187 views1 answer
Php adding options from an array
PHP
0 vote137 views1 answer
Laravel list all tbales
PHP
0 vote146 views2 answers
How to get display name in wordpress
PHP Wordpress
0 vote153 views1 answer
My laravel has no docker-composer.yml file
PHP Laravel
4 votes158 views2 answers
Laravel eloquent get first
PHP