DEV Community

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

Posted on

Laravel 9 - New scalar() method

#php #laravel #database #programming

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)

Read next

zhangzhuyue profile image

Develop the management system on cloud for simple programmble controller.

zhuyue -

fuenrob profile image

🛠️ ¿Cómo actualizar tus paquetes de Go (Golang) de manera eficiente?🛠️

Roberto Morais -

prince_beec5ccde00b7c6c73 profile image

Diwali animation using html ,css and javascript https://www.instagram.com/webstreet_code/

Prince -

litlyx profile image

We launched SupaCharts! Visualize Beautiful Charts from your Supabase Data.

Antonio | CEO at Litlyx.com -