when insert multiple data, value of checkbox is not appear on the second data but accumulate on the first data.
<tr>
<td><!-- <td><input name="hardware_input[0]" class="form-control" /> -->
<input type="text" id="noHidden" name="noHidden[]" value="1" hidden>
<input type="text" id="namabarang" name="namabarang[]" ><br/><br/><br/>
<input name="checkstatus[]" type="checkbox" value="1" /> Status Selesai
</td>
<td>
<input type="text" id="merk" name="merk[]" >
</td>
<td>
<input type="text" id="type" name="type[]" >
</td>
<td>
<input type="text" id="jumlah" name="jumlah[]" >
</td>
<td>
<input type="text" id="ket" name="ket[]" >
</td>
<td>
<input name="check_mohon1[]" type="checkbox" value="1" /> Diberikan suku cadang <br/>
<input name="check_mohon2[]" type="checkbox" value="1" /> Pengadaan baru <br/>
<input name="check_mohon3[]" type="checkbox" value="1" /> Diperbaiki ke pemasok jasa perbaikan <br/>
</td>
<td></td>
</tr>
<tr id="aksi">
<td colspan="5"></td>
<td colspan="2" class="text-center">
<button type="button" class="btn btn-sm green" onclick="tambahbaris()"><i class=" glyphicon glyphicon-plus"></i>Tambah Data</button>
</td>
</tr>
function on script for add new row:
<script type="text/javascript" charset="utf-8">
var i=1;
var no=2;
function tambahbaris(){
if(i<15){
row =
'<tr>'+
'<td><input type="text" id="noHidden" name="noHidden[]" value="'+no+'" hidden><input type="text" id="namabarang" name="namabarang[]" ><br/><br/><br/><input name="checkstatus[]" type="checkbox" value="1"/> Status Selesai </td>'+
'<td><input type="text" id="merk" name="merk[]" ></td>'+
'<td><input type="text" id="type" name="type[]" ></td>'+
'<td><input type="text" id="jumlah" name="jumlah[]" ></td>'+
'<td><input type="text" id="ket" name="ket[]" ></td>'+
'<td><input name="check_mohon1[]" type="checkbox" value="1"/> Diberikan suku cadang <br/><input name="check_mohon2[]" type="checkbox" value="1"/> Pengadaan baru <br/><input name="check_mohon3[]" type="checkbox" value="1"/> Diperbaiki ke pemasok jasa perbaikan <br/></td>'+
'<td><button class="btn btn-sm btn-danger del"><i class="glyphicon glyphicon-trash"></i></button></td>'+
'</tr>';
$(row).insertBefore("#aksi");
i++; no++;
} else { }
}
$(".del").live('click', function(){
$(this).parent().parent().remove();
});
</script>
this is the query for insert
$namaBrg=$_POST['namabarang'];
$jml_BrgInput=count($_POST['noHidden']);
$checkstatus=$_POST['checkstatus'];
$jml_status=count($checkstatus);
$merk=$_POST['merk'];
$type=$_POST['type'];
$jumlah=$_POST['jumlah'];
$ket=$_POST['ket'];
for($x=0;$x<$jml_BrgInput;$x++){
echo "\n $jml_BrgInput";
$sql_tblSpprbluarSub = "insert into t_spprbluarsub (No_Order,Nm_Brg,Merk,Keterangan,QTT,Ket)
values ('$noorder','$namaBrg[$x]','$merk[$x]','$type[$x]','$jumlah[$x]','$ket[$x]')";
//mysql_query($sql_tblSpprbluarSub);
echo "\n $sql_tblSpprbluarSub";
}
for($y=0;$y<$jml_BrgInput;$y++){
$status=isset($_POST['checkstatus'][$y]);
$checkmohon1=isset($_POST['check_mohon1'][$y]);
$checkmohon2=isset($_POST['check_mohon2'][$y]);
$checkmohon3=isset($_POST['check_mohon3'][$y]);
$sql_tblSpprbluarSub2 = "insert into t_spprbluarsub (Statusdiberi,DibSukCad,DibBaru,Diper_Phktg)
values ('$status','$checkmohon1','$checkmohon2','$checkmohon3')";
echo "\n $sql_tblSpprbluarSub2";
}
this is the result query: result query
on the second query, checkbox there should be data but on the second query, data move to first data.
HELP!! HELP!! HELP!! HELP!!
Aucun commentaire:
Enregistrer un commentaire