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

3 votes295 views3 answers
Convert stdclass object to array php
PHP
13 votes297 views5 answers
Laravel validation custom message example
PHP
1 vote358 views1 answer
How to use old for select in blade laravel
PHP Laravel
0 vote286 views1 answer
Woocommerce_recently_viewed
PHP
2 votes319 views3 answers
Laravel 8 404 status
PHP Laravel
4 votes364 views3 answers
Laravel cmd command to watch logs
PHP Laravel
0 vote351 views1 answer
Laravel blank page
PHP Laravel
2 votes308 views3 answers
Foreach loop laravel
PHP Laravel
2 votes365 views1 answer
Migrations required field laravel
PHP Laravel
1 vote320 views1 answer
Operador in laravel
PHP