我为存储在数据库中的多个数据插入创建了一个动态表单，这里有两个表“kly\u shops”，“kly\u flex\u details”。“kly\u shops”存储了shop details。“kly\u flex\u details”存储了flex details。它是一个动态表单，用于存储车间中不同的flex details。下面给出了我正在使用的方法

$fdate=date('Y-m-d', strtotime(strtr($this->input->post('FDate'), '/', '-')));
    $tdate=date('Y-m-d', strtotime(strtr($this->input->post('TDate'), '/', '-')));
   $data=array('shop_name'=>$this->input->post('shopname'),
                 'location'=>$this->input->post('location'),
                'from_date'=>$fdate,
                'to_date'=> $tdate,
                'printing_vendor_id'=>$this->input->post('printvendor'),
                'fixing_vendor_id'=>$this->input->post('fixvendor'),
                'total_amount'=>$this->input->post('Amount'),
                'flex_count'=>$this->input->post('flexcount'));
   $this->Shop_Model->add_shops($data); 
  $insert_id= $this->db->insert_id();

    $newfdate=date('Y-m-d', strtotime(strtr($this->input->post('bindfdate'), '/', '-')));
    $newtdate=date('Y-m-d', strtotime(strtr($this->input->post('bindtdate'), '/', '-')));

    $data= array(
        'shop_id'=>$insert_id,
        'type'=>$this->input->post('type'),
        'size'=>$this->input->post('size') ,
        'name'=>$this->input->post('name'),
        'from_date'=>$newfdate,
        'to_date'=>$newtdate);
        $this->Shop_Model->add_flexes($data);
        $count=count($this->input->post('atype'));
        $type=$this->input->post('atype');
            foreach( $type as $i=>$a)
            // for($i=0; $i<$count; $i++)
            {

                $frdate=date('Y-m-d', strtotime(strtr($this->input->post('abindfdate')[$i], '/', '-')));
                $trddate= date('Y-m-d',strtotime(strtr($this->input->post('abindtdate')[$i], '/', '-')));
                $data = array(
                    'shop_id'=>$insert_id,
                    'type'=>$a,
                    'size'=>$this->input->post('asize')[$i] ,
                    'name'=>$this->input->post('aname')[$i],
                    'from_date'=> $frdate,
                    'to_date'=>$trddate
                    );

                $this->Shop_Model->add_flexes($data);

            }

插入方法是正确的，但我得到了一个数据库错误，也就是说

Error Number: 1048

Column 'shop_name' cannot be null
INSERT INTO `kly_shops` (`shop_name`, `location`, `from_date`, `to_date`, `printing_vendor_id`, `fixing_vendor_id`, `total_amount`, `flex_count`) VALUES (NULL, NULL, '1970-01-01', '1970-01-01', NULL, NULL, NULL, NULL)

Filename: D:/xampp/htdocs/branding/klth_system/database/DB_driver.php

Line Number: 691