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 votes187 views1 answer
Laravel command to create symlink storage
PHP
0 vote168 views1 answer
Root directory in php
PHP
14 votes164 views6 answers
Wp enqueue style
PHP
0 vote191 views1 answer
Laravel view not created using foreign keys
PHP
0 vote180 views1 answer
Remove .php extension & Remove trailing slash
PHP
3 votes184 views4 answers
Filesize in php
PHP
0 vote192 views1 answer
Wp tax_query in
PHP Wordpress
8 votes188 views6 answers
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted
PHP
0 vote212 views1 answer
Transform text to lowercase and replace space with dash php
PHP
5 votes186 views3 answers
Get users of specific role laravel role spatie
PHP