cubrid_insert_id

(PECL CUBRID >= 8.3.0)

cubrid_insert_idReturn the ID generated for the last updated AUTO_INCREMENT column

说明

cubrid_insert_id ([ resource $conn_identifier ] ) : string

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"
相关文章
php cubrid mysql 兼容性函数 return the number of rows affected by the last sql statementphp cubrid mysql 兼容性函数 return the current cubrid connection charsetphp cubrid mysql 兼容性函数 return the numerical value of the error message from previous cubrid operationphp cubrid mysql 兼容性函数 get column information from a result and return as an objectphp cubrid mysql 兼容性函数 return a string with the flags of the given field offsetphp cubrid mysql 兼容性函数 return the name of the specified field indexphp cubrid mysql 兼容性函数 return the type of the column corresponding to the given field offsetphp cubrid 函数 return the id generated for the last updated auto increment columnphp cubrid mysql 兼容性函数 return an array with the list of all existing cubrid databasesphp cubrid 函数 update a column using oidphp cubrid 函数 delete an element from set type column using oidphp ibm db2 函数 returns the auto generated id of the last insert query that successfully executed on this connectionphp ldap 函数 return the ldap error number of the last ldap commandphp ldap 函数 return the ldap error message of the last ldap commandphp maxdb 函数 returns the auto generated id used in the last queryphp posix 函数 return info about a user by user idphp rrd 函数 gets information about last updated dataphp snmp 函数 return all objects including their respective object id within the specified onephp sqlite 函数 return an array of column types from a particular tablephp mysqlnduhconnection returns the auto generated id used in the last query
关注编程学问公众号