Getting a single value from DB::select in Laravel 7.x

Question

I am using Laravel's DB::select to run a query to get a MAX() value. I only want the single column value from the single row result. What method do I use to get this from a DB::select() statement?

I found this answerenter link description here that proffered both pluck() and value(). The behavior of pluck() had changed since 5.3, so that wasn't the answer. However, when I used value(), I didn't get the value I was expecting. Instead I got an error about an array:

$query =  DB::select('SELECT max(sort) AS sort FROM man_pos WHERE manual_id = ?', [$manual_id]);
dd($query);

Error HTTP 500 Internal Server Error

Call to a member function value() on array

Of course, I can traverse the array to pull the value, but the whole point of using a method is to avoid such extra rigamarole.

Per a request in the comments, here is some sample data and expected result. First, the query:

MariaDB [dev]> SELECT MAX(sort) FROM man_pos WHERE manual_id = 1;
+-----------+
| MAX(sort) |
+-----------+
|         3 |
+-----------+

Second, what I would like to get:

$max_sort = DB::select('SELECT max(sort) AS sort FROM man_pos WHERE manual_id = ?', [$manual_id])->getSingleValue();

dd($max_sort);

^ 3

can you write sample data and expected data

Nurbek Boymurodov
– Nurbek Boymurodov

2020-12-01 05:28:36 +00:00
Commented Dec 1, 2020 at 5:28 — Nurbek Boymurodov
– Nurbek Boymurodov, Commented Dec 1, 2020 at 5:28
@NurbekBoymurodov Please see edits

user151841
– user151841

2020-12-01 05:36:22 +00:00
Commented Dec 1, 2020 at 5:36 — user151841
– user151841, Commented Dec 1, 2020 at 5:36

Tim Biegeleisen · Accepted Answer · 2020-12-01 05:29:34Z

2

You may just try using Laravel's built in MAX function:

$max_sort = DB::table('man_pos')
    ->where('manual_id', $manual_id)
    ->max('sort');

answered Dec 1, 2020 at 5:29

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nurbek Boymurodov · Accepted Answer · 2020-12-01 06:12:49Z

0

you want single column for single max return single value

$max_sort = DB::table('man_pos')->select('sort')->where('manual_id', '=', $manual_id)->max('sort');

edited Dec 1, 2020 at 6:12

answered Dec 1, 2020 at 5:47

Nurbek Boymurodov

5423 silver badges11 bronze badges

1 Comment

Nurbek Boymurodov Over a year ago

@user151841 I just tested i was mistake you dont need get() and first() when you are using max() i edited answer did you try Tim Biegelesion answer it shoud be works

Collectives™ on Stack Overflow

Getting a single value from DB::select in Laravel 7.x

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related