DB_common::executeMultiple()

Description

Automatically passes the information in $data (a multi-dimensional array) to execute(), which then runs the SQL statment you submitted to prepare().

Parameter

Return value

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

Throws

Note

This function can not be called statically.

Example

<?php
// Once you have a valid DB object named $db...
$sth = $db->prepare('INSERT INTO numbers VALUES (?, ?, ?)');

if (DB::isError($sth)) {
    die($sth->getMessage());
}

$alldata = array(array(1, 'one', 'en'),
                 array(2, 'two', 'to'),
                 array(3, 'three', 'tre'),
                 array(4, 'four', 'fire'));

$res =& $db->executeMultiple($sth, $alldata);

if (DB::isError($res)) {
    die($res->getMessage());
}
?>

See

"Intro - Prepare & Execute", "Intro - autoPrepare & autoExecute", prepare(), execute(), autoPrepare(), autoExecute()