Fetch the data along with matching key and amount that has already been set up. using laravel

manpreet Best Answer 3 years ago

This is my key table.

  public function up()
{
    Schema::create('salery_keys', function (Blueprint $table) {
        $table->increments('id');
        $table->string('key_name');
        $table->text('description')->nullable();
        $table->timestamps();
        $table->softDeletes();
    });
}

and in this table, I am storing all keys that the user chose along with user id. as you can I reference everything in the code

 public function up()
{
    Schema::create('selery_setuptable', function (Blueprint $table) {
        $table->increments('id');
        $table->integer('user_id')->unsigned();
        $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
        $table->integer('salery_key_id')->unsigned();
        $table->foreign('salery_key_id')->references('id')->on('salery_keys')->onDelete('cascade');
        $table->string('amount', 100)->nullable();
        $table->timestamps();

    });
}

as you can see in this image I want to show to the user table column that he already checked before. checked will be checked and others will have left remain unchecked for the user to check later if he/she wants.