[fw-general] Zend DB

[Ian Warner]

Hi

Just wondered what the best methods were to do Bulk Inserts

Do I loop through the array

foreach
  insert

Or is there some other methods that I can use

I can see - anything else ?

$bugs = new Bugs();
$newRow = $bugs->createRow();

// Data are arranged in an associative array
$data = array(
    'bug_description' => '...description...',
    'bug_status'      => 'NEW'
);

// Set all the column values at once
$newRow->setFromArray($data);

// INSERT the new row to the database
$newRow->save();