Laravel i will get integer in DB query

Question

after returning $query from this:

$query = DB::table('pets')->select('id')->where('id', '=', $pet->id)->where('user_id', '=', Auth::id())->get();

for example i get this result : [{"id":"66"}] how can i get only 66 as integer? Thanks!

Use pluck feature of laravel

Rohit Dalal
– Rohit Dalal

2017-07-13 13:21:23 +00:00
Commented Jul 13, 2017 at 13:21 — Rohit Dalal
– Rohit Dalal, Commented Jul 13, 2017 at 13:21

Devon Bessemer · Accepted Answer · 2017-07-13 13:26:45Z

3

Instead of get() which returns the entire collection of selected data, use value('id') to get the first value of the id field. You also wouldn't need select('id') if you use this method.

answered Jul 13, 2017 at 13:26

Devon Bessemer

35.6k10 gold badges77 silver badges102 bronze badges

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

Collectives™ on Stack Overflow

Laravel i will get integer in DB query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related