- Beranda
- Komunitas
- Tech
- Website, Webmaster, Webdeveloper
Save Multiple checkbox codeigniter


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

fgdfg

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


Komentar yang asik ya


Komentar yang asik ya
Komunitas Pilihan