[RESOLVED] Animated Please Wait while getting data

[tcarnes]

I have a search form set up that calls a results page which performs the query and then displays the results.

When I first created it, it was pretty snappy. But now that I have millions of records to search (I started out with a smaller sample), the search is taking 20 seconds or so.

What I would like to do is display some kind of "Please wait while I get your information" type of message that would then go away when the data was ready. Some kind of animated gif might really be cool.

I have no idea how to do this. Currently my Result page looks blank until the data is ready to be displayed.

Can someone please point me in the right direction here?

Terry

[bogu]

U should check ajax (XML HTTP Request), try searching here on the forum or google ...

[schwim]

Dude! You gotta sign up for the PHPBuilder articles!

If this pertains to what you need, then they posted an article on it just a week or two ago. You can find it here.

Hope this is what you're looking for.
json

[tcarnes]

I ended up finding a great solution at the PHP Garage. It was a combination of HTML, one line of PHP, and a single line of JavaScript.

<?PHP
// Insert all your beginning code, Header, Includes, etc.

// Insert all your form validation code here

// Now we're getting ready to run the query so put up the Please Wait message

// I used a table and animated gif

echo '
<div name="wait" id="wait" style="visibility: block">';
// The key is this div tag. After the processing is over, we will make this div tag invisible

// So everything between the div tags will be my Please Wait message
echo '
<br /><br /><br /><br /><br /><br /><br /><br /><br />
<table width="440" cellpadding="0" cellspacing="2" border="0" bordercolor="#003366" bgcolor="FFFFCC" class="octext-search" >
<tr>
<td>&nbsp;</td>
<td align="center">Please wait...</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>';

// I use an animated gif to give the sense of something happening
echo '
<td align="center"><img src="images/animated_gif.gif" width="32" height="32" /></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td align="center">We are retrieving the information you requested.</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td></td>
<td>&nbsp;</td>
</tr>
</table>
</div>';

// Then to send the page as so far rendered to the browser:
flush();

$conn = db_connect();
$result = $conn->query($query);
if (!(DB::isError($result)))
{
// Query is finished to do away with the Please Wait message
?><script type="text/javascript"> document.getElementById('wait').style.display="none"; </script> <?php

// Go ahead and output your query results!

}

include $footer_url;
?>

Hope this helps!

Terry