How to get insert id properly?

[shtse8]

I am trying to get the last insert id. But I am using it in pool mode, will it affect the result by other inserts?

$resultSet = yield $pool->prepare("INSERT INTO `table` (`data`) VALUE (:data)", ['data' => $data]);
$insertId= $resultSet->getConnInfo()->insertId;

Is it the correct code to get the insertId?

[kelunik]

You don't get a ResultSet for insert queries. You can use the following snippet, it resolves to a connection info object.

$info = yield $conn->prepare(
    "INSERT INTO bugs (title, data, submitter) " . 
    "VALUES (:title, :data, :submitter)",
    ["title" => $title, "data" => $data, "submitter" => $uid]
);
$id = $info->insertId;