/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 vote164 views1 answer
Laravel has one of many relationship
PHP Laravel
0 vote149 views1 answer
Laravel 8 Auth Scaffolding using Inertia Jetstream
PHP Laravel
0 vote143 views1 answer
Laravel migration folder
PHP Laravel
4 votes169 views3 answers
Delete all records from table using button laravel Eloquent
PHP Laravel
48 votes166 views6 answers
Laravel join table
PHP Laravel
0 vote127 views1 answer
Laravel empty query result
PHP Laravel
10 votes166 views4 answers
Laravel migration change column default
PHP Laravel
1 vote151 views1 answer
Laravel validateexception no error description
PHP Laravel
2 votes132 views4 answers
Cors laravel
PHP Laravel
1 vote139 views1 answer
How validate the becrypt password in laravel
PHP Laravel