Inserting a new robot
$success = $connection->insert(
'robots',
['Astro Boy', 1952],
['name', 'year'],
);
Getting the generated id
$id = $connection->lastInsertId();
public lastInsertId ( string $sequenceName = null ) : integer
$sequenceName
string
return
integer
public function lastInsertId($sequenceName = null)
{
$sequenceName = $sequenceName ?: 'id';
return $this->fetchAll('SELECT ' . $sequenceName . '.CURRVAL FROM dual', Db::FETCH_NUM)[0][0];
}