/PHP/Laravel/How to get yearly chart in laravel

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

6 votes225 views1 answer
Laravel eloquent whereDateBetween
PHP Laravel
1 vote212 views1 answer
How handle the number with k in laravel balde
PHP Laravel
0 vote222 views2 answers
Concat in where clause laravel query builder
PHP Laravel
0 vote218 views3 answers
When you click on the search button, it is moved to the page laravel
PHP Laravel
1 vote218 views1 answer
Laravel check pagination in blade
PHP Laravel
-1 vote235 views2 answers
Adminlte 3 laravel
PHP Laravel
0 vote218 views1 answer
Php laravel rount price to 99
PHP Laravel
-1 vote231 views2 answers
Laravel sortby relationship column
PHP Laravel
1 vote174 views1 answer
Laravel http request plain text
PHP Laravel
0 vote216 views1 answer
Curl error (code 3) url malformed laravel
PHP Laravel