在codeigniter中插入多个表和行

ymzxtsji  于 2022-12-06  发布在  其他
关注(0)|答案(1)|浏览(119)

我尝试将数据插入到单个表单中的多个表和多个行中,我有两个表pms_service_feepms_service_fee_detail,此时当用户提交表单时,数据将进入这两个表。
我的模型
第一个

u1ehiz5o

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);

相关问题