CODEWITHSUNDEEP
phpzend-frameworkzend-dbzend-db-table
Andrew
Andrew

Reputation: 239057

Zend Framework: How to retrieve the id of the last inserted row?

I'm inserting a new row into my database with this code:

$data = array(
    'key' => 'value'
);
$this->getDbTable()->insert($data);

How can I get the row id of the this row that I just created?

Upvotes: 13

Views: 30817

Answers (4)

António Almeida
António Almeida

Reputation: 10127

There is also newId function, witch returns the next new ID, so you can use it to insert a new row.

$id = $this->getDbTable->newId('table_name', 'id');

$data = array(
    'id' => $id,
    'data' => $data
);

$this->getDbTable->insertRow('table_name', $data);

Now you can do whatever you want with your $id.

Upvotes: 0

kwelsan
kwelsan

Reputation: 1219

Try below code:

To insert data:

$this->tableGateway->insert($data);

Get Last Inserted value:

$this->tableGateway->lastInsertValue;

Upvotes: 0

Amit Dugar
Amit Dugar

Reputation: 494

Did you try this ? This also works fine.

//just after you call your insert($data) function .. use this
$lastInsertId = $this->getAdapter()->lastInsertId();

Upvotes: 16

Cong
Cong

Reputation: 181

One gotcha. When calling $this->getDbTable()->insert($data); you have to make sure $data include the "primary key" of your table. For example, id=null if it's auto-increment. Otherwise, insert() will not return the last inserted ID.

Upvotes: 10

Related Questions