jeudi 9 novembre 2017

Insert multiple data with checkbox php with script

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