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

Oldest comments (0)

DEV

Thank you.

 
Thanks for visiting DEV, we’ve worked really hard to cultivate this great community and would love to have you join us. If you’d like to create an account, you can sign up here.