Same name in this branch
- 4.7.x includes/database.pgsql.inc \db_next_id()
- 4.7.x includes/database.mysqli.inc \db_next_id()
- 4.7.x includes/database.mysql.inc \db_next_id()
Same name and namespace in other branches
- 4.6.x includes/database.pgsql.inc \db_next_id()
- 4.6.x includes/database.mysql.inc \db_next_id()
- 5.x includes/database.pgsql.inc \db_next_id()
- 5.x includes/database.mysqli.inc \db_next_id()
- 5.x includes/database.mysql.inc \db_next_id()
- 7.x includes/database/database.inc \db_next_id()
- 8.9.x core/includes/database.inc \db_next_id()
Return a new unique ID in the given sequence.
For compatibility reasons, Drupal does not use auto-numbered fields in its database tables. Instead, this function is used to return a new unique ID of the type requested. If necessary, a new sequence with the given name will be created.
Related topics
4 calls to db_next_id()
- node_save in modules/
node.module - Save a node object into the database.
- system_update_146 in database/
updates.inc - system_update_151 in database/
updates.inc - system_update_159 in database/
updates.inc - Retrieve data out of the old_revisions table and put into new revision system.
File
- includes/
database.mysqli.inc, line 197 - Database interface code for MySQL database servers using the mysqli client libraries. mysqli is included in PHP 5 by default and allows developers to use the advanced features of MySQL 4.1.x, 5.0.x and beyond.
Code
function db_next_id($name) {
$name = db_prefix_tables($name);
db_query('LOCK TABLES {sequences} WRITE');
$id = db_result(db_query("SELECT id FROM {sequences} WHERE name = '%s'", $name)) + 1;
db_query("REPLACE INTO {sequences} VALUES ('%s', %d)", $name, $id);
db_query('UNLOCK TABLES');
return $id;
}