slow query

Anon

Hi, I have a real slow query. It is because it is a recursive query and takes a while for it to load but that is a problem for another time.

Basically what I want to do is while the query is running, print a message on the page that it is loading. So the user does not quit the page if they get impatient.

Any ideas on how to start this?

Thanks,
Tim.

[deleted]

simplest way: an intermediate page.
Whenever a for is submitted, it is submitted to an intermediate script that just prints 'please wait' and then passes the submitted data on to the 'real' script.
WHile the 'real script' is loading, the user will see the intermediate page.
It is not untill the 'real' script starts generating output that the intermediate page will disappear to make place for the real page.

Anon

How is it possible to pass the submitted data on to the 'real' script?

sarahk

a few ways but probably the easiest is to put up the intermediate page with a meta refresh tag pointing to
mypage.php?name=xxx&address=xxx which you have constructed with the data received.

You will need to uuencode (syntax?) them. Put a 0 wait on the refresh.

If the refresh wipes your page too quickly then use the body tags onload event to run some java script to submit a form made entirely of hidden tags - the tags holding your user's data.

This should be quite simple. Have a play with it using really really simple forms and see how it works.

matt1

Maybe I don't understand the problem, but why don't you print your message then execute your query? Is it a buffering problem?

You could do this:

<body>
Please wait...
</body>

<?php
do the query
header("Location:/query result page");
You could pass the query results as a parameter or write a file that would be read by the results page.

If it doesn't flush the buffer, do a flush() before running the query.