Get Array / List of data for a given field and Use it in Eloquent Query - Laravel

I am trying to Get list of results from a particular table and a particular column.

Works

$curr_user_offering = Offering::where('user_id', Auth::user()->id)->first()->language; 

Returns

Spanish

Fails

$curr_user_offering = Offering::where('user_id', Auth::user()->id)->get()->language; 

Error

I tried

$result = $curr_user_offering->toArray();
return $result;

Exception in Collection.php line 1479:
Property [language] does not exist on this collection instance.

but language do exist.

I want to return

['English','Spanish','French']

Finally, I want to use this to loop through a query with a check if other user have profile quite the opposite. That is, If user_1 is offering : English and user_2 wanting : English. I should return a true result of that user profile.

The query below works just fine: it checks if a user is not the one loggedin meaning other users who would like to study X language which current loggedin User is Offering.

$match = Wanting::where([['id', '<>', Auth::user()->id],['language',$curr_user_offering]])->get();

But I need a way to loop though loggedin User Wanting languages and loop through each user and find which ones can offer that.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2lMluk4
via IFTTT