Get the value instead of key with Laravel collection

Question

$job_types = DB::table('jobs')->pluck('job_type')->unique();

Upper code return a collection as below.

Also below Laravel Blade code make select list with upper collection.

<!-- Job Type Field -->
<div class="form-group col-sm-4" >
    {!! Form::label('job_type', 'Emne:') !!}        
    {!! Form::select('job_type', $job_types, null, ['class' => 'form-control', 'id' => 'job_type']) !!}
</div>

This is return view as select box.

So my goal was post selected value in the select box. but I got these keys like 0, 2, 17, 6 as value in the DB. I got still only KEY instead of Value.

How could I get the value to insert data into DB?

Answer 1

You can simply give the second parameter to the pluck method:

$job_types = DB::table('jobs')->pluck('job_type', 'job_type')->unique();

However, I think you should reconsider the practice of storing the value as it may result in database normalization violations.