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?
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:
Get Last Inserted value:
There is also
newId
function, witch returns the next new ID, so you can use it to insert a new row.Now you can do whatever you want with your
$id
.Did you try this ? This also works fine.