executeMultiple() joins the prepared SQL statment from prepare() with the given data and does the SQL query for every "row" in the $data array.

Parameter

resource $stmt: query handle from prepare()
array array $data: a numeric array containing the data to insert into the query

Return value

mixed - a new DB_result/DB_OK or a DB_Error, if fail

Throws

Table 21-1. Possible PEAR_Error values

Error code	Error message	Reason	Solution
`DB_ERROR_INVALID`	`NULL`	SQL statment handle is not valid.	Check correct processing of the SQL statment with prepare(). Note that executeMultiple() requires a handle to the statement returned by prepare(), not the statment itself.
`DB_ERROR_MISMATCH`	`NULL`	Quantity of parameters didn't match quantity of placeholders in the prepared statment.	Check that the number of placeholders in the prepare() statement passed to `$query` equals the count of entries passed to `$params`.
`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. In the most cases a misformed SQL statment. Ie. using LIMIT in a SQL-Statment for an Oracle database.

Note

This function can not be called statically.

Warning

If an error occurs during execution, the function will be stopped. Possible remaining data will be unprocessed.

See Introduction - Execute for general using and an example.

See

prepare(), execute()

Prev	Home	Next
DB_common::execute()	Up	DB_common::freePrepared()

Who's Online
Guest Users: 14

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