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 vote362 views1 answer
Kill php process mac
PHP
7 votes303 views4 answers
Laravel chunk
PHP
20 votes364 views6 answers
Object to array in php
PHP
0 vote334 views1 answer
Reverse array laravel
PHP Laravel
2 votes354 views1 answer
Laravel string key
PHP Laravel
3 votes312 views1 answer
Wherehas laravel search
PHP
1 vote297 views1 answer
Wordpress check post id exists
PHP Wordpress
0 vote325 views1 answer
Import local js file laravel
PHP
0 vote371 views1 answer
Laravel: get last id
PHP Laravel
0 vote328 views7 answers
Php apache install macbook
PHP