Extended Insert =============== Purpose: -------- The extendedInsert method allows you to create a insert query that you can insert multiple entries at once. Just like the insert method it allows for a optional IGNORE boolean Definition: ----------- :: $this->extendedInsert($strTableName, $arrFields, $params, $blnIgnore = false); * strTableName - (string) The table to query * arrFields - (array) The field names * params - (mixed) * Array - 2-dimensional array of values (must have same number of values as fields) * String - just like insert can be INSERT...SELECT statement * Object - an object that implements DBInterface interface * Collection - an object that implements IteratorAggregate interface * Object Array - just like a collection, but a primative array * blnToIgnore - (boolean) used to decide if it needs to be a INSERT IGNORE statement Returns: -------- ``Integer`` Returns the number of affected rows and sets the "insertID" of the first element Examples: --------- To insert multiple rows, you'll need to have one array with the fields that correspond to the values you're inserting (the positions of the elements is important):: $this->extendedInsert("members", ['id', 'name', 'salary'], [ [1, 'George Foreman', 100], [2, 'Curious George', 1000] ]); // INSERT INTO members (`id`,`name`,`salary`) VALUES (1, 'George Foreman', 100), (2, 'Curious George', 1000) Problems: --------- If you run into problems it is likely because you don't have an identical number of values as the number of fields.:: $this->insert('foo', ['id', 'name', 'phone'], [ [1, 'Fred Flintstone', '1'], [2, 'George Jetson'] ]); **Because the second array only has 2 elements the statement will throw** **an Exception.**