multiple insert

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...


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)

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.