ini soal many to many. intinya mau CRUD tabel pivot.

jadi gini bang. saya ada 3 tabel

tabel 1

nama tabel : member isi kolomnya id dan member_name

tabel 2

nama tabel : prize isi kolomnya id dan prize_name

tabel 3

nama tabel : member_prize isi kolomnya member_id dan prize_id

intinya saya mau CRUD di tabel member_prize.

jadi misalkan

di formnya nanti saya pakai select namanya trs pilih select jg hadiahnya nanti data di submit, data yg di submit ke kirim ke tabel member_prizenya

kalo di gambarkan kek gini bang tampilannya

9.png ini kurang lebih begini code saya keseluruhan

 </form>

                <form class="col-md-6" action="/storeMemberPrize" method="POST">
                    {{ csrf_field() }}
                    <label class="mt-3"> Choose Name </label>
                    <select id="inputstate" name="prize_id[]" type="text" class="form-control" required>
                    <option selected> choose name here</option>
                    @foreach($prize as $ab)
                        @foreach($ab->member as $a)
                            <option value="{{$a->id}}">{{ $a->name_member }}</option>
                        @endforeach
                    @endforeach
                    </select>

                    <label class="mt-3"> Choose Prize </label>
                    <select id="inputstate" name="prize_id[]" type="text" class="form-control" required>
                    <option selected> choose prize here</option>
                    @foreach($prize as $ab)
                            <option value="{{$ab->id}}">{{ $ab->name_prize }}</option>
                    @endforeach
                    </select>
                    <button type="submit" class="btn btn-primary waves-effect mt-3">Add Data</button>
            </form>

cuman untuk form choose name gak keluar view select optionya

10.png

ini controller saya bang

public function create()
    {
        $prizes = Prize::all();
        return view('create', ['prize' => $prizes ]);
    }

public function storeMemberPrize(Request $request) {model apa yang saya harus panggil? dan cara storenya bagaimana?};

ini model saya

1. model prize

class Prize extends Model
{
    protected $table = "prize";

    public function member()
    {
        return $this->belongsToMany(Member::class, 'Member_prize', 'member_id', 'prize_id')->withTimestamps();
    }
}

2. model member

class Member extends Model
{
    protected $table = "member";

    protected $fillable = [
        'name_member'
    ];

    public function prize()
    {
        return $this->belongsToMany(Prize::class, 'Member_prize', 'member_id', 'prize_id')->withTimestamps();
    }
}

model Member_prize

class Member_prize extends Model
{
    protected $table = "member_prize";

    protected $fillable = ['member_id', 'prize_id'];

}