[New post] PHP code snippet – How to get yearly chart in laravel?

Subash Chandran posted: " public function getYearlyVisits() { $monthlyVisitors = DB::table('shorteners') ->select([ DB::raw('YEAR(created_at) as year'), DB::raw('count(total_visits as total_visits'), ]) " New post on Poopcode PHP code snippet – How to get yearly chart in laravel? by Subash Chandran 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(); } Read more of this post Subash Chandran | November 19, 2021 at 7:34 am | Tags: create monthly chart in laravel 7, how to get yearly chart in laravel, laravel monthly chart, laravel monthly chart code, monthly chart laravel, monthly chart with laravel | Categories: Snippets | URL: https://wp.me/pb9kQA-4sZ Comment    See all comments Unsubscribe to no longer receive posts from Poopcode. Change your email settings at Manage Subscriptions. Trouble clicking? Copy and paste this URL into your browser: https://poopcode.com/php-code-snippet-how-to-get-yearly-chart-in-laravel/