I have two tables in laravel 5.3: 1. users table
Schema::create('users', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('email')->unique();
$table->string('password')->default('password');
$table->string('phone');
$table->boolean('is_activated')->default(0);
$table->string('**org_name**');
$table->rememberToken();
$table->timestamps();
});
2.table organization details:
Schema::create('table_organization_details', function (Blueprint $table) {
$table->increments('org_id');
$table->integer('user_id')->unsigned()->unique();
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
$table->string('amount_remainder');
$table->string('status');
$table->string('org_name');
$table->string('ATapi_key');
$table->string('ATusername');
$table->timestamps();
});
Essentially a user is signed up and his or her details saved in users table. Of interest is users.org_name which is connected to table_organization_details.org_name.
How can I insert org_name and user_id (which is foreignkey to user.id) into table table_organization_details as well?
When a user registers an org_name on users table, I would want that org_name also inserted on table_organization_details and his row id on users table inserted as user_id on table_organization_details as well.
This will help me to fill other entries for the table_organization_details with this association.
I create a user as below:
$user = User::create([
'org_name' => $organization_name,
'email' => $email_address,
'name' => $userName,
'password' => bcrypt('password'),
'phone' => $phone_number,
]);
Would someone please guide me?
Thank you.