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?
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?
Did you try this ? This also works fine.
//just after you call your insert($data) function .. use this
$lastInsertId = $this->getAdapter()->lastInsertId();
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.
Try below code:
To insert data:
$this->tableGateway->insert($data);
Get Last Inserted value:
$this->tableGateway->lastInsertValue;
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
.