我尝试将数据插入到单个表单中的多个表和多个行中,我有两个表pms_service_fee和pms_service_fee_detail,此时当用户提交表单时,数据将进入这两个表。我的模型第一个
u1ehiz5o1#
可以使用循环将数组推入数组,如下所示。
$data = escape_array($data); $pms_data = [ 'unit_id' => $data['unit_id'], ]; if(isset($data['edit_pms_id'])) { $this->db->set($pms_data)->where('id', $data['edit_pms_id'])->update('pms_service_fee'); } else { $this->db->insert('pms_service_fee', $pms_data); } $pms_id = $this->db->insert_id(); $pms_service_fee_detail = []; / * Your Loop Here to Push the values to the array */ foreach($yourArray as $key => $value) { $pms_service_fee_detail[] = [ 'pms_id' => $pms_id, 'pms_service_fee_id' => $yourArray[$key]['pms_service_fee_id'], 'pms_service_fee_price' => $yourArray[$key]['pms_service_fee_price'], ]; } $this->db->insert_batch('pms_service_fee_detail', $pms_service_fee_detail);
1条答案
按热度按时间u1ehiz5o1#
可以使用循环将数组推入数组,如下所示。