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 vote129 views1 answer
Laravel Eloquent, group by month/year
PHP Laravel
2 votes123 views1 answer
Count() parameter must be an array or an object that implements countable laravel
PHP
0 vote122 views1 answer
Wordpress wp_enqueue_script footer
PHP
0 vote123 views1 answer
Docker : from php alpine
PHP
6 votes139 views1 answer
Laravel eloquent whereDateBetween
PHP Laravel
0 vote127 views2 answers
How to concat in where clause like laravel query builder
PHP
0 vote118 views1 answer
Get shipping price of choosen shipping method woocommerce
PHP
2 votes134 views1 answer
Php see if undefined
PHP
4 votes111 views1 answer
Curl php show error
PHP
13 votes155 views6 answers
Prefix laravel route
PHP Laravel