| public getLastInsertID ( string $sequenceName = '' ) : string | ||
| $sequenceName | string | name of the sequence object (required by some DBMS) |
| return | string | the row ID of the last row inserted, or the last value retrieved from the sequence object |
public function getLastInsertID($sequenceName = '')
{
if ($this->db->isActive) {
// get the last insert id from the master connection
$sequenceName = $this->quoteSimpleTableName($sequenceName);
return $this->db->useMaster(function (Connection $db) use($sequenceName) {
return $db->createCommand("SELECT {$sequenceName}.CURRVAL FROM DUAL")->queryScalar();
});
} else {
throw new InvalidCallException('DB Connection is not active.');
}
}