jeudi 23 août 2018

How to Insert SELECT ALL values or SELECTED checkboxes values into different columns in mysql?

I want to Insert SELECT ALL values or SELECTED values into different columns in MySQL. On choosing SELECT ALL, all the values are inserting correctly in sql but on selecting some checkboxes data is not inserting in SQL data.

Jquery

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script>
$(document).ready(function() {

$("#select_all").change(function(){
    var status = this.checked;
    $('.checkbox').each(function(){
        this.checked = status;
    });
});

$('.checkbox').change(function(){
    if(this.checked == false){
        $("#select_all")[0].checked = false;
}

if ($('.checkbox:checked').length == $('.checkbox').length ){ 
        $("#select_all")[0].checked = true;
}
});
});
</script>

PHP

<?php
$addbook=$_POST['addbook'];
$memdet=$_POST['memdet'];
$vbookd=$_POST['vbookd'];
$modify=$_POST['modify'];
$result=mysqli_query($db,"insert into apanel(addbook,memdet,vbookd,modify)values('$addbook','$memdet','$vbookd','$modify')");
?>

HTML

<input type="checkbox" id="select_all"/> Selecct All<br>
<input class="checkbox" type="checkbox" value="1" name="addbook" />Add Book<br>
<input class="checkbox" type="checkbox" value="1" name="memdet" />View Member Details<br>
<input class="checkbox" type="checkbox" value="1" name="vbookd" />View Book Details<br>
<input class="checkbox" type="checkbox" value="1" name="modify" />Edit/Delete<br>

I want to insert selective checkboxes also in MYSQL database. Help required




Aucun commentaire:

Enregistrer un commentaire