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
Now:
DB::scalar("SELECT COUNT(CASE WHEN food = 'burger' THEN 1 END) FROM menu_items")
For further actions, you may consider blocking this person and/or reporting abuse
Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.
Ricardo Caselati -
DotNet Full Stack Dev -
chatgptnexus -
GetVM -
Top comments (0)