How can I save request data into database at once?

What I did:

        $obj=new User();
        $obj->first_name=$request->input('firstName');
        $obj->last_name=$request->input('lastName');
        $obj->email=$request->input('email');
        $obj->password=bcrypt($request->input('password'));
        $obj->save();

Is it possible to do something in this way instead of getting single input by $request->input()?

        $obj=new User();
        $obj->save($request->all());

tisuchi

5 years ago

Level 70

@cola You can. But you need to change a few things-

User::create($request->only(['firstName', 'lastname', 'email', 'password']));

Now in your model, make sure that you allow mass assignment.

User.php

protected $guarded = [];

// This for password bcrypt. 
public function setPasswordAttribute($value){
	$this->password = bcrypt($value);
}

cola

5 years ago

Level 1

User::create($request->only(['firstName', 'lastname', 'email', 'password']));

How will 'firstName' map with $obj->first_name column?

tisuchi

5 years ago

Level 70

@cola Yes, it should be like that, I believe.

Tray2

5 years ago

Level 73

I use the same name for my form element and my column name, that way I never have to worry about it.

Tray2

5 years ago

Level 73

You should also validate the data before inserting anything.

Snapey

5 years ago

Level 122

if your variable is a user then call it $user not $obj - it makes your code easier to understand

Yes, you can mass assign an array to a model, but pay attention to name your form fields exactly the same as the columns on your database. If you don't do this then you need to map each field across manually.

Personally I avoid mass assignment. I prefer to be explicit in my code, and it also gives opportunity to give special treatment to individual columns as they are saved

Please or to participate in this conversation.