Laravel DB query turning array instead of object

I have this query in laravel am trying to use but it's returning an array is there a method to have it an object instead?


$x = DB::table('user_profiles')
 ->where('id',$holidays[0]
->profile_id)
->select('first_name')->get();

Level 13

You have to take the first collection only using first

       $x = DB::table('user_profiles')
      ->where('id',$holidays[0]
      ->profile_id)
     ->select('first_name')->first();

Best Answer

Level 73

Why don't you use Eloquent for that then?

If you have a UserProfile model, use this:

$profile = UserProfile::findOrFail($holidays[0]->profile_id);

$profile->first_name; // will give you the name

1 like

Level 13

use as like below,

Level 9

@nakov thank you so much it worked just fine

Level 1

It actually returns an array of objects. To make an individual object to be an array just cast it. For example: (array)$data[0]

Please or to participate in this conversation.