Automatically prepares and executes INSERT or
UPDATE queries.
This method builds a SQL statement using
autoPrepare() and then executes
the statement using
execute() with it.
Parameter
string
$table
name of the table
array
$fields_values
assoc (key => value), keys are fields names,
values are values of these fields
Values are automatically escaped and quoted according
to the current DBMS's requirements.
integer
$mode
type of query to make
(DB_AUTOQUERY_INSERT
or DB_AUTOQUERY_UPDATE)
string
$where
a string to be used in the WHERE clause.
This is only used when $mode is
DB_AUTOQUERY_UPDATE.
The string is put directly into the query, so you must
escape and quote literals according to the DBMS's standards.
Return value
integer - DB_OK on success
or a DB_Error object on failure
Check the database related section of
PHP-Manual
to detect the reason for this error.
Note
This function can not be called
statically.
Warning
The values passed in $data must be literals.
Do not submit SQL functions (for example CURDATE()).
SQL functions that should be performed at execution time need
to be put in the prepared statement.
<?php
// Once you have a valid DB object named $db...
$table_name = 'user';
$fields_values = array(
'country' => 'France',
);
$res = $db->autoExecute($table_name, $fields_values,
DB_AUTOQUERY_UPDATE, "country = 'Japan'");
if (PEAR::isError($res)) {
die($res->getMessage());
}
?>