ansaurus

Question

How to update a mysql field when a checkbox status changes? using jquery (ajax), php and mysql

Answer 1

+1 A:

The following code will add an event handler to the checkbox with id #checkboxId. The handler will either call test.php?checked=0 or checked=1, depending on the current checkbox status (unchecked/checked)

edit: here you have a full blown example for the client side. from php, you have to echo the message ids as the checkboxes value. this is then returned to server as param msgId. Now supporting multiple checkboxes with class filtering. You can change the class and parameter names, of course.

<html>
<head>
<title>Checkbox test</title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>

</head>
<body>

<input type="checkbox" class="messageActivated" value="msg0">
<input type="checkbox" class="messageActivated" value="msg1">
<input type="checkbox" class="messageActivated" value="msg2">

</body>

<script type="text/javascript">
$(".messageActivated").bind('click', function() { 
    if($(this).attr('checked'))
    {
        $.get("store.php", { checked: 1, msgId: $(this).attr('value') } );
    }
    else
    {
        $.get("store.php", { checked: 0, msgId: $(this).attr('value') } );
    }
});
</script>
</html>

henchman 2010-03-03 00:44:04

Thanks henchman.Just a few doubts... With that code, how can I pass the message_id to the test.php file?And other doubt... how do I call that function on this html part<input type="checkbox" name="checkboxId" value="checkboxId">?

Metraton 2010-03-03 00:51:21

the function is called automatically, because by usind "$(".messageActivated").bind('click', ", you add an event handler to each checkbox.Problem with passing the message id has been solved in the current version... somebody doesn't like me ;((

henchman 2010-03-03 01:19:28

Answer 2

A:

Hi again Guys, thanks for your support.

Henchman, I think you're approach it's not going to work in this particular example because I don't have different names for the checkboxes... because de table is builted from a "while" cicle of a query made to the database...

Piemesons, I tried you're code, with a few changes, here's what I did (it's still not working...)...

So, on the checkbox I have:

Then, on the Jquery side I have:

<script type="text/javascript">
    function my_function()
    {
        var messagem_id = "<?php echo $messagem_id; ?>";
        var lida = "<?php echo $lida; ?>";
        $.post("trata_mensagem_lida", {
            mensagem: mensagem_id,
            estado: lida,
        },
                function(response){
                    alert(response);
            });
    }

</script>

The "messagem_id" and "lida" are set before the table is formed, after the query is made to the database. And i assume that in the "arguments" part of the function i can put more than one argument. Then I really don't understand what the "function(response)" does... Can you enlight me on this?

On the PHP side, I only have this for now:

$mensagem = $_POST['mensagem']; $estado = $_POST['estado']; echo $mensagem; echo $estado;

Because I just want to check if the values get there... cause if they do, thatn it's easy to update...

How can I debug and get to show on the main page some alert message with the "echo's" text?

Metraton 2010-03-03 01:48:55

anyone can figure out what i'm doing wrong here?

Metraton 2010-03-03 12:03:59

edit ur question .. dont post in the answer section...

piemesons 2010-03-04 07:29:45

ansaurus

tags:

views:

answers:

How to update a mysql field when a checkbox status changes? using jquery (ajax), php and mysql

related questions