PEAR Manual
Prev		Next

DB_common::autoPrepare()

DB_common::autoPrepare() -- Automatically prepare an insert or update query

Synopsis

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

Description

autoPrepare() build automatically an insert or an update sql query and call prepare()with it. The sql query is build by using an ordered array containing fields names.

Parameter

string 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

Return value

resource - resource handle for the query

Throws

Table 21-1. Possible PEAR_Error values

Error code	Error message	Reason	Solution
`DB_ERROR_NEED_MORE_DATA`	`NULL`	The ordered array, which has to contain fields names, is empty.	Check and correct your fields names 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 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.

Note

This function can not be called statically.

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

See

prepare(), execute(), executeMultiple(), autoExecute()

Prev	Home	Next
DB_common::autoExecute()	Up	DB_common::createSequence()

Who's Online
Guest Users: 6

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