MysqlndUhConnection::getLastInsertId

(PECL mysqlnd-uh >= 1.0.0-alpha)

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

说明

public int MysqlndUhConnection::getLastInsertId ( mysqlnd_connection $connection )

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

  <?php
 class  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() - Returns the auto generated id used in the last query
mysql_insert_id() - 取得上一步 INSERT 操作产生的 ID