MDB_Common::executeMultiple()

MDB_Common::executeMultiple() – repeated execution of a prepared SQL statement

Synopsis

require_once 'MDB.php';

mixed executeMultiple ( resource $stmt , array $types = null , array $params = array() , array $param_types = null , array $data )

Description

executeMultiple() joins the prepared SQL statement 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 value

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

Throws

Possible PEAR_Error values
Error code Error message Reason Solution
MDB_ERROR_INVALID NULL SQL statement handle is not valid. Check correct processing of the SQL statement with prepareQuery() . Note that executeMultiple() requires a handle to the statement returned by prepareQuery() , not the statement itself.
MDB_ERROR_NEED_MORE_DATA NULL To less data for filling the prepared SQL statement. Check the number of wild cards given in the SQL statement 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 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. In the most cases a misformed SQL statement. Ie. using LIMIT in a SQL-Statement for an Oracle database.

Note

This function can not be called statically.

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.