How to update Database while checking checkbox with jquery?

Question

I am trying to update a value in DB while checking checkbox (1 or 0) with jquerys $.post or $.ajax. I would really appreciate some help. Here is my code:

HTML

<div class="onoffswitch">
     <?php
    $yesno = (bool)$baner['noti'];
    $checked = ($yesno) ? 'checked="checked"' : '';  
     ?>
   <input type="checkbox" name="onoffswitch" class="onoffswitch-checkbox" value="1" id="myonoffswitch" <?php echo $checked; ?>>
   <label class="onoffswitch-label" for="myonoffswitch"></label>
</div>

jQuery

$(function(){
    $("#myonoffswitch").click(function(){
        $.post("notification.php");
        })
    });

notification.php

connections stuffs...

$yesno = ( isset($_POST['onoffswitch']) ) ? 1 : 0;
$sql = "UPDATE baner SET noti='$yesno'";

What seems to go wrong? It doesn't appear that you're sending any data with your post request. You might find the documentation for post() helpful, especially the examples. — showdev
– showdev, Commented Mar 21, 2016 at 19:46

Steve Danner · Accepted Answer · 2016-03-21 20:37:10Z

3

You almost have it. you just need to read your checkbox state and send it back with your POST request.

$(function(){
    $("#myonoffswitch").click(function(){
        var isOn = $("#myonoffswitch").prop("checked");
        $.post("notification.php", { 'onoffswitch': isOn }, function (result) {
            //handle success here
        });
    });

edited Mar 21, 2016 at 20:37

answered Mar 21, 2016 at 19:49

Steve Danner

22.2k7 gold badges45 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mALEFACTOr Over a year ago

Thank you for your replay. I am getting error on this line: var isOn $("#myonoffswitch").prop("checked");

mALEFACTOr Over a year ago

I think there is missing an equal sign. But it wont work for me with or without. Any Idea? When I am changing manually to 0 it change the first time when I click to 1, but It wont go back to 0.

Chirag Jain · Accepted Answer · 2019-05-17 22:06:43Z

1

Try this with $.ajax. It is used widely for update data without redirect page.

$("#myonoffswitch").click(function(){
    $.ajax({
       var onoffswitch=$('#myonoffswitch').val();
       type: "POST",
       url: "notification.php", //Relative or absolute path to notification.php file
       data: {onoffswitch: onoffswitch},
       success: function(response) {
                content.html(response);
       }
    });  

});

notification.php

connections stuff...

$yesno = ( isset($_POST['onoffswitch']) ) ? 1 : 0;
$sql = "UPDATE baner SET noti='$yesno'";

edited May 17, 2019 at 22:06

Chirag Jain

1,3971 gold badge11 silver badges27 bronze badges

answered Mar 21, 2016 at 20:06

Tony

2041 silver badge4 bronze badges

Collectives™ on Stack Overflow

How to update Database while checking checkbox with jquery?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related