How to make my query return string rather than an array?

Question

I ran this code and it is returning an array. Please, how can I make it return only a user_id and not arrays of user_id?

     $userr = DB::table('level_one_models')
        ->select('user_id')
        ->where('downline', '<=', 7)
        ->orderBy('created_at', 'desc')
        ->get();

I want to fetch the user_id as an integer. The query above is returning user_id as an array. — Justin
– Justin, Commented Mar 5, 2017 at 13:45

Rwd · Accepted Answer · 2017-03-05 14:26:08Z

3

If you want $userr to be the user_id you could just do:

$userr = DB::table('level_one_models')
    ->select('user_id')
    ->where('downline', '<=', 7)
    ->orderBy('created_at', 'desc')
    ->first()
    ->user_id;

Hope this helps!

answered Mar 5, 2017 at 14:26

Rwd

35.3k7 gold badges71 silver badges85 bronze badges

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

1 Comment

Justin Over a year ago

Thanks, really helpful

Max · Accepted Answer · 2017-03-05 13:28:49Z

0

Use ->first() instead of ->get().

answered Mar 5, 2017 at 13:28

Max

3322 silver badges11 bronze badges

2 Comments

Justin Over a year ago

First method is throwing error: Object of class stdClass could not be converted to string

Justin Over a year ago

My downline column holds email addresses and I want the downline column counted. I think my approach is wrong. Please how can I count the downline column?

Collectives™ on Stack Overflow

How to make my query return string rather than an array?

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related