Search the database and return the value - Laravel

Question

I’m doing a search in my database, I want to take the value found and save it (are two different tables) but the value is not being saved, is being saved the number 0.

I use this command in my controller:

$clientes = DB::table('cliente')->pluck('razaosocial', 'id');
return view('admin.contrato.create', ['cliente' => $clientes]);

And in my view I use this:

<div class="form-group col-md-5">
     {{ Form::label('cliente', 'Cliente') }}
         <select class="js-example-basic-multiple" name="cliente_id" >
            <option selected>Selecione o cliente</option>
              @foreach ($cliente as $cli)
                <option value="{{ $cli }}">{{ $cli }}</option>
              @endforeach
         </select>
</div>

When I use it, I see the data, but I can’t save it. I don’t know much about PHP, someone knows how I can solve it?

Answer 1

You’re passing the social reason to the database, Try it that way:

<div class="form-group col-md-5">
     {{ Form::label('cliente', 'Cliente') }}
         <select class="js-example-basic-multiple" name="cliente_id" >
            <option selected>Selecione o cliente</option>
              @foreach ($cliente as $key => $value)
                <option value="{{ $value }}">{{ $key }}</option>
              @endforeach
         </select>
</div>

Answer 2

Try:

@foreach ($cliente as $cli)
    <option value="{{ $cli->id }}">{{ $cli->razaosocial }}</option>
@endforeach