CodeIgniter Forums
multiple insert - Printable Version

+- CodeIgniter Forums (
+-- Forum: Archived Discussions (
+--- Forum: Archived General Discussion (
+--- Thread: multiple insert (/thread-37504.html)

multiple insert - El Forum - 01-11-2011

i have read the CI user guide for insert_string. And this is the code :

$data = array('name' => $name, 'email' => $email, 'url' => $url);
$str = $this->db->insert_string('table_name', $data);

but in my case, i've data in array
$data = array('name' => array('zawaruddin','devi','farhan'),
'email' => array('[email protected]','[email protected]','[email protected]'),
'url' => array('url1','url2','url3'));

$str = $this->db->insert_string('table_name', $data);

can i insert $data in db with insert_string function??? or other insert function???
my dbms is postgre...


multiple insert - El Forum - 01-11-2011

You need a loop,something like
$insert = array(‘name’ =>  $data['name'][$i], ‘email’ => $data['email'][$i], ‘url’ => $data['url'][$i]);
$str = $this->db->insert_string(‘table_name’, $insert);

Though you should dynamically determine the value of $i (in this case taken as 3)