CODEWITHSUNDEEP
phpcodeigniterinsert
Wagner Fillio
Wagner Fillio

Reputation: 405

Codeigniter - Recover ID?

I need to retrieve the last ID inserted in a table and pass this ID to the field of another function

Recover ID this way is possible ?

$negociacao = array(
            'id'             => $neg->id,
            'dt_negociacao'  => $neg->dt_negociacao,
            'atualizar'      => $neg->atualizar,
            'contrato_id'    => $neg->contrato_id,
            'id_finalizacao' => $neg->id_finalizacao,
            'crud'           => "C",
        );
    $this->db->insert('tbl_devedor_negociacao', $negociacao);
    $negociacao_id = $this->db->insert_id();
    $this->set_negociacao_id($negociacao_id);

// set ID
private function set_negociacao_id($negociacao_id = null)
{       
    return $negociacao_id;
}

// get ID
private function get_negociacao_id()
{
    $this->set_negociacao_id();
}

// Assign retrieved ID here
'negociacao_id'  => $this->set_negociacao_id(),

Upvotes: 1

Views: 70

Answers (2)

Wagner Fillio
Wagner Fillio

Reputation: 405

So solved

// Setter ID negociacao
private $negociacao_id;
private function set_negociacao_id($negociacao_id)
{
    $this->negociacao_id = $negociacao_id;
}   
// Getter ID negociacao
private function get_negociacao_id()
{
    return $this->negociacao_id;
}


'negociacao_id'  => $this->get_negociacao_id(),

Upvotes: 1

B. Desai
B. Desai

Reputation: 16436

You are getting correct inserted ID. But issue with getter and setter change it as below

// set ID
private function set_negociacao_id($negociacao_id = null)
{       
    $this->negociacao_id = $negociacao_id;
}

// get ID
private function get_negociacao_id()
{
    return $this->negociacao_id;
}

// Assign retrieved ID here
'negociacao_id'  => $this->get_negociacao_id(),

Upvotes: 1

Related Questions