Automatically passes the information in $data (a multi-dimensional array) to execute(), which then runs the SQL statment you submitted to prepare().
query handle from prepare()
a numeric array containing the data to insert into the query
mixed - a new DB_result object for queries that return results (such as SELECT queries), DB_OK for queries that manipulate data (such as INSERT queries) or a DB_Error object on failure
Table 26-1. Possible PEAR_Error values
Error code | Error message | Reason | Solution |
---|---|---|---|
DB_ERROR_INVALID | invalid | 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 | mismatch | 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 | no database selected | 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. |
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. |
Example 26-1. Using executeMultiple()
|