insert_batch多次插入在 codeigniter 中不起作用

multiple insert by insert_batch not work in codeigniter

提问人:iso ayu 提问时间:9/13/2023 最后编辑:Antonyiso ayu 更新时间:9/13/2023 访问量:14

问:

我想要多个插入,但代码不起作用。我的代码 POST 303 中有错误,请参阅其他。 当我添加数据时,只需输入表格的第一行。

我的模型 :

  public function input_data($data)
        {
            return $this->db->insert_batch($this->_table, $data);
        }

我的控制器

 $jumlah_fgwt_shrinkage = count((array)$this->input->post('nama_shrinkage'));

 $data_fgwt_shrinkage = [];

        for ($i=0; $i < $jumlah_fgwt_shrinkage ; $i++){
            array_push($data_fgwt_shrinkage,['nama_shrinkage' => $this->input->post('nama_shrinkage_hidden')[$i]]);
            $data_fgwt_shrinkage[$i]['reportno'] = $this->input->post('reportno');
            $data_fgwt_shrinkage[$i]['before_wash'] = $this->input->post('before_wash_hidden')[$i];
            $data_fgwt_shrinkage[$i]['after_wash1'] = $this->input->post('after_wash1_hidden')[$i];
            $data_fgwt_shrinkage[$i]['actual1'] = $this->input->post('actual1_hidden')[$i];
            $data_fgwt_shrinkage[$i]['after_wash3'] = $this->input->post('after_wash3_hidden')[$i];
            $data_fgwt_shrinkage[$i]['actual3'] = $this->input->post('actual3_hidden')[$i];
            $data_fgwt_shrinkage[$i]['after_wash15'] = $this->input->post('after_wash15_hidden')[$i];
            $data_fgwt_shrinkage[$i]['actual15'] = $this->input->post('actual15_hidden')[$i];
            $data_fgwt_shrinkage[$i]['c_shrinkage'] = $this->input->post('c_shrinkage_hidden')[$i];
                
        }

我没有尝试过任何代码。

请帮帮我!谢谢

php codeigniter bulkinsert

评论

1赞 Prerak Sola 9/13/2023
这个问题与.javascript
0赞 TropicsCold 12/15/2023
描述不清楚。

答:

0赞 Thành Phong 12/15/2023 #1

你是这个意思吗?

<!DOCTYPE html>
<html>
<body>

<table id="resultTable" style="width:100%">
  <tr>
    <th>Test Result</th>
    <th>Status</th>
  </tr>
  <tr>
    <td>5</td>
    <td class="status">pass</td>
  </tr>
  <tr>
    <td>20</td>
    <td class="status">fail</td>
  </tr>
  <tr>
    <td>5</td>
    <td class="status">fail</td>
  </tr>
  <tr>
    <td>12</td>
    <td class="status">pass</td>
  </tr>
</table>

<script>
let table = document.getElementById("resultTable");
let status_td = table.querySelectorAll("td.status");
let p_counter = 0
let f_counter = 0

for (let i = 0; i < status_td.length; i++) {
  v = status_td[i].innerText
  if(v === 'pass')
  { p_counter += 1}
  else {f_counter += 1}
}

console.log(p_counter)
console.log(f_counter)
</script>

</body>
</html>