Database Relationship - Laravel

Question

I am having issues inserting data into my database tables. I have users table which is has a relation of one to many to school table and region table. That is, users table has foreign keys of school and region tables.

I have created the relations correctly but then when i try to insert values into the database, i get the error.

PS: I have one user(admins) in the user table (the school_id and region_id was inserted accurately) already which i saved through RegisterController. Now, when i sign in with the user(admin) already saved, i want to save other users through the UserController but then i get the error above.

What am i not doing right?. I am only a beginner with database relationship and laravel

General error: 1364 Field 'school_id' and `region_id`doesn't have a default value

meaning the field cannot be empty.

UserController

 public function store(UserFormRequest $request)
    {
        $user = new User(array(
             'name' => $request->get('name'),
             'email' => $request->get('email'),
             'password'=> $request->get('password'),
             'phone' => $request->get('phone')           

              ));
        $user->save();

    }

Zulfiqar Tariq · Accepted Answer · 2017-10-14 20:24:55Z

1

there are three solutions to your problem.

1

 public function store(UserFormRequest $request)
    {
        $user = new User(array(
             'name' => $request->get('name'),
             'email' => $request->get('email'),
             'password'=> $request->get('password'),
             'phone' => $request->get('phone'),
             'school_id'=>'you must pass value here',
             'region_id'=>'you must pass value here'        

              ));
        $user->save();

    }

2 Go to phpmyadmin make your school_id,region_id default value NULL. so you are good to go.

answered Oct 14, 2017 at 20:24

Zulfiqar Tariq

3943 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

tptcat · Accepted Answer · 2017-10-14 14:13:19Z

1

MySQL is telling you that those fields can't be empty because they aren't nullable.

To make those fields nullable() in your users migration:

// Your create users table migration
$table->integer('school_id')->nullable();
$table->integer('region_id')->nullable();

(You can add any other properties to these - like index(), unsigned(), or foreign keys, etc.)

answered Oct 14, 2017 at 14:13

tptcat

3,9712 gold badges36 silver badges52 bronze badges

Collectives™ on Stack Overflow

Database Relationship - Laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related