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

score 33 · Accepted Answer · answered Jan 30 '11 at 09:11

33

try

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

answered Jan 30 '11 at 09:11

Haim Evgi

10

In my version of Zend `insert` returns an int, but it's the number of affected rows not the last inserted row! – algorhythm Jun 20 '14 at 15:34
2

Zend 2 does not return the id, it returns the affected amount of rows. – JordyvD May 31 '16 at 14:42

score 32 · Answer 2 · edited Nov 03 '11 at 14:05

32

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

edited Nov 03 '11 at 14:05

S L

answered Aug 29 '11 at 04:14

Art3mk4

score 15 · Answer 3 · answered Jul 30 '11 at 13:28

15

you can use lastInsertId Method

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

answered Jul 30 '11 at 13:28

dckur

RaviPatidar · Answer 4 · 2020-02-20T10:26:05.667

2

use after insert query

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

edited Feb 20 '20 at 10:26

answered Oct 27 '16 at 11:30

RaviPatidar

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 – Bitterblue Oct 01 '18 at 09:25

score 1 · Answer 5 · answered May 14 '13 at 19:21

1

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

answered May 14 '13 at 19:21

glitchyme

5 Answers5