/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

0 vote194 views2 answers
How to rollback if one table in laravel didn't save data successfully
PHP Laravel
15 votes217 views3 answers
Laravel timezone
PHP Laravel
0 vote200 views1 answer
Laravel model uploaded file name
PHP Laravel
0 vote197 views2 answers
Laravel allow all fillable
PHP Laravel
7 votes189 views6 answers
Laravel url
PHP Laravel
0 vote206 views1 answer
Laravel extends if
PHP Laravel
1 vote217 views1 answer
How match array in laravel collection
PHP Laravel
22 votes210 views6 answers
Log Laravel
PHP Laravel
0 vote211 views1 answer
Prevent xss attack in laravel
PHP Laravel
4 votes205 views1 answer
Refresh a specific migration in laravel
PHP Laravel