Laravel集体形式和foreach循环

Question

I want to connect my dropdown select form with database, currentli I have sth like this:

                 @foreach( $clients as $client)
                    {!! Form::select('connected_with',
                     ['name' => $client->name . $client->surname
                      ]) !!}
                    @endforeach

And this is my controller:

        $clients = Client::all();

        return view('report_create')->with('clients', $clients);

and i get much fields. I want only one with items from db. How to do it?

Answer 1

If you want to create select list of clients, use pluck():

$clients = Client::pluck('full_name', 'id');
return view('report_create')->with('clients', $clients);

To make it work, you'll also need to define an accessor in the Client model:

public function getFullNameAttribute()
{
    return $this->name.' '.$this->surname;
}

Then just create the list:

{!! Form::select('connected_with', $clients) !!}