Itzhak Avraham Itzhak Avraham - 1 year ago 157
PHP Question

Laravel 5.2 - Insert value into User column not working

I created a simple user registration application:

$confirmation_key = str_random(100);
$data = [
'email' => $post['email'],
'password' => Crypt::encrypt($post['password']),
'confirmation_key' => $confirmation_key

Of course I added a migration for it:

public function up()
Schema::create('users', function (Blueprint $table) {

The user added successfully into the database, but the confirmation key still null, not changing.
Additional question: What if i want to add another columns to User table? What i need to do?

Answer Source

You need to make sure you have added confirmation_key into $fillable property of User model like so:

protected $fillable = ['email','password','confirmation_key'];

If you want to add another columns you need to create new migration and run it and if you want to make this column fillable you need to add it to $fillable property of User model.


If you want to make any column not fillable using create of fill method you can add it into table and it won't be possible simply to do:


in those cases you will need something like this:

// here you fill fillable data
$user = new User($data);
// this way you can fill properties that are not fillable
$user->some_not_fillable_property = 'some value';
// now you save it to database
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download