Updating db with PHP and Ajax

[Aur1cles]

I have a form where users can change previously entered data, it get's submitted when they click on check box. I got some of it to work, right now it only knows which entry to update and passes one value, but I need it to pass two check box values and one input value. This is the form:

<input type="checkbox" name="check1" value="1"/>//need to get this value to database
<input type="checkbox" name="check2" value="1"/>//need to get this value to database
<input name="comment[<?PHP echo $id; ?>]" type="text" size="20" maxlength="200"/> //need to get this value to database
<input type="checkbox" onclick="SaveToDatabase(<?php echo $id;?>)" value="1"/> // when this is checked the data gets updated

Ajax:

function SaveToDatabase(id) {
   var url = "update_database.php?id="+id;
   if(window.XMLHttpRequest) {
      req = new XMLHttpRequest();
   } else if(window.ActiveXObject) {
      req = new ActiveXObject("Microsoft.XMLHTTP");
   }
   req.open("GET", url, true);
   req.send(null);
}

 

And PHP file that updates the database :

 

include('mysql.php');
$id = $_GET['id'];
$sql = "UPDATE database SET processed = '1' WHERE id = '$id'";
$result = mysql_query($sql) or die (mysql_error());

 

If somebody could help me find a way to pass all these values to ajax and then to php for update.

[Christian F.]

I recommend that you look into jQuery for this, as it'll help you do this a LOT easier.

If I recall correctly, they do have some examples showing how to accomplish what you're after in their manual too.

[ialsoagree]

Your problem is here:

 

"var url = "update_database.php?id="+id;"

 

The URL only contains the ID, it doesn't contain the names and values of the form.

 

Because you're not using the HTML submit feature (which would have the browser handling the HTTP request to submit all the form names and their values) you have to do this manually. That is, you have to rewrite the URL to include every form name, and the form value.

 

For example:

 

var url = "update_database.php?id="+id;
var url = url+"&check1="+ //assign an ID to check1, and then you could use getElementById(ID Assigned).value

[jardrake]

Ugh, why do we still dwell in the world of manually typing our XMLHttpRequest Objects, when jQuery is so much easier.