如何使用mysqli准备语句获取insert_id

Question

如何使用mysqli prepare语句获取最后一条记录的insert_id，例如以下示例？

$stmt = $this->mysqli->prepare("INSERT INTO test (name) values (?)")
$stmt->bind_param('s', $name);
$stmt->execute();

- Ajay

Answer 1

$stmt->execute()之后，$new_id = $this->mysqli->insert_id;

- a1ex07

Answer 2

{{link1：mysqli->insert_id}}

(Note: This is the same text in Chinese, just with the appropriate characters for punctuation and symbols.)

- jspcal