I tried to serialize rather to push the elements value but still I get the array with inserting each value 9 times in database. please anyone to help me figure out my problem this is what I am trying to
The HTML:
<form name="chkl" id="chkl" method="post">
<input type="checkbox" class="get_value" name="chk1[ ]" value="<?php echo $rows['ID'];?>"> <?php echo $rows['DESCRIPTION'];?></input><br>
<input type="submit" name="Submit" id="chk1" value="Submit">
JS:
<script>
$('#chk1').click(function(){
$('input[type=checkbox]').each( function() {
$.post('fee_checked_save.php', $( ".get_value" ).serialize(), function(data){
if(data == 1){
$('#result').html(data);
}
});
});
});
</script>
PHP:
<?php
$checkbox1 = $_POST['chk1'];
if(isset($_POST['chk1']))
{
for ($i=0; $i<count ($checkbox1);$i++) {
$query = "INSERT INTO fee_checked(FEE_ID) VALUES ('".$checkbox1[$i]. "')";
$result = mysqli_query($conn, $query);
}
echo "Record is inserted";
}
?>
Any help would be greatly appreciated. Thanks ahead of time!
Aucun commentaire:
Enregistrer un commentaire