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 vote213 views1 answer
Wordpress get default date format
PHP Wordpress
4 votes197 views2 answers
Laravel DB wherein
PHP Laravel
32 votes218 views5 answers
Php array has key
PHP
0 vote206 views1 answer
How to fetch days old records php mysql
PHP
0 vote188 views1 answer
Access denied for user 'accessor access'@'localhost' (using password: NO) cpanel laravel
PHP Laravel
0 vote156 views1 answer
Dynamic base url
PHP
0 vote160 views1 answer
Laravel self
PHP
0 vote166 views1 answer
Myr currency symbol
PHP
13 votes173 views6 answers
Newline in php
PHP
0 vote228 views1 answer
Laravel array cast
PHP Laravel