使用CI购物车添加项目后获取rowid？

Question

On the codeigniter website it says the the insert() method will return a $rowid of the latest inserted product. However How exactly do I grab it?

$data = array();

$insert = $this->cart->insert($data);

I tried $insert['rowid'] and $insert->rowid but neither seem to work.

Thank you!

Answer 1

introducing: insert_id()

like this

$id = $this->db->insert_id();
return $id;

in your model, lets call it friend_model

function insertRow()
{
// Prepare data, normally you would pass this in
$data = array(
'first' => 'john',
'last' => 'smith'
);
// insert data
$this->db->insert( 'friends', $data );
// confirm insert       
if ( $this->db->affected_rows() == '1' )
// return new ID
{ $id = $this->db->insert_id();
return $id; }
// else did not insert, return false 
else {return FALSE;}
}

in your controller, check if you got an id back from model

if(! $id = $this->friend_model->insertRow() )
// it no work
{ // some error method 
}
else
{ // success ! 
}