Insert mySQL query if checkbox checked/not checked with PHP

Question

During the process of trying to develop an checkbox activated mySQL query based on the value inside a checkbox i've incurred an problem which i can't get past, I've tried the following at the moment

<input type="checkbox" name="status" onclick="updateStatus(<? echo $data['id']; ?>,this.checked)">

The Javascript/Ajax code for the function "updateStatus" is as followed

function updateStatus(id,value) {
if (window.XMLHttpRequest) {
    http = new XMLHttpRequest()
} else if (window.ActiveXObject) {
    http = new ActiveXObject("Microsoft.XMLHTTP")
} else {
    alert("Your browser does not support XMLHTTP!")
}
http.abort();
http.open("GET", "../functions/ajax.php?check=update_status&id=" + id + "&checked="+value, true);
http.onreadystatechange = function () {
     if (http.readyState == 4) {
        alert(http.responseText);
     }
 }
 http.send(null)

The PHP function inside functions/ajax.php

if(isset($check) and $check == 'update_status' and isset($_GET['id'])){
    $id = mysql_real_escape_string($_GET['id']);
    $checked= mysql_real_escape_string($_GET['checked']);
if($checked == true) {
    echo "Checked";
} elseif($checked == false) {
    echo "Not checked";
} else {
    echo "Invalid response";
}

when using this code it always returned "Checked" any idea why ?

possible duplicate of Checkbox always returning true in javascript/php — Michael Berkowski
– Michael Berkowski, Commented Jan 11, 2013 at 18:13

Suresh Kamrushi · Accepted Answer · 2013-01-11 16:22:07Z

1

try this (code tested),

<input type="checkbox" name="status" onclick="updateStatus(<? echo $data['id']; ?>,this.checked)">

You will get second parameter as true or false;

function updateStatus(id,checked) {
if (window.XMLHttpRequest) {
    http = new XMLHttpRequest()
} else if (window.ActiveXObject) {
    http = new ActiveXObject("Microsoft.XMLHTTP")
} else {
    alert("Your browser does not support XMLHTTP!")
}
http.abort();
http.open("GET", "../functions/ajax.php?check=update_status&id=" + id+"checked="+checked, true);
http.onreadystatechange = function () {
     if (http.readyState == 4) {
        alert(http.responseText);
     }
 }
 http.send(null)

You PHP will be:

if(isset($check) and $check == 'update_status' and isset($_GET['id']) AND isset($_GET['checked'])){
$id = mysql_real_escape_string($_GET['id']);
$checked= mysql_real_escape_string($_GET['checked']);
if($checked == true) {
$query = mysql_query("SELECT * FROM `check_status` WHERE `user_id` = '$_SESSION[userid]' and `id` = '$id'");
else
 //some other query
//Then i can insert the query based on if the checkbox checked or not.

edited Jan 11, 2013 at 16:22

answered Jan 11, 2013 at 16:13

Suresh Kamrushi

16.2k13 gold badges79 silver badges93 bronze badges

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

6 Comments

crush Over a year ago

He will also need to update the Javascript function to accept, and then pass the second parameter.

Curtis Crewe Over a year ago

So my new code would be

function updateStatus(id,value) { 	http.abort(); 	http.open("GET", "../functions/ajax.php?check=update_status&id=" + id + "&checked=" + value, true); 	http.onreadystatechange = function () { 		if (http.readyState == 4) { 			alert(http.responseText); 		} 	} 	http.send(null) }

Curtis Crewe Over a year ago

@suresh-kamrushi when i do that it's returning true everytime?

Suresh Kamrushi Over a year ago

<input type="checkbox" name="status" onClick="alert(this.checked)"> just see this html in browser and click on it. It will populate with true or false only. Best of luck

Curtis Crewe Over a year ago

I will go ahead and update my current code to the question so you can understand what i mean, sorry for the miscommunication.

|

Collectives™ on Stack Overflow

Insert mySQL query if checkbox checked/not checked with PHP

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related