getting photos back

scuba

Hi,

I have code like this:

Header("Content-type: image/jpeg");
<?

include("dataincludes/connect.inc");

$query = "SELECT Bin_Data FROM Distributor WHERE Username = 'scuba'";
$result = @($query);

$data = @MYSQL_RESULT($result,0, "Bin_Data");

echo("<head><title></title></head>

<body>
<table>
<tr>
<td>Hey everyone, this is my photo<br><br>$data</td>
</tr>
</table>

</body>
");

But when I implement it I get back jibberish like this:

Header("Content-type: image/jpeg"); Hey everyone, this is my photo

GIF89a£¢ÿÿÿÏÇÏÀÀÏ@ ÀÇÏÀÀÀÿÿÿ!ù,£@ÿh³Ê; ¾H§uXæº¯þè…ähv¨”)+¶ç+»t\Ãø<¬#Àø2ÂC8 4ŒE‰BŒ“Å£b™œêr·«6«àamà¯x&¹&¯y>—Ûì·Ü¡& ÷‰‰á+AMDO%Tn†q‡uwy‰sˆp’Š“Ž—‘”š˜]œ›™ž¡ 2£–¦Ÿ§ª1¥v>\MC…¨¢«c>»TK OƒÂRUUÁPÊÄ¶©Ÿ½½µÓ·ÔÎ)¥ÒÕÛ×ÖÍ¹ßÞãÜ˜áäÝåèæíïñðîôòõóùøû÷ýöÿúüÈ À‚"\xð €†#*„8Q"C‹/VÜ¨±Õã;3ŠÄH2dI'GšTø0¥Ë•(aªŒIsæH5_æ”©ÓfÏŸ,oºÃéÏˆ@EùXj¤]Ó‹Fîœês Q‰-W-@Ó®î¾D ìW¯KË2 »´*U©n[ZªðkS²ÌÖ‹O¬Szwåé}•ï[žˆQ^{Í—•!XÁ„™ö]›ïÞË‘Ÿr5ÊÔg¸:åÖÓº¡ÝÓ¨S«^{ÍÚòçÄ¯/.n»6hØ·ïm·oÝ½ÿ+¼xnã¿gò>Î}}

Can anyone tell me how to get my picture out of the database and looking like it should ?

Thnaks,
Steve

Anon

I never was able to retrieve an image out of a database. So instead I just point to it from the database and put the image in the filesystem.

Anon

the file is not being displayed as a jpeg. the first thing you should try, is actually putting your php inside of '<?' tags. secondly, once you actually have the file being set as a image/jpeg, it should occur to you that html cannot be displayed in an image. once you trash the html tags, and display only the image (i.e. $data) it should work for you.

scuba

yeah I can do that, but i want to be able to place that image in a <td> in a document. How on earth can I do that?

Anon

one option is to split it up into seperate files:

(picture.html)
<head><title></title></head>
<body>
<table>
<tr>
<td><img src="picture.php"></td>
</tr>
</table>
</body>

(picture.php)
<?
include("dataincludes/connect.inc");
$query = "SELECT Bin_Data FROM Distributor WHERE Username = 'scuba'";
$result = @($query);
$data = @MYSQL_RESULT($result,0, "Bin_Data");
Header("Content-type: image/jpeg");
print "$data";
?>