function db_next_id

7.x db_next_id($existing_id = 0)
5.x db_next_id($name)
5.x db_next_id($name)
5.x db_next_id($name)
8.x db_next_id($existing_id = 0)

Retrieves a unique id.

Use this function if for some reason you can't use a serial field. Using a serial field is preferred, and InsertQuery::execute() returns the value of the last ID inserted.


$existing_id: After a database import, it might be that the sequences table is behind, so by passing in a minimum ID, it can be assured that we never issue the same ID.

Return value

An integer number larger than any number returned before for this sequence.

Related topics

4 calls to db_next_id()
actions_save in drupal/includes/
Saves an action and its user-supplied parameter values to the database.
batch_process in drupal/includes/
Processes the batch.
DatabaseNextIdCase::testDbNextId in drupal/modules/simpletest/tests/database_test.test
Test that the sequences API work.
user_save in drupal/modules/user/user.module
Save changes to a user account or add a new user.


drupal/includes/database/, line 2689
Core systems for the database layer.


function db_next_id($existing_id = 0) {
  return Database::getConnection()->nextId($existing_id);