MDB_Common::executeMultiple()

MDB_Common::executeMultiple()

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

Description

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 value

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

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.

© Copyright 2003-2023 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.