Main (PHP)

Home Forums PHP News PHP Tutorials Articles PHP Code Snippets Contact Us Sysadmin Resources Books Template Shop

3rd Party Streams

SlashDot PHPDeveloper.org PHP.Net

Resources

PHP Manual MySQL Manual Smarty Manual PEAR Manual PHP-GTK Manual Symfony Manual

Code Snippets

Authentication Database Graphics HTTP Miscellaneous Time/Date

Affiliates

Scripts TutorialMan TutorialGuide CodingForums.com PHP Scripts Cheap Web Hosting Affordable Web Hosting Dreamweaver Templates

DB_common::nextId()

PEAR Manual
Prev		Next

DB_common::nextId()

DB_common::nextId() -- Returns the next number from a sequence

Synopsis

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

Description

Returns the next available number from a sequence. The sequence is automatically incremented each time this method is called.

See "Intro - Sequences" for a more complete discusion.

Parameter

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

Return value

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

Throws

Table 26-1. Possible PEAR_Error values

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

Note

This function can not be called statically.

Warning

When using PEAR DB's sequence methods, we strongly advise using these methods for all procedures, including the creation of the sequences. Do not use PEAR DB's methods to access sequences that were created directly in the DBMS. See the warning on the "Intro - Sequences" page complete information.

Example

Example 26-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')");
?>

See

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

Prev	Home	Next
DB_common::limitQuery()	Up	DB_common::prepare()

Print this page

Top Sponsor

$Symantec\'s Norton SystemWorks 2006$