1. drupal
    1. 5 database.mysql.inc
    2. 5 database.mysqli.inc
    3. 5 database.pgsql.inc
    4. 8
    5. 7
5 db_next_id($name)
8 – 7 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 functions call db_next_id()

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


includes/database/database.inc, line 2622

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