- Beranda
- Komunitas
- Tech
- Website, Webmaster, Webdeveloper
Save Multiple checkbox codeigniter
![affuadimatera](https://s.kaskus.id/user/avatar/2017/05/26/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
TS
affuadimatera
Save Multiple checkbox codeigniter
Halo mastah mastah, maaf masih newbie, mohon bantuannya..
saya mau save data dari database dengan menggunakan checkbox di codeigniter..
ini CONTROLLER NYA :
public function save4()
{
$desc['no_perms'] = $this->input->post('no_perms');
$desc['uraian_perms'] = $this->input->post('uraian_perms');
$desc['keterangan'] = $this->input->post('keterangan');
$desc['pilih'] = $this->input->post('pilih');
$desc['isu_id'] = $this->input->post('isu_id');
if($_POST)
{
$action = $this->input->post('act');
$json["check_valid"] = 'valid';
if($action == 'add'){
for($ii=0; $ii< count($desc['pilih']); $ii++){
$data['isu_id'] = $desc['isu_id'];
$data['no_perms'] = $desc['no_perms'][$ii];
$data['uraian_perms'] = $desc['uraian_perms'][$ii];
$data['keterangan'] = $desc['keterangan'][$ii];
$data['pilih'] = $desc['pilih'][$ii];
//$this->isu_model->save4($data);
//}
//redirect('admin/isu/isu/list_rincian/'.$data['isu_id']);
if($data['pilih'] == 1){$this->isu_model->save4($data);}
}
redirect('admin/isu/isu/list_rincian/'.$data['isu_id']);
}
if($action == 'edit'){
$this->isu_model->edit($data);
$this->session->set_flashdata("msg", "<div class=\"col-md-12\"><div class=\"alert alert-success\" id=\"alert\">Data Berhasil Di Simpan !!</div></div>");
redirect('admin/isu/isu');
}
}
echo json_encode($json);
exit();
}
INI MODELNYA :
public function save4($data)
{
$aColumns = array(
'isu_id' =>$data['isu_id'],
//'perms_detail_id' =>$data['perms_detail_id'],
'no_perms' =>$data['no_perms'],
'uraian_perms' =>$data['uraian_perms'],
'keterangan' =>$data['keterangan'],
//'perms_detail_id' =>$data['perms_detail_id'],
//'no_perms' =>$data['no_perms'],
//'uraian_perms' =>$data['uraian_perms'],
//'keterangan' =>$data['keterangan'],
);
$this->db->trans_begin();
$this->db->insert('isu_rincian', $aColumns);
if ($this->db->trans_status() === FALSE)
{
$this->db->trans_rollback();
}
else
{
$this->db->trans_commit();
}
}
INI VIEW NYA :
<form action="<?php echo base_url(); ?>index.php/admin/isu/isu/save4/">
<table id="datatable" class="table table-striped table-bordered">
<thead>
<tr style="background-color: #80931A;color: #ffffff">
<th>Ceklis</th>
<th data-hide="phone">No</th>
<th>No Perms</th>
<th>Uraian Permasalahan</th>
<th>Keterangan </th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if ($perms)
{
$bidang="";
$no = 1;
foreach($perms as $u){
?>
<tr class="odd gradeX">
<td scope="row" width="1%" style="text-align: center;">
<input type="checkbox" name="pilih[]" id="pilih" value="1" class="flat" />
</td>
<td style="width:50px"><?php echo $no++;?></td>
<td><?php echo $u->no_perms ;?></td>
<td width="30%"><?php echo $u->uraian_perms ;?></td>
<td><?php echo $u->keterangan ;?></td>
<td style="width:110px">
<a title='Ubah Data Diri' class="btn btn-warning btn-xs">perms_id;?>"><i class="fa fa-pencil"></i></a>
<a title='Hapus' class="btn btn-danger btn-xs">perms_id;?>"><i class="fa fa-remove"></i></a>
</td>
</tr>
<!-- <input type="hidden" name="perms_detail_id" id="perms_detail_id" value="<?php echo $u->perms_detail_id ;?>"/>-->
<?php }}?>
</tbody>
</table>
<div class="form-group">
<div class="col-md-6 col-md-offset-1">
<input type="hidden" name="act" id="act" value="add" />
<input type="hidden" name="isu_id" id="isu_id" value="1" />
<button id="send" type="submit" class="btn btn-success">SIMPAN</button>
</div>
</div>
Tapi setelah saya coba save, ada error seperti ini
Error Number: 22018/245
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Conversion failed when converting the varchar value '
MOHON BANTUANNYA MASTAH. TKS
![Save Multiple checkbox codeigniter](https://s.kaskus.id/images/2018/11/05/9760802_20181105125348.PNG)
fgdfg
![Save Multiple checkbox codeigniter](https://s.kaskus.id/images/2018/11/05/9760802_20181105125352.PNG)
saya mau save data dari database dengan menggunakan checkbox di codeigniter..
ini CONTROLLER NYA :
public function save4()
{
$desc['no_perms'] = $this->input->post('no_perms');
$desc['uraian_perms'] = $this->input->post('uraian_perms');
$desc['keterangan'] = $this->input->post('keterangan');
$desc['pilih'] = $this->input->post('pilih');
$desc['isu_id'] = $this->input->post('isu_id');
if($_POST)
{
$action = $this->input->post('act');
$json["check_valid"] = 'valid';
if($action == 'add'){
for($ii=0; $ii< count($desc['pilih']); $ii++){
$data['isu_id'] = $desc['isu_id'];
$data['no_perms'] = $desc['no_perms'][$ii];
$data['uraian_perms'] = $desc['uraian_perms'][$ii];
$data['keterangan'] = $desc['keterangan'][$ii];
$data['pilih'] = $desc['pilih'][$ii];
//$this->isu_model->save4($data);
//}
//redirect('admin/isu/isu/list_rincian/'.$data['isu_id']);
if($data['pilih'] == 1){$this->isu_model->save4($data);}
}
redirect('admin/isu/isu/list_rincian/'.$data['isu_id']);
}
if($action == 'edit'){
$this->isu_model->edit($data);
$this->session->set_flashdata("msg", "<div class=\"col-md-12\"><div class=\"alert alert-success\" id=\"alert\">Data Berhasil Di Simpan !!</div></div>");
redirect('admin/isu/isu');
}
}
echo json_encode($json);
exit();
}
INI MODELNYA :
public function save4($data)
{
$aColumns = array(
'isu_id' =>$data['isu_id'],
//'perms_detail_id' =>$data['perms_detail_id'],
'no_perms' =>$data['no_perms'],
'uraian_perms' =>$data['uraian_perms'],
'keterangan' =>$data['keterangan'],
//'perms_detail_id' =>$data['perms_detail_id'],
//'no_perms' =>$data['no_perms'],
//'uraian_perms' =>$data['uraian_perms'],
//'keterangan' =>$data['keterangan'],
);
$this->db->trans_begin();
$this->db->insert('isu_rincian', $aColumns);
if ($this->db->trans_status() === FALSE)
{
$this->db->trans_rollback();
}
else
{
$this->db->trans_commit();
}
}
INI VIEW NYA :
<form action="<?php echo base_url(); ?>index.php/admin/isu/isu/save4/">
<table id="datatable" class="table table-striped table-bordered">
<thead>
<tr style="background-color: #80931A;color: #ffffff">
<th>Ceklis</th>
<th data-hide="phone">No</th>
<th>No Perms</th>
<th>Uraian Permasalahan</th>
<th>Keterangan </th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if ($perms)
{
$bidang="";
$no = 1;
foreach($perms as $u){
?>
<tr class="odd gradeX">
<td scope="row" width="1%" style="text-align: center;">
<input type="checkbox" name="pilih[]" id="pilih" value="1" class="flat" />
</td>
<td style="width:50px"><?php echo $no++;?></td>
<td><?php echo $u->no_perms ;?></td>
<td width="30%"><?php echo $u->uraian_perms ;?></td>
<td><?php echo $u->keterangan ;?></td>
<td style="width:110px">
<a title='Ubah Data Diri' class="btn btn-warning btn-xs">perms_id;?>"><i class="fa fa-pencil"></i></a>
<a title='Hapus' class="btn btn-danger btn-xs">perms_id;?>"><i class="fa fa-remove"></i></a>
</td>
</tr>
<!-- <input type="hidden" name="perms_detail_id" id="perms_detail_id" value="<?php echo $u->perms_detail_id ;?>"/>-->
<?php }}?>
</tbody>
</table>
<div class="form-group">
<div class="col-md-6 col-md-offset-1">
<input type="hidden" name="act" id="act" value="add" />
<input type="hidden" name="isu_id" id="isu_id" value="1" />
<button id="send" type="submit" class="btn btn-success">SIMPAN</button>
</div>
</div>
Tapi setelah saya coba save, ada error seperti ini
Error Number: 22018/245
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Conversion failed when converting the varchar value '
MOHON BANTUANNYA MASTAH. TKS
fgdfg
0
5.6K
0
![Guest](https://s.kaskus.id/user/avatar/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
Komentar yang asik ya
![Guest](https://s.kaskus.id/user/avatar/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
Komentar yang asik ya
Komunitas Pilihan