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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> 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

Reply via email to