(PECL CUBRID >= 8.3.0)
cubrid_insert_id
—
Return the ID generated for the last updated
AUTO_INCREMENT
column
The cubrid_insert_id() function retrieves the ID generated for the AUTO_INCREMENT column which is updated by the previous INSERT kery. It returns 0 if the previous kery does not generate new rows, or FALSE on failure.
Note :
CUBRID suppors 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 kery, on success.
0, if the previous kery does not generate new rows.
false
on failure.
| Versionen | Description |
|---|---|
| 8.4.0 | Changue 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
);
?>
The above example will output:
string(2) "19"