Blobs are being displayed as Text !!

Greenman

Hi,

Well I think I am nearly there I have managed to insert some image blobs into mysql and call them with php in a browser

The only proble is they are getting desplayed a ASCII TEXT rather than as images.

Any idea folks ?

<html>
<?php
$db = mysql_connect("localhost", "user", "passwd")
or die ("cant connect to the DB");

print ("You have connected to database successfully");

?><html><br><br><?php

echo date("D M d, Y", time());

?><html><br><br><?php

mysql_select_db("test",$db);

$query = "SELECT * FROM image";
$result = mysql_query($query);
$numrows = mysql_num_rows($result);

{
echo "There are $numrows user(s) in the database, they are";
}

?><html><br><br><?php

echo "<table border=1>\n";
echo "<tr><td>Name</td><td>e-mail</tr>\n";

while ($myrow = mysql_fetch_row($result)) {

	printf("<tr><td>%s %s</td><td>%s</td></tr>\n",
	$myrow[1], $myrow[2], $myrow[3]);

}
echo "</table>\n";

</html>

mogster

You must fetch the image into a tag for images, else html don't know that it should be displayed as one 😉

To do this, add the image query to a standalone script, then call it from the img-tag like this:

## You need to fetch the picture id or picture name and echo it into the img-tag ##
<img src="da_script.php?picture_id=<?PHP echo $picture_id; ?>" >
<?PHP
## This is the da_script.php ##
$query = mysql_query("select file, file_type, picture_name from field where picture_id=$picture_id");
$pdetails = mysql_fetch_array($query);
header("Content-Type: $pdetails[file_type]");
header("Content-Disposition: inline; filename=$pdetails[picture_name]");
echo $pdetails[file];
?>

knutm