©
本文档使用 PHP中文网手册 发布
(PECL CUBRID >= 8.3.0)
cubrid_insert_id — Return the ID generated for the last updated AUTO_INCREMENT
column
$conn_identifier
] )The cubrid_insert_id() function retrieves the ID generated for the AUTO_INCREMENT column which is updated by the previous INSERT query. It returns 0 if the previous query does not generate new rows, or FALSE on failure.
Note:
CUBRID supports AUTO_INCREMENT for more than one columns in a table. In most cases, there will be a single AUTO_INCREMENT column in a table. If there are multiple AUTO_INCREMENT columns, this function should not be used even if it will return a value.
conn_identifier
The connection identifier previously obtained by a call to cubrid_connect() .
A string representing the ID generated for an AUTO_INCREMENT column by the previous query, on success.
0, if the previous query does not generate new rows.
FALSE
on failure.
版本 | 说明 |
---|---|
8.4.0 | Change the return value from an array to string; Remove the first parameter class_name. |
Example #1 cubrid_insert_id() example
<?php
$conn = cubrid_connect ( "localhost" , 33000 , "demodb" );
@ cubrid_execute ( $conn , "DROP TABLE cubrid_test" );
cubrid_execute ( $conn , "CREATE TABLE cubrid_test (d int AUTO_INCREMENT(1, 2), t varchar)" );
for ( $i = 0 ; $i < 10 ; $i ++) {
cubrid_execute ( $conn , "INSERT INTO cubrid_test(t) VALUES('cubrid_test')" );
}
$id = cubrid_insert_id ();
var_dump ( $id );
cubrid_disconnect ( $conn );
?>
以上例程会输出:
string(2) "19"