CI框架 数据库批量插入 insert_batch()

示例1：$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); //生成： INSERT INTO mytable (title, name, date) VALUES ('My title', 'My name', 'My date'), ('Another title', 'Another name', 'Another date')

示例2：$one_info = array();
$insert_data = array();
$one_info['role_id'] = 6;
$one_info['operator'] = 'test';
for($i = 0; $i <= 3; $i++) {
$one_info['net_id'] = $i;
$insert_data[] = $one_info;
}
if (!$this->db->insert_batch(tableA,$insert_data)) {
return 3;
}//插入的sql语句是 insert into tableA(role_id,operator,net_id) values(6,'test',0),(6,'test',1),(6,'test',2);