Graphics from mySQL

martincorby

ok - so I have managed to upload some images to a db but am struggling to get them back out and onto my page.

If I use just php coding ie

<?
require("config.inc");
$sql = "SELECT src, alttext FROM images WHERE id=$id";

$result = @($sql,$connection) or die("Couldn't execute query.");
while ($row = mysql_fetch_array($result)) {
$src = $row['src'];
$alttext = $row['alttext'];
}
echo "$src";
?>

.....the image is displayed, but if I try and embed this code into an html table, for example all that is displayed is the raw binary data !

What am I doing wrong ?

Many thanks

Ph0eniX

Originally posted by martincorby
ok - so I have managed to upload some images to a db but am struggling to get them back out and onto my page.

If I use just php coding ie

<?
require("config.inc");
$sql = "SELECT src, alttext FROM images WHERE id=$id";

$result = @($sql,$connection) or die("Couldn't execute query.");
while ($row = mysql_fetch_array($result)) {
$src = $row['src'];
$alttext = $row['alttext'];
}
echo "$src";
?>

.....the image is displayed, but if I try and embed this code into an html table, for example all that is displayed is the raw binary data !

What am I doing wrong ?

Many thanks

I have gotten it to work using this tutorial:

http://www.phpbuilder.com/columns/florian19991014.php3?print_mode=1

theeper

Try adding this line before you echo your $src variable.

header("Content-type: image/pjpeg");

Make sure there is no output before this line though. The easiest way to do this is to have the part of the script that creates the image be a seperate script that is linked. This way, you can have HTML output before the image is displayed.