在数据库中将单选值多个数据codeigniter插入一行? [英] insert radio value multiple data codeigniter in database to one row?
本文介绍了在数据库中将单选值多个数据codeigniter插入一行?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个测验在线项目,我希望答案像这样保存在数据库中
I have a quiz online project i want the answer save like this in database
+-----------+-------------+---------+-------------+
| id_answer | id_student | id_kuis | answer |
+-----------+-------------+---------+-------------+
| 1 | 99999874465 | 7 | A,B,D,A,C,B |
+-----------+-------------+---------+-------------+
此测验是多项选择.因此,我该如何插入答案的数据.
this quiz is multiple choice. So how can i insert the data of answer like that.
这是我的观点
<?php echo form_open('c_kuis/addKuisAnswer',$atribut); ?>
<?php foreach($soalPG as $row){?>
<?php $jawab_array = array($row->pil_a,$row->pil_b,$row->pil_c,$row->pil_d);?>
<p><?=$row->no_soal?>.<?=$row->soal?></p>
<input type="hidden"name="id_soal<?=$row->id_soal_pg?>" value="<?=$row->id_soal_pg?>"></input>
<input type="radio" name="jawaban<?=$row->no_soal?>" value="A"> A. <?=$jawab_array[0]?></input><br>
<input type="radio" name="jawaban<?=$row->no_soal?>" value="B"> B. <?=$jawab_array[1]?></input><br>
<input type="radio" name="jawaban<?=$row->no_soal?>" value="C"> C. <?=$jawab_array[2]?></input><br>
<input type="radio" name="jawaban<?=$row->no_soal?>" value="D"> D. <?=$jawab_array[3]?></input><br>
<br><br>
<?php } ?>
<input type="hidden" name="kuis_id" value="<?php echo $kuisPG->id_ks;?>"></input>
<button class="btn btn-primary submit" id= "submit" type="submit">Submit</button>
<?php echo form_close(); ?>
</div>
这是我的控制器
public function addKuisAnswer(){
$kuis_id = $_POST['kuis_id'];
$id_user = $this->session->userdata('data_user')->no_id;
$i=1;
while(isset($_POST['jawaban'.$i]))
{
$answer = $_POST['jawaban'.$i];
}
$this->load->model('m_kuis');
$this->m_kuis->answer_PG($id_user,$kuis_id,$answer);
echo " <script>
alert('answer saved!');
history.go(-2);
</script>";
}
如何编辑控制器以输入数据,如上面的示例表所示?
How can i edit my controller to input data as the example table above?
推荐答案
我认为这可能对您有帮助
I think this may helps you
public function addKuisAnswer(){
$kuis_id = $_POST['kuis_id'];
$id_user = $this->session->userdata('data_user')->no_id;
$i=1;
while(isset($_POST['jawaban'.$i]))
{
if($i == 1)
{
$answer = $_POST['jawaban'.$i];
}
else{
$answer. =','. $_POST['jawaban'.$i];
}
$i++;
}
$this->load->model('m_kuis');
$this->m_kuis->answer_PG($id_user,$kuis_id,$answer);
echo " <script>
alert('answer saved!');
history.go(-2);
</script>";
}
我们还有另一个解决方案,使用explode
和implode
We have another solution,using explode
and implode
while(isset($_POST['jawaban'.$i]))
{
$answer_array[] = $_POST['jawaban'.$i];
$i++;
}
$answer = implode(',',$answer_array);
这篇关于在数据库中将单选值多个数据codeigniter插入一行?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文