Browser Issue

[Materialised]

I have written the following code as a test, (yes I know it is a
resource hog). Basically it pulls all images out of a MySQL table.

<?php
$conn = mysql_connect(h ost, user, pass);
mysql_select_db (testuser, $conn);

$query = "SELECT * FROM gallery";
$result = mysql_query($qu ery, $conn);

echo "<table width=\"50%\" align=\"center\ ">";
while($row = mysql_fetch_arr ay($result))
{
echo "<tr>";
echo "<td>$row[NAME] <br> $row[DESC] </td>";
echo "<td><IMG SRC=\"data:imag e/jpeg;base64," .
base64_encode($ row[IMG]) . "\"></td>";
}
echo "</table>";
mysql_close($co nn);
?>

Now I don't know where my problem is, but, when viewed with firefox, the
images load correctly, however when viewed with Internet explorer, the
images do not load.

You can see a example of the script in action at
http://codegurus.org/~mwalker/test.php

Does anyone know why the images will not show up in IE correctly?

[ColdShine]

Materialised in news:4a******** ****@individual .net wrote:

[...]

echo "<td><IMG SRC=\"data:imag e/jpeg;base64," .
base64_encode($ row[IMG]) . "\"></td>"; [...]
Now I don't know where my problem is, but, when viewed with firefox, the
images load correctly, however when viewed with Internet explorer, the
images do not load.

You can see a example of the script in action at
http://codegurus.org/~mwalker/test.php

Does anyone know why the images will not show up in IE correctly?

AFAIK IE doesn't recognize <img> tags with inline source. No wonder you only
see it working in Firefox (and probabily Opera, too).

--
ColdShine

"Experience is a hard teacher: she gives the test first, the lesson
afterwards." - Vernon Sanders law

[Materialised]

ColdShine wrote:

Materialised in news:4a******** ****@individual .net wrote:

[...]

echo "<td><IMG SRC=\"data:imag e/jpeg;base64," .
base64_encode($ row[IMG]) . "\"></td>";

[...]

Now I don't know where my problem is, but, when viewed with firefox, the
images load correctly, however when viewed with Internet explorer, the
images do not load.

You can see a example of the script in action at
http://codegurus.org/~mwalker/test.php

Does anyone know why the images will not show up in IE correctly?

AFAIK IE doesn't recognize <img> tags with inline source. No wonder you only
see it working in Firefox (and probabily Opera, too).

Thanks for your reply.
Do you know of any work arounds?

[fletch]

Save the image to a file. Not sure why the images are not in a file
anyway. Never could understand putting the images in a db.

[Materialised]

fletch wrote:

Save the image to a file. Not sure why the images are not in a file
anyway. Never could understand putting the images in a db.

As I previously said, I have my reasons for storing the image to a database.
The main one is for secondary back up purposes.

[fletch]

> As I previously said, I have my reasons for storing the image to a database.

Not in this thread.

You _must_ have files that need backing up as well? Do you know of
rsync?

It is much more efficient to let the webserver deliver images directly,
and as I see it, there is no _good_ reason not to go that route.

[Materialised]

fletch wrote:

As I previously said, I have my reasons for storing the image to a database.

Not in this thread.

You _must_ have files that need backing up as well? Do you know of
rsync?

It is much more efficient to let the webserver deliver images directly,
and as I see it, there is no _good_ reason not to go that route.

The client specifies the backup medium, mine is not to question why. lol

[fletch]

Ah one of _those_ clients. I have a few of them. Urgh. Like the one who
wanted a web based test which was to be delivered on CDRom and run on
only one laptop. My Javascript skills improved a lot though.

[Jerry Stuckle]

Materialised wrote:

ColdShine wrote:

Materialised in news:4a******** ****@individual .net wrote:

[...]

echo "<td><IMG SRC=\"data:imag e/jpeg;base64," .
base64_encode($ row[IMG]) . "\"></td>";

[...]

Now I don't know where my problem is, but, when viewed with firefox, the
images load correctly, however when viewed with Internet explorer, the
images do not load.

You can see a example of the script in action at
http://codegurus.org/~mwalker/test.php

Does anyone know why the images will not show up in IE correctly?

AFAIK IE doesn't recognize <img> tags with inline source. No wonder
you only see it working in Firefox (and probabily Opera, too).

Thanks for your reply.
Do you know of any work arounds?

What you need to do is create a PHP file to fetch the image, i.e. similar to:

getpic.php:
<?
if ($_GET['pid']) {
(connect to database and fetch row into $data)
header('Content : image/jpeg');
echo $data;
}

Then call it with

<img src="getpic.php ?id=1">


--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[Jerry Stuckle]

fletch wrote:

As I previously said, I have my reasons for storing the image to a database.

Not in this thread.

You _must_ have files that need backing up as well? Do you know of
rsync?

It is much more efficient to let the webserver deliver images directly,
and as I see it, there is no _good_ reason not to go that route.

Sure - there are very good reasons for keeping images in the database. I also
do it when appropriate.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===