/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

5 votes240 views2 answers
Route() and with() in laravel
PHP Laravel
1 vote259 views1 answer
Laravel 8: seed users + Jetstream teams
PHP Laravel
3 votes250 views1 answer
Insert rows in migrations laravel
PHP Laravel
2 votes213 views2 answers
Confirm popup laravel
PHP Laravel
1 vote226 views1 answer
Laravel run query migration
PHP Laravel
0 vote235 views1 answer
->store() laravel change name
PHP Laravel
0 vote228 views1 answer
Store as real file name laravel uplaod
PHP Laravel
0 vote258 views1 answer
Laravel cron job on shared hosting
PHP Laravel
32 votes262 views2 answers
Add column migration laravel 8
PHP Laravel
0 vote231 views1 answer
Laravel 8 crud api example
PHP Laravel