Laravel not updating null values to column

Question

Migration

Schema::create('users', function (Blueprint $table) {
        $table->increments('user_id');
        $table->string('username',50)->unique();
        $table->date('start_date');
        $table->date('end_date')->nullable();
        $table->timestamps();
    });

Here start_date set as column type date and nullable

When running Insert function like below its inserting null values

$insert = [
    'username'  =>strtoupper(request('username')),
    'password'  =>Hash::make(request('password')),
    'start_date'  =>date('Y-m-d',strtotime(request('start_date'))),
  ];
  if(request()->filled('end_date')){
    $insert['end_date'] = date('Y-m-d',strtotime(request('end_date')));
  }
  User::create($insert);

When Updating the same row left blank as end_date input,

$user = User::GetWithEncrypted(request('user_id'));
$update ['start_date'] = date('Y-m-d',strtotime(request('start_date')));
if(request()->filled('end_date')){
  $update['end_date'] = date('Y-m-d',strtotime(request('end_date')));
}else{
  $update['end_date'] = 'NULL';
}
$user->update($update);

In Table, it comes like below

How can I make it NULL like insert function in update? My strict mode is false now, If I make it true it will throw an exception of invalid data for the end_date column.

Harry · Accepted Answer · 2018-12-05 13:15:36Z

16

Try replacing

}else{
  $update['end_date'] = 'NULL';
}

with

}else{
  $update['end_date'] = null;
}

'NULL' is a string whereas null is truly null.

edited Dec 5, 2018 at 13:15

answered Dec 5, 2018 at 13:10

Harry

3993 silver badges13 bronze badges

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

Comments

Bhoomi Patel · Accepted Answer · 2018-12-05 12:29:32Z

0

you have 2 solution for this problem:

1.

$user = User::GetWithEncrypted(request('user_id'));
    $update ['start_date'] = date('Y-m-d',strtotime(request('start_date')));
    if(request()->filled('end_date')){
      $update['end_date'] = date('Y-m-d',strtotime(request('end_date')));
    }else{
      $update['end_date'] = '".date('00:00:00')."';
    }
    $user->update($update);

2. you have to set default in mysql database on end date field

answered Dec 5, 2018 at 12:29

Bhoomi Patel

77510 silver badges32 bronze badges

Comments

Shahriyar · Accepted Answer · 2021-03-06 08:29:06Z

0

First set table field to nullable()
Second set table field DEFAULT to NULL

Third:

$model->field = null;

answered Mar 6, 2021 at 8:29

Shahriyar

236 bronze badges

Collectives™ on Stack Overflow

Laravel not updating null values to column

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related