在mysqli预处理语句程序样式中获取最后一个插入id的正确方法是什么？(Which is correct way to get last inserted id in mysqli prepared statements procedural style?)

 我正在使用mysqli预处理语句在这样的表中插入记录 
 
$link = mysqli_connect('localhost', 'my_user', 'my_password', 'world');

/* check connection */
if (!$link) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$stmt = mysqli_prepare($link, "INSERT INTO CountryLanguage VALUES (?, ?, ?, ?)");
mysqli_stmt_bind_param($stmt, 'sssd', $code, $language, $official, $percent);

$code = 'DEU';
$language = 'Bavarian';
$official = "F";
$percent = 11.2;

/* execute prepared statement */
mysqli_stmt_execute($stmt);

if(mysqli_stmt_affected_rows($stmt) > 0){
//if insert is successful then get the insrted id.


}

/* close statement and connection */
mysqli_stmt_close($stmt);

/* close connection */
mysqli_close($link);
 
 并且想获得最后插入的id，因为该表具有record_num字段，该字段是自动增量。 
 
 所以我的问题是我应该在函数内放置连接名称或语句名称。 
 
 即1） 
 
echo mysqli_insert_id($link);
 
 资料来源： http ： //php.net/manual/en/mysqli.insert-id.php 
 
 2） 
 
echo mysqli_stmt_insert_id($stmt);
 
 资料来源： http ： //php.net/manual/en/mysqli-stmt.insert-id.php 
 
 哪一个是正确的？ $ stmt中哪一个会给我最后一个ins id？ 
 
 
 
 没有其他插入使用相同的stmt同一页面进行。* 
 
 
 
 更新： 
 
 根据http://php.net/manual/en/mysqli-stmt.insert-id.php的说明 
 
 我只做单插入，所以我想我可以使用 
 
mysqli_stmt_insert_id($stmt)
 
 但是在使用预处理语句进行多次插入时 
 
echo mysqli_insert_id($link);
 
 是最好的做法。 

i am using mysqli prepared statement to insert record in the table like this
 
$link = mysqli_connect('localhost', 'my_user', 'my_password', 'world');

/* check connection */
if (!$link) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$stmt = mysqli_prepare($link, "INSERT INTO CountryLanguage VALUES (?, ?, ?, ?)");
mysqli_stmt_bind_param($stmt, 'sssd', $code, $language, $official, $percent);

$code = 'DEU';
$language = 'Bavarian';
$official = "F";
$percent = 11.2;

/* execute prepared statement */
mysqli_stmt_execute($stmt);

if(mysqli_stmt_affected_rows($stmt) > 0){
//if insert is successful then get the insrted id.


}

/* close statement and connection */
mysqli_stmt_close($stmt);

/* close connection */
mysqli_close($link);
 
and would like to get the last inserted id , as the table has record_num field which is auto increment .
 
so my question is should i place connection name or the statement name inside the function.
 
i.e 1)
 
echo mysqli_insert_id($link);
 
Source: http://php.net/manual/en/mysqli.insert-id.php
 
2)
 
echo mysqli_stmt_insert_id($stmt);
 
Source: http://php.net/manual/en/mysqli-stmt.insert-id.php
 
which one is correct ? which one will give me last insrted id by the $stmt ?
 
 
 
there are no other inserts are being done using the same stmt one the same page..*
 
 
 
Update:
 
according to the note from http://php.net/manual/en/mysqli-stmt.insert-id.php
 
I am doing only single insert so i guess i can use 
 
mysqli_stmt_insert_id($stmt)
 
but while doing multiple inserts using prepared statements using 
 
echo mysqli_insert_id($link);
 
is best practice.

原文：https://stackoverflow.com/questions/25226740