Loading.... message

scmachine

Hi,

I was wondering if anyone knows how to code the following scenerio

I want to display a "Loading..." or "Please wait...." message while the script is processing MySQL query in the background and when the query is done the script should replace the "Loading..." message with the result of the query.

Does anyone know how to do that?

Thank you.

vsego

I'm sure it's done with smart use of status codes in HTTP headers (with header() function), but not sure how. I'm assuming it's combination of codes 201 and 202. Check HTTP specs at
http://www.ics.uci.edu/pub/ietf/http/rfc1945.html#Code201

Please post when you solve this.

Anon

Try this procedures but I'm not sure if it will work.
1. create a page that displays "Loading...".
2. display the page then call a second page that displays nothing. inside the second page do your query then use the javascript ONLOAD after your query.
3. call a third page which displays your query with the javascript ONLOAD.

inform me if it worked.

scmachine

The suggestions seems promising. I'll try them and post the results here if I can get it to work.

Thanks, guys.

vsego

You can send Status: 20x (x is 1 or 2 or something - not sure) to let browser know that nothing has change and no page reload is needed.

This way, combined with <meta name="refresh"...>, you can set browser to call the script (for example) chk.php every 5 seconds. Then, chk.php will check if the query is done (i.e. result was outputed to the file). If it's done, it sends you the result (or heard("Location: script-that-sends-result.php")😉. If it's not done, header("Status: 20x"); (check value of x at the page I've sent you)

If you're fine with JavaScript, the onLoad="" solution might be better, depending on what makes your query slow enough for this:
1. query takes lot of time (consider optimizing it)
2. query has big output which takes a lot of time to load (this definitely requires eloy's solution)