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

15 votes153 views6 answers
Install laravel
PHP
18 votes136 views5 answers
Php get first word of string
PHP
1 vote187 views1 answer
Codeigniter distinct
PHP CodeIgniter
0 vote147 views3 answers
Install php pdo mysql PHP5.6 alpine-apache
PHP
0 vote136 views1 answer
Delete data with ajax in php
PHP
6 votes186 views5 answers
Laravel collection map
PHP
0 vote173 views1 answer
Get array key based on value php
PHP
40 votes139 views6 answers
Php artisan cache
PHP
0 vote176 views1 answer
Take and skip in laravel
PHP Laravel
2 votes148 views1 answer
Blade switch
PHP