php - 插入具有 1 个字段的多行 codeigniter

Question

我有 View 提问者，我想插入多行(jawaban 和 soal)，见下文

我的观点

<table>
    <tr>
        <td>1</td>
        <td><input type="hidden" value="1" name="no_soal[]">apakah anda sehat</td>
        <td><input type="checkbox" value="-5" name="jawaban[]"></td>
        <td><input type="checkbox" value="-3" name="jawaban[]"></td>
        <td><input type="checkbox" value="-1" name="jawaban[]"></td>
        <td><input type="checkbox" value="0" name="jawaban[]"></td>
        <td><input type="checkbox" value="1" name="jawaban[]"></td>
        <td><input type="checkbox" value="3" name="jawaban[]"></td>
        <td><input type="checkbox" value="5" name="jawaban[]"></td>
    </tr>
    <tr>
        <td>10</td>
        <td><input type="hidden" value="2" name="no_soal[]">apakah anda rajin mandi</td>
        <td><input type="checkbox" value="-5" name="jawaban[]"></td>
        <td><input type="checkbox" value="-3" name="jawaban[]"></td>
        <td><input type="checkbox" value="-1" name="jawaban[]"></td>
        <td><input type="checkbox" value="0" name="jawaban[]"></td>
        <td><input type="checkbox" value="1" name="jawaban[]"></td>
        <td><input type="checkbox" value="3" name="jawaban[]"></td>
        <td><input type="checkbox" value="5" name="jawaban[]"></td>
    </tr>
</table>
<input type="submit" class="submit btn btn-success" value="Submit"/>

我的 Controller

public function add_soal4()
{
    $id= $this->session->userdata('id');
    $userid= $this->session->userdata('id');
    $data = array();
    if ($_POST)
    {
        $i = 0;
        $no_soal = $this->input->post("no_soal");
        $jawaban = $this->input->post("jawaban");
        for ($i = 0; $i < count($this->input->post('id')); $i++)
        {
            $data[] = array(
                'id' => $id,
                'userid' => $userid,
                'no_soal' => $no_soal[$i],
                'jawaban' => $jawaban[$i]
            );
        }
        $this->db->insert_batch('data_jawaban', $data);
    }
}

现在我只能插入 1 条记录，我需要将所有选定的字段作为多个值插入数据库

Answer 1

您将使用add_soal4进行php提交和ajax调用，因此我们应该在add_soal4函数中进行一些小修改

在 Controller 中 add_soal4()

public function add_soal4(){
    $id = $this->session->userdata('id');
    $userid = $this->session->userdata('id');        
    if($this->input->post() && !empty($id) && !empty($userid)){         
        $no_soal_list = $this->input->post("no_soal");
        $jawaban_list = $this->input->post("jawaban");
        if($jawaban_list && array_filter($jawaban_list)){
            $answer_list = [];
            foreach($jawaban_list as $no_soal => $jawaban_row){
                foreach($jawaban_row as $jawaban){
                    $answer_list[] = compact('id','userid','no_soal','jawaban');
                }                    
            }
            if(array_filter($answer_list)){
                $this->db->delete('data_jawaban', compact('id','userid'));
                $this->db->insert_batch('data_jawaban', $answer_list);
                echo ($this->db->trans_status()) ? 'Updated' : 'Failed';
            }
        }
    }
    if(!$this->input->is_ajax_request()){
        // if you have any $this->load->view() file, call it here, dont call the view files outside the loop
    }
}

将此代码添加到您的 View 文件中

<script type="text/javascript">
$(function(){
    var autoinsert = setInterval(autosave, 10000); // 10 seconds
    $('form').submit(function(e){
        e.preventDefault();
        clearInterval(autoinsert);
        e.target.submit();
    });
});
function autosave(){
    $.ajax({
        type: 'POST',
        url: '<?= base_url('online/add_soal4'); ?>',
        data: $('form').serialize(),
        cache: false,
        dataType: 'html',
        success: function(data){
            if(data){
                console.log($.parseHTML(data)[0].textContent);
            }            
        },
        error: function(error){
            console.log(error);
        }
    });
}
</script>