Multiple images on the fly

[mliungman]

Hi!

I have created a ASP-based web page that queries an access database for chemical sampling data, and then uses a PHP-script to generate charts from each of the existing chemical compounds in the query. Like this:

1. ASP code with query to filter out chemical data for station x from all years
2. For each compound in the query, call a PHP-script generating a chart using
<img source="chart.php?compound=COMPOUND"/>
3. End ASP-script

Both scripts run fast and smooth, but sometimes (the first time the page is called) some of the charts are not downloaded correctly, or at least show up as red crosses. If the page is refreshed all charts show up.

Can someone explain to me where the problem is? Is the PHP too slow, or the ASP too fast, or too many compounds asked for at once. You can check the page out at http://www.lagansvattenrad.se/htm/utdata.asp. Any advice as to where the bottleneck is would be much appreciated.

Regards, Martin

[mliungman]

I just realized that if I right-click the red cross and choose "show image" it turns out just as it should. I think that the php-script is connecting too many times to the DB at the same time. I've tried to use onerror to force the images to reload, but have not been succesful. Like this:

Code: Select all

img onerror="setTimeout(function() {this.src=this.src;},4000);" src="url... and so on

Anyone got some advice?

[mliungman]

It appeared that

Code: Select all

this.src=this.src

did not force a refresh. I had to use

Code: Select all

this.src=this.src? + new Date().getTime()

, so as to bypass the cached error image.

At http://www.ultramegatech.com/2008/12/reloading-images-using-javascript/ I found the code I needed.