MDB_Common::executeQuery() (Previous)

(Next) MDB_Common::fetchAll()

View this page in	Last updated: Mon, 02 Jul 2007
English \| Dutch \| French \| German \| Hungarian \| Japanese \| Polish \| Russian \| Spanish \| Plain HTML

MDB_Common::executeMultiple()

MDB_Common::executeMultiple() -- repeated execution of a prepared SQL statment

Referentiesamenvatting

require_once 'MDB.php';

mixed executeMultiple (resource $stmt, array [$types = NULL], array [$params = array()], array [$param_types = NULL], array $data)

Beschrijving

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

Parameter

resource $stmt: query handle from prepareQuery()
array $types: if supplied, the types of the columns in the result set will be set for fetching
array $params: if supplied, prepareQuery()/ executeQuery() will be used with this array as execute parameters
array $param_types: if supplied, the values in $param will automatically set to the passed datatypes
array array $data: a numeric array containing the data to insert into the query

Return waarde

mixed - a resource id/MDB_OK or a MDB_Error, if fail

Throws

Tabel 35-1. Mogelijke PEAR_Error waarden

Error code	Error message	Reason	Solution
`MDB_ERROR_INVALID`	`NULL`	SQL statment handle is not valid.	Check correct processing of the SQL statment with prepareQuery() . Note that executeMultiple() requires a handle to the statement returned by prepareQuery() , not the statment itself.
`MDB_ERROR_NEED_MORE_DATA`	`NULL`	To less data for filling the prepared SQL statment.	Check the number of wild cards given in the SQL statment for prepareQuery() . Check the count of entries in the array for `$data`. The count of entries have to be equal to the number of wild cards.
`MDB_ERROR_NO_DB_SELECTED`	`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

Deze functie kan niet statisch worden aangeroepen.

Waarschuwing

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.

Zie

prepareQuery() , executeQuery()

MDB_Common::executeQuery() (Previous)

(Next) MDB_Common::fetchAll()

Download Documentation	Last updated: Mon, 02 Jul 2007
Do you think that something on this page is wrong? Please file a bug report or add a note.
User Notes:
There are no user contributed notes for this page.