Setting selected option in laravel from database

Question

I have a problem here, I want to make an edit form, I want the province that appears in the edit form to be the province selected from the database, here my code

  <select name="provinsi" id="provinsi" class="form-control">
                <option value="">Pilih Provinsi</option>
                @foreach ($province as $prov)
                <option value="{{$prov->name}}">{{$prov->name}}</option>
                @endforeach
            </select>

here my controller code

public function ShowSantri(Request $request,$id)
    {

        $province = DB::table('provinces')->get();
        $profiles = Profile::find($request->id);

        return view('admin/modal/edit_santri',compact('profiles','province'));

mare96 · Accepted Answer · 2019-12-29 12:03:22Z

1

You can try like this:

<select name="provinsi" id="provinsi" class="form-control">
    <option value="">Pilih Provinsi</option>
    @foreach ($province as $prov)
         <option value="{{$prov->name}}"
             @if ($profiles['provName'] == $prov->name)
                 selected
             @endif>
             {{$prov->name}}
         </option>
    @endforeach
</select>

Just I'm not sure what is name in your $profiles for province. But I think that is what you need.

Here and here are some examples.

Good luck!

answered Dec 29, 2019 at 12:03

mare96

3,8541 gold badge22 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rouhollah Mazarei · Accepted Answer · 2019-12-29 12:04:07Z

1

Use or change this code based on your needs:

<option value="{{$prov->name}}" {{ $prov->name == $profiles->prov_id ? "selected" : "" }}>{{$prov->name}}</option>

I think the $prov->name should be $prov->id, if not, you can change $profiles->prov_id to $profiles->prov_name. It depends on your database structure.

answered Dec 29, 2019 at 12:04

Rouhollah Mazarei

4,1631 gold badge18 silver badges20 bronze badges

Collectives™ on Stack Overflow

Setting selected option in laravel from database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related