update query when check the checkbox with ajax

Question

I have a checkbox. if I check or uncheck the check box then a update query should be run with Ajax call.

If checks the checkbox then 1 should be update and if uncheck then 0 should be update. But it is not working.

Checkbox is:

<input type="checkbox" id="test_done" value="<?php echo $row1['id']; ?>" <?php if(($row1['test_done'])=='1') echo "checked='checked'"; ?> data-toggle="checkbox">

In above $row1['id'] and $row1['test_done'] are columns name, which are coming from another select query.

Ajax Is:

<script type="text/javascript">
  $(document).ready(function(){
    $("#test_done").click(function(){    
    var val = $(this).val();
         if($(this).is(':checked')){
         $.ajax({ type: "POST", 
         url: "test_done.php", 
         data: {val:val,apply:'1'} 

         });
         }
         else
         {
         $.ajax({ type: "POST", 
         url: "test_done.php", 
         data: {val:val,apply:'0'} 

         });

         }
      });
   });
 </script>

test_done.php is:

include_once("connection.php");
if($_POST['apply']=='1')
{
$val = $_POST['val'];   
 mysql_query("update patient_package_details set test_done='1' where id='$val'") or die(mysql_error());
}
else
{
$val = $_POST['val'];   
mysql_query("update patient_package_details set test_done='0' where id='$val'") or die(mysql_error());
}

Don't use mysql* functions for database connectivity. These functions are deprecated in newer versions of php. Use mysqli* OR PDO. — Pankaj Makwana
– Pankaj Makwana, Commented Feb 14, 2018 at 10:22
Thank you for your reply and suggestion. But my code is not working. — vinod jaiswal
– vinod jaiswal, Commented Feb 14, 2018 at 10:26
When I click on checkbox then nothing happens. Means update query is not executing. — vinod jaiswal
– vinod jaiswal, Commented Feb 14, 2018 at 10:27

Pankaj Makwana · Accepted Answer · 2018-02-14 11:10:52Z

4

You can use change event instead of click event on checkbox. Check if checkbox is checked then send 1 otherwise 0. on php side as we are sending both values, so you will get value using post. You don't need to check value for $_POST["apply"]. I have set the value of apply variable, so only one query will work.

$("input:checkbox").on("change", function () {
    var val = $(this).val();
    var apply = $(this).is(':checked') ? 1 : 0;
    $.ajax({type: "POST",
        url: "test_done.php",
        data: {val: val, apply: apply}
    });
});

test_done.php:

include_once("connection.php");
$val = $_POST['val'];   
$apply = $_POST['apply'];   
mysql_query("update patient_package_details set test_done='$apply' where id='$val'") or die(mysql_error());

edited Feb 14, 2018 at 11:10

answered Feb 14, 2018 at 10:33

Pankaj Makwana

3,0486 gold badges33 silver badges49 bronze badges

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

4 Comments

vinod jaiswal Over a year ago

It is updating only first row. When I click on second row checkbox, then nothing happens

Pankaj Makwana Over a year ago

I have updated the answer. Use selector $("input:checkbox") instead of $("#test_done")

vinod jaiswal Over a year ago

I want to know one thing, that what will be better mysqli or PDO?

Pankaj Makwana Over a year ago

Checkout here code.tutsplus.com/tutorials/…

Collectives™ on Stack Overflow

update query when check the checkbox with ajax

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related