CodeIgniter Forums

Full Version: multiple insert
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]zawaruddin[/eluser]
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...

thanks

El Forum

[eluser]Atharva[/eluser]
You need a loop,something like
Code:
for($i=0;$i<3;$i++){
$insert = array(‘name’ =>  $data['name'][$i], ‘email’ => $data['email'][$i], ‘url’ => $data['url'][$i]);
$str = $this->db->insert_string(‘table_name’, $insert);
}//for

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