PEAR Справочное руководство
Пред.		След.

DB_common::nextId()

DB_common::nextId() -- Returns the next free id of a sequence

Synopsis

resource nextId (string $seq_name, boolean $onDemand = TRUE)

Описание

See "Intro - Sequences"

Параметр

string $seq_name: name of the sequence
boolean $onDemand: when TRUE the sequence is automatic created, if it not exists.

Возвращаемое значение

integer - a free id number or a DB_Error object on failure

Throws

Таблица 22-1. Возможные значения PEAR_Error

Error code	Error message	Reason	Solution
`DB_ERROR_NOT_CAPABLE`	DB backend not capable	Function is not supported by the database backend	Switch to another database system, if you really need this feature.
`DB_ERROR_NOT_LOCKED`	not locked	Locking of sequence table fails	Database specific, check documentation of your database,
`DB_ERROR_NOSUCHTABLE`	no such table	Sequence table was not found	Try to create a new sequence or if you are sure, a sequence was already create, check database integrity

Заметка

Эта функция не должна вызываться статически.

Пример

Пример 22-1. Using nextId()

<?php
// Once you have a valid DB object named $db...
$id = $db->nextId('mySequence');
if (DB::isError($id)) {
    die($id->getMessage());
}

// Use the ID in your INSERT query
$res =& $db->query("INSERT INTO myTable (id, text) VALUES ($id, 'foo')");
?>

См. также

"Intro - Sequences", createSequence(), dropSequence()

Пред.	Начало	След.
DB_common::limitQuery()	Уровень выше	DB_common::prepare()

HIVE: All information for read only. Please respect copyright!