Laravel - Setting null to model columns has no effect

Question

I'm trying to set a null value on a Model column but it gets ignored and it doesn't update.

if($rol_colegio)
    $update_pl['rol_colegio'] = $rol_colegio; //$rol_colegio may be null

$usuario->update($update_pl);

The data does get updated successfully when I try to use non-null data, but if the variable is null this entry doesn't get updated.

What would be the cause of this?

IndianCoding · Accepted Answer · 2019-05-28 00:07:22Z

3

$rol_colegion = null doesn't match condition if($rol_colegio).

Just remove if($rol_colegio).

answered May 28, 2019 at 0:07

IndianCoding

2,6831 gold badge9 silver badges13 bronze badges

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

1 Comment

I'm banging my head on the desk at the moment. Thank you.

Jesus Erwin Suarez · Accepted Answer · 2019-05-28 00:36:03Z

0

Just simply do like this.

$update_pl['rol_colegio'] = $rol_colegio; //$rol_colegio may be null

$usuario->update($update_pl);

answered May 28, 2019 at 0:36

1,59517 silver badges17 bronze badges