DEV Community 👩‍💻👨‍💻

Cover image for Laravel 9 - New scalar() method
Sandro Jhuliano Cagara
Sandro Jhuliano Cagara

Posted on

Laravel 9 - New scalar() method

In Laravel 9.8.0, the scalar() method was added that allows you to retrieve the first column of the first row from the query result.

Before:

DB::selectOne("SELECT COUNT(CASE WHEN food = 'burger' THEN 1 END) AS burgers FROM menu_items")->burgers
Enter fullscreen mode Exit fullscreen mode

Now:

DB::scalar("SELECT COUNT(CASE WHEN food = 'burger' THEN 1 END) FROM menu_items")
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Create an Account! The only reason people scroll to the bottom...  
is because they want to read more.

Create an account to bookmark, comment, and react to articles that interest you.