/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

11 votes191 views2 answers
How login one user with id in laravel
PHP Laravel
2 votes203 views2 answers
How get query from url in laravel
PHP Laravel
0 vote184 views1 answer
Check laravel first null
PHP Laravel
0 vote172 views1 answer
How to make custom validator in laravel
PHP Laravel
-1 vote175 views1 answer
Return true false laravel
PHP Laravel
6 votes159 views2 answers
Create migration model and seeder laravel at once
PHP Laravel
0 vote215 views1 answer
Laravel echo html
PHP Laravel
5 votes180 views2 answers
Get app url in laravel
PHP Laravel
1 vote189 views1 answer
How to add dummy records using factory in laravel 8
PHP Laravel
3 votes201 views1 answer
Get soft deleted data laravel
PHP Laravel