last insert id with zend db table abstract

Question

variable $tablemodel in an instance of a model which extends Zend_Db_Table_Abstract, if i do

$tablemodel->insert($data)

to insert data. Is there any method or property to get last insert id?

regards

Varix

Answer 1

try

$id = $tablemodel->insert($data);  
echo $id;

Tonguetied

In my version of Zend insert returns an int, but it's the number of affected rows not the last inserted row! – Viridity

Zend 2 does not return the id, it returns the affected amount of rows. – Intracranial

Answer 2

$last_id = $tablemodel->getAdapter()->lastInsertId();

Sokol

Answer 3

you can use lastInsertId Method

echo 'last inserted id: ' . $db->lastInsertId();

Flux

Where does $db come from? – Intracranial

Answer 4

use after insert query

$this->dbAdapter->getDriver()->getLastGeneratedValue();

Thermoluminescence

Now THIS one works for a change. I use an auto incremented primary key 'id'. So if you have your adapter, get the driver and it should work. Also Zend-Db v2.9 – Neuron

Answer 5

$insert_id = $this->db->getLastId() worked for me

Inhospitality