Insert data from array in database

[eluser]zelenkooo[/eluser]

Code:

Array
(
    [0] => Person Object
        (
            [name] => George
            [age] => 30            
        )

    [1] => Person Object
        (
            [name] => Mark
            [age] => 25
          
        )
)

I have table in databese with columns name and age, so they are same as in Person object
Now i would just like to insert all data from my array ( $arrayOfPersons for example )
to my table in database. I can use foreach and insert one object at a time, but what if i have 200 objects ?? or more ? That could be slow , is there any quicker way to insert whole thing ?

[eluser]Oscar Dias[/eluser]
You can use $this->db->insert_batch();

Code:

$data = array(
   array(
      'title' => 'My title' ,
      'name' => 'My Name' ,
      'date' => 'My date'
   ),
   array(
      'title' => 'Another title' ,
      'name' => 'Another Name' ,
      'date' => 'Another date'
   )
);

$this->db->insert_batch('mytable', $data);

// Produces: INSERT INTO mytable (title, name, date) VALUES ('My title', 'My name', 'My date'), ('Another title', 'Another name', 'Another date')

Reference in the user guide: http://ellislab.com/codeigniter/user-gui...tml#insert