Is there a better way to do this

I am getting a comma separated string

$user = User::where('id',\Auth::user()->id)->with(['influences'])->first();
        $influencesArray = array();
        foreach($user->influences as $influence){
            $influencesArray[] = $influence->name;
}
        
        $influencesString = implode(",", $influencesArray);

Tray2

5 years ago

Level 74

You should be able to just

$influences = $user->implode('influences', ',');

https://laravel.com/docs/8.x/collections#method-implode

Loach

5 years ago

Level 11

I get this error. I am trying to just get the name from the influences relation. I think it is an array.

Column not found: 1054 Unknown column 'influences' in 'field list' (SQL: select `influences` from `users`

Tray2

5 years ago

Best Answer

Level 74

My bad try this instead

$influences = $user->influences->implode('name', ',');

MichalOravec

5 years ago

Level 75

@loach You have an user. So use load() instead of with()

$user = Auth::user()->load('influences');

$influencesString = $user->influences->implode('name', ',');

Docs: https://laravel.com/docs/8.x/eloquent-relationships#lazy-eager-loading

1 like

Please or to participate in this conversation.