Help needed on AJAX with PHP

[kks_krishna]

HI,

 

I want to make ajax call to update MySql database and return some values, it will be update with the page.How can I do that? Please guide me.

 

 

[kks_krishna]

What is wrong with this code:

Html code

<script type="text/javascript"> 
		var url = "AjaxCall.php"; // The server-side script
		 var xmlhttp;
		function handleHttpResponse() {   
			alert(6);
        if (xmlhttp.readyState == 4) {
			alert(7);
			var results=xmlhttp.responseText;
			alert(results);
			if(xmlhttp.status==200) {
                  var results=xmlhttp.responseText;
			  alert(5);
			  alert(results);
			}
		  }
	    } 
		function requestCustomerInfo() {     
			//var sId = document.getElementById("txtCustomerId").value;
			xmlhttp = getHTTPObject();
			xmlhttp.open("GET", url, true);
			xmlhttp.onreadystatechange = handleHttpResponse;
			xmlhttp.send(null);
		}
		function getHTTPObject() {
		     
			  if(window.XMLHttpRequest){
				xmlhttp = new XMLHttpRequest();
			  }
			  else if (window.ActiveXObject){
				xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
				if (!xmlhttp){
					xmlhttp=new ActiveXObject("Msxml2.XMLHTTP");
				}
   				}
			return xmlhttp;
		} 
	</script>

 

 

AjaxCall.php

<?php

echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>Age</th>
<th>Hometown</th>
<th>Job</th>
</tr>";
echo "<tr>";
echo "<td></td>";
echo "</tr>";
echo "</table>";
?>

[sayedsohail]

what are you trying to achieve,  the javascript is fine except you got to-many alerts, please remove all this alerts except alert(results);, secondly i don't see how you are calling the requestCustomerInfo() function.

 

If you are using a separte file and calling this function.  please show the file.    I mean you should be calling requestCustomerInfo() from somewhere?

[kks_krishna]

Here is the code to call that method :

 

<form name="comment_form" action="">
				<table  width="100%">
					<tr>
						<td>
							Add your comments
						</td>
					</tr>
					<tr>
						<td>
							<textarea name="comments" cols="40" rows="5"></textarea>
						</td>
					</tr>
					<tr>
						<td>
							<input type="submit" value="Add Comment" onclick="requestCustomerInfo()">
						</td>
					</tr>
				</table>
				<input type="hidden" name="op" value="comment">
			</form>