PEAR Manual
Prev		Next

DB_common::autoExecute()

DB_common::autoExecute() -- Automatically performs insert or update queries

Synopsis

DB_result autoExecute (string $table, array $fields_values [, integer $mode = DB_AUTOQUERY_INSERT [, string $where = FALSE]])

Description

autoExecute() build automatically an insert or an update sql query and call prepare() and execute() with it. The sql query is build by using autoPrepare(). To call autoExecute, you need only an assoc (key => value) where keys are fields names and values are corresponding values of these fields.

Parameter

string $table: name of the table
array $fields_values: assoc (key => value), keys are fields names, values are values of these fields
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

Return value

DB_result - a new DB_result or a DB_Error when fail

Throws

Table 21-1. Possible PEAR_Error values

Error code	Error message	Reason	Solution
`DB_ERROR_NEED_MORE_DATA`	`NULL`	Your associative array, which has to contain fields names and their values, is empty.	Check and correct your fields_values array.
`DB_ERROR_SYNTAX`	`NULL`	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`	`NULL`	No database was choosen.	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.

Note

This function can not be called statically.

See Introduction - autoPrepare and autoExecute for general using and an example.

See

prepare(), execute(), executeMultiple(), autoPrepare()

Prev	Home	Next
DB_common::affectedRows()	Up	DB_common::autoPrepare()

Who's Online
Guest Users: 4

Free Sample Chapters
	Deliver First Class Web Sites: 101 Essential Checklists Want to learn how to make your web sites usable and accessible? Want to ensure that your sites meet current best practice, without spending hours trawling through incomprehensible specifications and recommendations from dozens of different books, research papers, and web sites? Want to make sure that the sites you build are "right the first time," requiring no costly redevelopments?
More Sample Chapters

PHP General