Passing multiple values thru ajax

[Toadums]

Hey...So I am just starting to learn AJAX, and I am having a hard time passing more than 1 value from my form to be queried...

so here is the AJAX code:

pageRequest.onreadystatechange=function() {	
				document.getElementById('test').innerHTML = pageRequest.responseText;
			}
			if (url) {		
				var dates = 'date=' + document.entryForm.Date.value;
				var hours = 'hours=' + document.entryForm.Hours.value;
				var phase = 'phase=' + document.entryForm.Phase.value;
				var projID = 'projID=' + document.entryForm.ProjectID.value;
				var descr = 'descr=' + document.entryForm.Description.value;
				var type = 'type=' + document.entryForm.Type.value;


			pageRequest.open('POST',url,true);
	    pageRequest.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');

		pageRequest.send(dates,hours,phase,projID,descr,type);
		}
		else {
			pageRequest.open('GET',url,true)
			pageRequest.send(null)	
		}
	}

I am trying to do: pageRequest.send(dates,hours,phase,projID,descr,type); but it doesnt seem to be working...

the PHP code which picks that data up is:

$Date=$_POST['date'];
$Hours=$_POST['hours'];
$Phase=$_POST['phase'];
$ProjectID=$_POST['projID'];
$Description=$_POST['descr'];
$Type=$_POST['type'];




$query1 = "INSERT INTO `pdem_timesheets`.`tblTimesheet` VALUES ('','$Name', '$Date','$Hours','$Phase','','$ProjectID','$Description','$Type')" ;

if(($results = mysql_query($query1))){
echo '<font color="green">Data successfully added</font>';
} else {
die('<font color="red">Error: '.mysql_error().'</font>');
   	}

It adds the date field to the query, but that is it.

Any suggestions?

Thanks!

[djjjozsi]

i'm building ajax fields dynamically:

<?php

$fields["tblTimesheet"] = array(
"Name"=>"Name","Date"=>"Date","Hours"=>"Hours","Phase"=>"Phase","ProjectID"=>"ProjectID","Description"=>"Description","Type"=>"Type");


// generating javascript for sending the contents to a .php
print 'pageRequest.open("POST", "ajax.php?add_tblTimesheet=1",true);
';
print 'var poststr="';
foreach($fields["tblTimesheet"] AS $key=>$value)
{
$out[]="{$key}=\"+ encodeURIComponent(document.getElementById(\"$key\").value)+\"";
}
print implode("&" , $out).'";';
?>

pageRequest.setRequestHeader("Content-length", poststr.length);
pageRequest.setRequestHeader("Content-Type", "application/x-www-form-urlencoded;charset=utf-8"); // set Header
pageRequest.send(poststr); //send value 

And pageRequest is an existing AJAX connection. Fill the field name here, and see the example: http://phpcode.hu/teszt/ajax_listbox/ 🙂

[Toadums]

Ya Im still not getting it, ive been playing with this for the past 2 hours and Im still at the same spot...I just need to know how to pass multiple values from AJAX into php..

"Name"=>"Name","Date"=>"Date","Hours"=>"Hours","Phase"=>"Phase"..etc

doesnt give the values off of a form...thats what I am doing..I want to run an add query based on what is in the form I have

[djjjozsi]

you can reach the field's values with their ID,
document.getElementById

this assumes that your ftextfields have ID tag in the html code.

[Toadums]

djjjozsi;10919668 wrote:

you can reach the field's values with their ID,
document.getElementById

I know how to get the values (code in first post)

I just dont know how to pass it to the php file. Also, when I said it doesnt give the values off the form I mean...you cant go:

"Name"=>document.getElementById,"Date"=>document.getElementById
,...etc

right?

Thanks for the help

[djjjozsi]

after a backup, try this one:

pageRequest.onreadystatechange=function() {	
				document.getElementById('test').innerHTML = pageRequest.responseText;
			}
			if (url) {		
				var contents = 'date=' + document.entryForm.Date.value+'&hours=' + document.entryForm.Hours.value+'&phase=' + document.entryForm.Phase.value+'&projID=' + document.entryForm.ProjectID.value+ '&descr=' + document.entryForm.Description.value+'&type=' + document.entryForm.Type.value;


			pageRequest.open('POST', url ,true);
	    pageRequest.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');

		pageRequest.send(contents);
		}
		else {
			pageRequest.open('GET',url,true)
			pageRequest.send(null)	
		}
	}

[djjjozsi]

"Name"=>document.getElementById,"Date"=>document.getElementById
,...etc
right?

Thanks for the help

No. the

$fields["tblTimesheet"] = array(
"Name"=>"Name","Date"=>"Date","Hours"=>"Hours","Phase"=>"Phase","ProjectID"=>"ProjectID","Description"=>"Description","Type"=>"Type");

is a php code to dynamically print Javascript. After that printed, that will collect your fields (if the field variable name have ID in html.)

<input type="text" name="Date" id="Date" value="xxxxx">

[Toadums]

Yay, just saw the post that had this in it:

				var contents = 'date=' + document.entryForm.Date.value+'&hours=' + document.entryForm.Hours.value+'&phase=' + document.entryForm.Phase.value+'&projID=' + document.entryForm.ProjectID.value+ '&descr=' + document.entryForm.Description.value+'&type=' + document.entryForm.Type.value;

That fixed it all!!! I had something like this before, except I wasnt using the & sign!!

THANKS!!!!!!!!!!!

[djjjozsi]

🙂 your welcome 🙂

try this code too.
http://phpcode.hu/dl/?f=1033