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

DB_common::autoPrepare()

DB_common::autoPrepare() -- Prepares an INSERT or UPDATE statement based on variables you supply

Synopsis

resource autoPrepare (string $table, array $table_fields, integer $mode = DB_AUTOQUERY_INSERT [, string $where = FALSE])

Описание

Automatically builds an INSERT or UPDATE SQL statement so it can later be used by execute() or executeMultiple().

Параметр

string $table: name of the table
array $table_fields: ordered array containing the fields names
integer $mode: type of query to make (DB_AUTOQUERY_INSERT or DB_AUTOQUERY_UPDATE)
string $where: in case of update queries, this string will be put after the WHERE statement

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

resource - resource handle for the query or a DB_Error object on failure

Throws

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

Error code	Error message	Reason	Solution
`DB_ERROR_NEED_MORE_DATA`	insufficient data supplied	The ordered array, which has to contain fields names, is empty.	Check and correct your fields names array.
`DB_ERROR_SYNTAX`	syntax error	You use an unknown mode.	Available modes are only `DB_AUTOQUERY_INSERT` for INSERT queries or `DB_AUTOQUERY_UPDATE` for UPDATE queries.
`DB_ERROR_NODBSELECTED`	no database selected	No database was chosen.	Check the DSN in connect().
every other error code		Database specific error	Check the database related section of PHP-Manual to detect the reason for this error.

Заметка

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

Пример

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

<?php
// Once you have a valid DB object named $db...
$table_name   = 'user';
$table_fields = array('name', 'country');
$table_values = array('Bob', 'USA');

$sth = $db->autoPrepare($table_name, $table_fields,
                        DB_AUTOQUERY_UPDATE, 'id = 1');

if (DB::isError($sth)) {
    die($sth->getMessage());
}

$res =& $db->execute($sth, $table_values);

if (DB::isError($res)) {
    die($res->getMessage());
}
?>

См. также

"Intro - Prepare & Execute", "Intro - autoPrepare & autoExecute", prepare(), execute(), executeMultiple(), autoExecute()

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

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