RE: [PHP] php mysql live feed

Nameless, I see someone mentioned the setTimeout(function, milliseconds) function for JavaScript. I would also like to point out that you can use setInterval(function, milliseconds) in order to have an event repeat at a set interval. For instance, let's say you had a page laid out like so: --- <div id="blah"> Text here </div> --- You would want to add a script somewhere that would begin the interval in order to update the div: --- <script type="text/javascript"> function ajaxRequest() { // <insert postback code here> document.getElementById("blah").innerHTML = ajax.responseText; } var t = setInterval("ajaxRequest()", 5000); </script> --- This assumes that your XmlHttpRequest object is named "ajax". Assigning the interval to variable "t" ensures that you can clear the interval if you need to (via "clearInterval(t);"). I suppose "innerText" can be used instead of "innerHTML", as well. I would recommend using innerHTML only if you will be populating the div with HTML code, however. Hope this helps, Todd Boyd Web Programmer > -----Original Message----- > From: admin@buskirkgraphics.com [mailto:admin@buskirkgraphics.com] > Sent: Tuesday, May 20, 2008 3:25 PM > To: php-general@lists.php.net > Subject: [PHP] php mysql live feed > > Okay before i pull more hair out... > > I am trying to use php to pull mysql data and refresh the mysql data > every say 5 seconds for like a live display of the database without the > screen reloading. > > I want the data to refresh but not the screen. Ajax seems to hate me > because everything i have seen/read/tried is wrapped around ASP.NET or > requires a user interaction to invoke the query. > > If you have example scripts or a good tutorial that actually works > where you can open a php script and the data changes on the page as the > database does and the screen does not refresh, and you don’t have to > onclick, onfocus, or onblur kind of thing. I would be in your debt > > Frustrated Rick > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php