插入批次错误代码点火器3.1。4.

Question

严重性：注意消息：数组到字符串转换文件名：数据库/DB\u查询\u生成器。php行号：1539回溯：文件：D:\xampp\htdocs\visio\application\models\projectmodel。php行：56函数：插入批处理

错误号码：1064

您的SQL语法有错误；检查与您的MariaDB服务器版本对应的手册，以了解第1行“Array”附近使用的正确语法

插入到paymentsize（）值（'8'）、（'2017-06-07'）、（'Residential'）、（'L'）、（'120'）、（'200'）、（'10000'）、（'15000'）、（'30'）、（'12000'）、（'40'）、（'1000'）、（'60'）、（'125000'）、（'10'）、（'10000'）、（'15000'）、（'20000'）、数组中

文件名：D:/xampp/htdocs/visio/system/database/DB\u驱动程序。php

电话号码：691

我的控制器是：

public function store_payment()
{
    $post = array();
        $post = $this->input->post(NULL,TRUE);
        $count=count($this->input->post('pro_id'));
        echo CI_VERSION;

        for($i = 0; $i < $count; $i++){
            $post []= array(
                'pro_id'        => $post['pro_id'][$i],
                'date_add'      => $post['date_add'][$i], 
                'category'      => $post['category'][$i], 
                'type'          => $post['type'][$i], 
                'size'          => $post['size'][$i], 
                'counts'        => $post['counts'][$i], 
                'booking'       => $post['booking'][$i], 
                'confirmation'  => $post['confirmation'][$i], 
                'confirm_days'  => $post['confirm_days'][$i], 
                'allocation'    => $post['allocation'][$i], 
                'allocate_days' => $post['allocate_days'][$i], 
                'm_installment' => $post['m_installment'][$i], 
                'month'         => $post['month'][$i], 
                'y_instalment'  => $post['y_instalment'][$i], 
                'halfyear'      => $post['halfyear'][$i], 
                'leveling'      => $post['leveling'][$i], 
                'demarcation'   => $post['demarcation'][$i], 
                'possession'    => $post['possession'][$i]
                );
        }
    $this->projects->add_payment($post);
}

我的模型是：

public function add_payment($array)
{
     // echo "<pre>";
     // print_r($array);
     // exit();
     return $this->db->insert_batch('paymentsize',$array);
     
}

我的观点是：

<tbody>
          <input type="hidden" name="pro_id[]"  value="<?= $project->pro_id; ?>" >
          <tr>
          <td width="14%">
            <div class="col-lg-10">
              <div class="form-group form-black label-floating is-empty">
                <label class="control-label" style="margin-top: -10px;">Date</label>
                  <input type="date" name="date_add[]" value="<?php echo date('Y-m-d'); ?>" class="form-control" >
                <span class="material-input"></span>
              </div>
              </div>
          </td>
           <td width="14%">
            <div class="col-lg-10">
                <div class="form-group form-black label-floating is-empty">
                  <label class="control-label">Plot Category</label>
                    <select name="category[]" class="form-control">
                      <option> </option>
                      <option>Residential</option>
                      <option>Commercial</option>
                    </select>
                  <span class="material-input"></span>
                </div>
              </div>
           </td>
           <td>

如果我使用print_r它显示所有数组元素与各自的值...但它不是插入在DB表...前进...

Answer 1

您使用$post有两个目的，请按以下代码更改控制器代码：

public function store_payment()
{
    $post = $this->input->post(NULL,TRUE);
    $count=count($this->input->post('pro_id'));
    echo CI_VERSION;

    $data = array();
    for($i = 0; $i < $count; $i++){
        $data []= array(
            'pro_id'        => $post['pro_id'][$i],
            'date_add'      => $post['date_add'][$i], 
            'category'      => $post['category'][$i], 
            'type'          => $post['type'][$i], 
            'size'          => $post['size'][$i], 
            'counts'        => $post['counts'][$i], 
            'booking'       => $post['booking'][$i], 
            'confirmation'  => $post['confirmation'][$i], 
            'confirm_days'  => $post['confirm_days'][$i], 
            'allocation'    => $post['allocation'][$i], 
            'allocate_days' => $post['allocate_days'][$i], 
            'm_installment' => $post['m_installment'][$i], 
            'month'         => $post['month'][$i], 
            'y_instalment'  => $post['y_instalment'][$i], 
            'halfyear'      => $post['halfyear'][$i], 
            'leveling'      => $post['leveling'][$i], 
            'demarcation'   => $post['demarcation'][$i], 
            'possession'    => $post['possession'][$i]
            );
    }
    $this->projects->add_payment($data);
}

Answer 2

更改您的控制器如下代码，

public function store_payment()
{
    $post = array();
        $post = $this->input->post(NULL,TRUE);
        $count=count($this->input->post('pro_id'));
        echo CI_VERSION;

        for($i = 0; $i < $count; $i++){
            $post = array(
                'pro_id'        => $post['pro_id'][$i],
                'date_add'      => $post['date_add'][$i], 
                'category'      => $post['category'][$i], 
                'type'          => $post['type'][$i], 
                'size'          => $post['size'][$i], 
                'counts'        => $post['counts'][$i], 
                'booking'       => $post['booking'][$i], 
                'confirmation'  => $post['confirmation'][$i], 
                'confirm_days'  => $post['confirm_days'][$i], 
                'allocation'    => $post['allocation'][$i], 
                'allocate_days' => $post['allocate_days'][$i], 
                'm_installment' => $post['m_installment'][$i], 
                'month'         => $post['month'][$i], 
                'y_instalment'  => $post['y_instalment'][$i], 
                'halfyear'      => $post['halfyear'][$i], 
                'leveling'      => $post['leveling'][$i], 
                'demarcation'   => $post['demarcation'][$i], 
                'possession'    => $post['possession'][$i]
                );
        }
    $this->projects->add_payment($post);
}