I’m trying to get an ‘id’ of the table where ‘user_id’ == auth()->id() (checks what row belongs to user).
here’s what I accomplished so far:
-
In the Controller with this line I’m trying access ‘id’ of Clients table where…
'client_id' => Clients::select('id')->where('user_id', auth()->id())->get() -
Once Controller is triggered it gets the ‘id’ as an object and tries to insert into DB as:
[ { "id": 1 } ]
What would be an overcome to this, so I can get only ‘id’ value in return?
>Solution :
get() will returned a collection. You can use instead first() then you have directly access to the Model. Afterwards you can append ->id. It will return only the client id.
'client_id' => Clients::select('id')->where('user_id', auth()->id())->first()->id;
// output the id as int