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

11 votes143 views4 answers
How to remove NULL values in array PHP
PHP
0 vote192 views1 answer
Laravel cron job on shared hosting
PHP Laravel
1 vote153 views2 answers
Typo3 debug
PHP
13 votes169 views5 answers
Laravel get last record
PHP
1 vote163 views1 answer
Change background color php
PHP
0 vote193 views1 answer
Payment gateway webhook returning 302 laravel
PHP Laravel
3 votes115 views1 answer
Laravel convert datetime to date
PHP
0 vote196 views1 answer
Access storage from the view laravel 6
PHP Laravel
4 votes179 views4 answers
Wordpress get theme uri
PHP
0 vote162 views1 answer
Shopware php get cookie
PHP