[RESOLVED] Ajax Using PHP to pull in database records

[kaiser0427]

Hi eveyone,

I'm trying to use ajax to pull records from a database and display them one at a time with a 10 second pause between each record. The following function pulls all of them and displays them at once every 10 seconds.

function getCat(str) {
	if (window.XMLHttpRequest)
	  {// code for IE7+, Firefox, Chrome, Opera, Safari
	  xmlhttp=new XMLHttpRequest();
	  }
	else
	  {// code for IE6, IE5
	  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
	  }
	xmlhttp.onreadystatechange=function() 
	  {
	  if (xmlhttp.readyState==4 && xmlhttp.status==200)
		{
		document.getElementById("details").innerHTML=xmlhttp.responseText;
		
		}
	  }
	xmlhttp.open("GET","changeCat.php?x="+str,true);
	xmlhttp.send();
	setTimeout("getCat('yes')",10000);
}

I'm thinking I need to pull the use PHP to pull the results from the database and store them in an array. Then use JS to iterate through the array. If so, I'm not sure how to do that. Each record has 15 fields. If I'm on the wrong track please let me know what track i should be on. I appreciate any help.

Thanks,

Tim

[xelawho]

so, this line:

document.getElementById("details").innerHTML=xmlhttp.responseText;

shows all 15 of the records at once, but you would rather split them and put them in an array?

If so, it is hard to say how without seeing the responseText object you can put this line below that one:

console.log(document.getElementById("details").innerHTML=xmlhttp.responseText);

and view the object in Chrome's javascript console. Or provide a link to the page where this is happening.

[kaiser0427]

Thanks for the reply. here is the link

http://www.westbywi.com/test.php

[xelawho]

where are the 15 fields? Is it that every house (or whatever they are) has 15 pieces of information ('cos I count 12 or so).

Better yet: what do you want your array to look like?

[kaiser0427]

I found a way to do it. I had php write the js. then i could call the records with a js function.