How to insert data to the fields with name containing space. eg :
$data = array(
"First Name" => "Bob",
"Email ID" => "[email protected]"
);
$this->db->insert("table_name", $data);
Insert batch is also not working.
$data = array(
array(
"First Name" => "Bob",
"Email ID" => "[email protected]"
),
array(
"First Name" => "Joe",
"Email ID" => "[email protected]"
)
);
$this->db->insert_batch("table_name", $data);
Advertisement
Answer
Check the following code. Which worked for me. use $db->set method
foreach($data as $key=>$val)
{
$this->db->set($key, $val);
}
$this->db->insert('table_name');
