Set field to null - Codeigniter

Question

Hello, beauty?

I’m making a update in a table and I am sending the data array. However, I have a date field. Every time I update, it sends the field as 'dtnascimento' = ''. When this data arrives in the database, my database arrow the date as 0000-00-00.

What I wish to do: make a check if my the position of my array is null. If null, set the value to arrive in the database as (NULL).

Below my current code:

function atualizarFuncionario($dados){

    if ($dados['dtnascimento'] === '') {
        $dados['dtnascimento'] = NULL;
    }

    $where = array(
     'idfuncionario'    => $dados['idfuncionario'],
     'idempresa'        => $dados['idempresa']
    );
    $this->db->update($this->tabela,html_escape($dados),$where);

}

If anyone knows, a moral there rs

Answer 1

Dude, why don’t you arrow in Active Record which fields you want to update?

Particularly I prefer to update only the specific data:

Assuming you will update only the name (which is filled in) and the date field, which you do not know is filled in...

$this->db-trans_begin();
$this->db->set('Nome', $dados['Nome']);
if($dados['dtnascimento'] != ''){
   $this->db->set('Data', $dados['dtnascimento']);
}
$this->db->where('idfuncionario', $dados['idfuncionario']);
$this->db->where('idempresa', $dados['idempresa']);
$this->db->update('tabela');
if($this->db->trans_status() === true){
   $this->db->trans_commit();
}else{
   $this->db->trans_rollback();
}

Thus, if the date field is not filled in, it changes nothing... I hope I helped. Oss!

Answer 2

Usually I wear the unset()

function atualizarFuncionario($dados){

    if ($dados['dtnascimento'] === '') {
        unset($dados['dtnascimento']);
    }

    $where = array(
     'idfuncionario'    => $dados['idfuncionario'],
     'idempresa'        => $dados['idempresa']
    );
    $this->db->update($this->tabela,html_escape($dados),$where);

}