php - Laravel : How to Create Dropdown to Select FOREIGN KEY from Other Table?

i want to ask you how to select FOREIGN KEY (from "doa_id in "doas" table) when user create a new data (to the "notes table) in a form. This is my code :

NoteController.php

public function create()
{
    return view('note/create');
}

public function store(Request $request)
{
    $userId = Auth::user()->id;
    Note::create([
        'title' => $request->title,
        'detail' => $request->detail,
        'user_id' => $userId,
        'mood_id' => $request->mood_id,
        'doa_id' => $request->doa_id,
    ]);
    return redirect('notes');
}
Copy code

2021_05_28_020438_create_notes_table.php migration

class CreateNotesTable extends Migration
{
    public function up()
    {
        Schema::create('notes', function (Blueprint $table) {
            $table->id('note_id');
            $table->string('title');
            $table->date('created_at');
            $table->date('updated_at');
            $table->text('detail');
            $table->unsignedBigInteger('user_id');
            $table->foreign('user_id')->references('id')->on('users');
            //mood FK
            $table->unsignedBigInteger('mood_id');
            $table->foreign('mood_id')->references('mood_id')->on('moods');
            //doa FK
            $table->unsignedBigInteger('doa_id');
            $table->foreign('doa_id')->references('doa_id')->on('doas');
        });
    }

    public function down()
    {
        Schema::dropIfExists('notes');
    }
}
Copy code

and this is my dropdown html :

    <div class="container">
        <label class="form-label text-white" style="font-weight: bold;" for="doa">Doa terkait</label>
        <select class="form-select" style="color: #41A7A5" aria-label="Default select example">
            <option selected>Pilih doa</option>
        </select>
    </div>
Copy code

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.