Php/docs/mysqlnduhconnection.getlastinsertid

• PHP Manual
• MysqlndUhConnection
• Returns the auto generated id used in the last query

MysqlndUhConnection::getLastInsertId

(PECL mysqlnd-uh >= 1.0.0-alpha)

MysqlndUhConnection::getLastInsertId — Returns the auto generated id used in the last query

说明

public MysqlndUhConnection::getLastInsertId ( mysqlnd_connection $connection ) : int

Returns the auto generated id used in the last query.

参数

connection

Mysqlnd connection handle. Do not modify!

返回值

Last insert id.

范例

Example #1 MysqlndUhConnection::getLastInsertId() example

<?phpclass proxy extends MysqlndUhConnection { public function getLastInsertId($res) {   printf("%s(%s)\n", __METHOD__, var_export(func_get_args(), true));   $ret = parent::getLastInsertId($res);   printf("%s returns %s\n", __METHOD__, var_export($ret, true));   return $ret; }}mysqlnd_uh_set_connection_proxy(new proxy());$mysqli = new mysqli("localhost", "root", "", "test");$mysqli->query("DROP TABLE IF EXISTS test");$mysqli->query("CREATE TABLE test(id INT AUTO_INCREMENT PRIMARY KEY, col VARCHAR(255))");$mysqli->query("INSERT INTO test(col) VALUES ('a')");var_dump($mysqli->insert_id);?>

以上例程会输出：

proxy::getLastInsertId(array (
  0 => NULL,
))
proxy::getLastInsertId returns 1
int(1)

参见

• mysqlnd_uh_set_connection_proxy() - Installs a proxy for mysqlnd connections
• mysqli_insert_id() - 返回最后一条插入语句产生的自增 ID
• mysql_insert_id() - 取得上一步 INSERT 操作产生的 ID