Checkbox onChange submit form

Question

What i have is a array of items from my mySQL database and each item has a checkbox. i am trying to make it so when you click on the checkbox it will submit the information to the database for the item that got checked or unchecked. have i have it is unchecked = 1 and checked = 0. this is for where i want to display the item.

Now my issue is I can't seem to get anything to submit into my database, I don't understand jQuery enough to be able to write a function for it, so i need some help. here is what i got for my code.

if(isset($_POST['submit'])){
        foreach($_POST['id'] as $id){
            $value = (isset($_POST['location'][$id]) && $_POST['location'][$id]=="0" ? '0' : '1');
            $insert = mysql_query("UPDATE items SET location='$value' WHERE id='$id'") or die('Insert Error: '.mysql_error());
        }
    }
echo '<form id="form1" method="post"><input type="submit" name="submit" value="Submit">';
$result = mysql_query("SELECT * FROM items")
    or die("Query Failed: ".mysql_error());
    $counter = 0;
    echo '<div class="specialcontainer">';
while($row = mysql_fetch_array($result)){
    list($id, $item_info, $item_img, $price, $sale, $location) = $row;
    if($location == '0'){
        $set_checked = ' checked="checked" ';
    }else{
        $set_checked = '';
    }
    if($counter % 5==0) {
        echo '</div>';
        echo '<div class="specialcontainer">';
    }
    echo '<div class="special"><img src="../images/items/'.$item_img.'" width="130" /><br />';
    echo $item_info.'<br />';
    echo 'Reg. $'.$price.'<br />';
    echo 'Sale $'.$sale.'<br />';
    echo 'Slide Show: <input type="checkbox" id="ch" value="0" name="location['.$id.']"'.$set_checked.' /><br />';
    echo '<input type="button" value="Edit" name="edit" onclick="window.location.href=\'specials.php?action=edit&id='.$id.'\'">';
    echo '<input type="button" value="Delete" name="Delete" onclick="window.location.href=\'specials.php?action=delete&id='.$id.'\'">';
    echo '<input type="hidden" name="id[]" value='.$id.' />';
    echo '</div>';
    $counter++;
}
echo '</div>';
echo '<input type="submit" name="submit" value="Submit"></form>';

so as you can see, i do have the submit button there, but my plan is to remove it for the onChange submit. I've tried the onchange="this.form.submit();" in the checkbox parameter but it don't work properly. so i just want it to submit anytime a checkbox gets clicked on kinda thing.

Nate · Accepted Answer · 2012-04-19 20:11:43Z

1

Would an Ajax solution like this work?

$('ch').click(function() {
    //this is what goes into $_POST
    var data = 'id='+ $(this).attr('name') +'&checked=' + $(this).is(':checked');
    $.ajax({
        //This would be the url that would handle updating the MySQL Record
        url: my_mysql_handler.php,
        cache: false,
        type: 'POST',
        data: data,
        success: function(response) {
            alert(response); //or whatever you want to do with the success/fail notification
        }
    });
});

answered Apr 19, 2012 at 20:11

Nate

1,3138 silver badges12 bronze badges

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

1 Comment

GuberX Over a year ago

hmm, i gave it a try and nothing happens. I dont even know if im using the function right haha. like would this function be put in between a <script type="text/javascript"> </script>??

Tronix117 · Accepted Answer · 2012-04-19 19:22:46Z

0

You should try document.getElementById('form1').submit() in the onchange method of your checkbox

answered Apr 19, 2012 at 19:22

Tronix117

1,98514 silver badges19 bronze badges

3 Comments

GuberX Over a year ago

oh ive tried this one and many others like it, it just dont send the $_post information. like when i click on the checkbox it will reload the page but the checkbox i clicked on will not change

Tronix117 Over a year ago

Maybe the onchange method is called before changing the checkbox value. If with a submit after a check, everything works, then it is the problem. To solve it: onchange="this.checked=!this.checked;document.getElementById('form1').submit()"

GuberX Over a year ago

yeah thats what i thought was going on. i tried ur second piece of script there and now my checkboxes don't even check or uncheck anymore haha

Collectives™ on Stack Overflow

Checkbox onChange submit form

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related