insert foreign key value laravel with migration in laravel

Question

I want to insert foreign key when I will migration than add a foreign key value in 1

`public function up()
    {
        Schema::table('users', function (Blueprint $table) {
      $table->integer('role_id')->unsigned()->after('email')->nullable();
        $table->foreign('role_id')->references('id')->on('roles');
        });
        $data = [
            'name' => 'admin',
            'email' => 'admin@admin.com',
            'role_id' => 1,
            'password' => bcrypt('123456'),
        ];
        App\User::create($data);
    }`

Here is screenshot of the users table

yes, First i insert data in role table than insert user table — Md Majadul Islam, Mar 02 '18 at 04:55
is `role_id` fillable exist in your model? Have a look at my answer — FULL STACK DEV, Mar 02 '18 at 04:58

score 4 · Accepted Answer · answered Mar 02 '18 at 04:56

It is not a good practice to seed data inside Migrations.

Make sure role_id exists in a referenced table.

Also make sure role_id is not gaurded and exist in your fillable array of your User Model.

$fillable = ['role_id']

I would suggest creating a seeder then run the seeder after migration.

php artisan make:seed User

Hope this helps

score 0 · Answer 2 · answered Mar 02 '18 at 04:56

0

create migration set defualt value 1 in foregin key

 $table->integer('role_id')->unsigned()->after('email')->nullable()->default(1);

answered Mar 02 '18 at 04:56

Ravindra Bhanderi

2,478
4
17
29

insert foreign key value laravel with migration in laravel

2 Answers2