mercredi 31 août 2016

Using Ajax to store checkbox in database

I have the following that I've found from some snippets during my searches for help however I cannot get it to work. What I am trying to accomplish is clicking a check box and it automatically populate a row in my database that I can refer to on any other page. Right now when I click the checkbox, nothing happens.

HTML

<td><input type="checkbox" name="<?php echo $brow['WorkOrder']; ?>"  value="<?php echo $brow['WorkOrder']; ?>"></td>

Ajax

     <!-- Checkbox storage -->
     <script>
     $(document).ready(function(){
        $("input[type='checkbox']").on('click', function(){
        var checked = $(this).attr('checked');
        if(checked){
            var value = $(this).val();
            $.post('functions/checkBox.php', { value:value }, function(data){
                // data = 0 - means that there was an error
                // data = 1 - means that everything is ok
                if(data == 1){
                    // Do something or do nothing :-)
                    alert('Data was saved in db!');
                }
            });
        }
        });
    });
    </script>

functions/checkBox.php

<?php
if ($_POST && isset($_POST['value'])) {

    // db connection
    include("../../db.php");

    // sanitize the value
    $value = mysql_real_escape_string($_POST['value']);

    // start the query
    $sql = "INSERT INTO TemporaryCheckBoxID (WorkOrder) VALUES ('$value')";

    // check if the query was executed
    if(mysql_query($sql)){
       // everything is Ok, the data was inserted
       print(1);    
    } else {
       // error happened
       print(0);
    }
}
?>




Aucun commentaire:

Enregistrer un commentaire