Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

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

General Tech Bugs & Fixes
Max. 2000 characters
Replies

usr_profile.png
Shreya Bansal

User

( 7 months 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.

what's your interest


forum_ban8_5d8c5fd7cf6f7.gif