Manual do PHP
Anterior |  | Próxima

# maxdb_insert_id

(PECL)

maxdb_insert_id

(no version information, might be only in CVS)

maxdb->insert_id -- Returns the auto generated id used in the last query

## Description

Procedural style:

mixed maxdb_insert_id ( resource link )

Object oriented style (property):

class maxdb {
mixed insert_id
}

The maxdb_insert_id() function returns the ID generated by a query on a table with a column having the DEFAULT SERIAL attribute. If the last query wasn't an INSERT or UPDATE statement or if the modified table does not have a column with the DEFAULT SERIAL attribute, this function will return zero.

## Valores de retornado

The value of the `DEFAULT SERIAL` field that was updated by the previous query. Returns zero if there was no previous query on the connection or if the query did not update an `DEFAULT_SERIAL` value.

> Nota: If the number is greater than maximal int value, maxdb_insert_id() will return a string.

## Example

Exemplo 1. Object oriented style
`<?php $maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB"); /* check connection */ if (maxdb_connect_errno()) { printf("Connect failed: %s\n", maxdb_connect_error()); exit(); } maxdb_report (MAXDB_REPORT_OFF); $maxdb->query("DROP TABLE mycity"); maxdb_report (MAXDB_REPORT_ERROR); $maxdb->query("CREATE TABLE mycity LIKE hotel.city"); $maxdb->query("ALTER TABLE mycity ADD id FIXED(11) DEFAULT SERIAL"); $query = "INSERT INTO mycity (zip,name,state) VALUES ('12203','Albany' ,'NY')"; $maxdb->query($query); printf ("New Record has id %d.\n", $maxdb->insert_id); /* drop table */ $maxdb->query("DROP TABLE mycity"); /* close connection */ $maxdb->close(); ?>`

Exemplo 2. Procedural style
`<?php $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB"); /* check connection */ if (maxdb_connect_errno()) { printf("Connect failed: %s\n", maxdb_connect_error()); exit(); } maxdb_report (MAXDB_REPORT_OFF); maxdb_query($link,"DROP TABLE mycity"); maxdb_report (MAXDB_REPORT_ERROR); maxdb_query($link, "CREATE TABLE mycity LIKE hotel.city"); maxdb_query($link, "ALTER TABLE mycity ADD id FIXED(11) DEFAULT SERIAL"); $query = "INSERT INTO mycity (zip,name,state) VALUES ('12203','Albany' ,'NY')"; maxdb_query($link, $query); printf ("New Record has id %d.\n", maxdb_insert_id($link)); /* drop table */ maxdb_query($link, "DROP TABLE mycity"); /* close connection */ maxdb_close($link); ?>`

The above examples would produce the following output:

    New Record has id 1.

Anterior | Principal | Próxima
maxdb_init | Acima | maxdb_kill