Display image from DB

[SweNuckan]

Hi,

Im having alot of problems with displaying images from a DB. Ive stored the image im the DB as a mediumblob. It find the correct image (i think) but i cant display it..

This is the code:

<?php
	$film = $_GET['filmNr'];													// Unique identifier
	$getmovie = mysqli_query($connection, "SELECT * FROM Film WHERE filmNr='$film'");

if (!$getmovie) {
	$error = 'Ett fel inträffade under hämtningen av film: ' . mysqli_error($connection);
	include 'error.inc.php';
	exit();	}

while ($movie = mysqli_fetch_array($getmovie)) {
	$movies[] = "<p>Titel: " . $movie['titel'] .
				"<br />Pris: " . $movie['pris'] . " kronor <br /> Beskrivning: " . 
				$movie['beskrivning']; }

if (empty($movies)) {
	$error = 'Det finns inga sparade filmer. ';
	include 'error.inc.php';
	exit();	}

$getimage = mysqli_query($connection, "SELECT * FROM Bild WHERE filmNr='$film'");				

$image = mysqli_fetch_array($getimage);
$filnamn = $image['filnamn'];						// Filename
$filtyp = $image['filtyp'];							// FIletype
$fildata = $image['fildata'];						// Filedata
$disposition = 'inline';							

header("Content-type: $filtyp;");
header("Content-disposition: $disposition; filename=$filnamn");
header('Content-length: ' . strlen($fildata));

foreach ($movies as $movie) { ?>
		<p> <?php
			echo $movie; ?>
			<img src="<?php echo $fildata; ?>" />	
		</p>
<?php } 
?>

Some help would be appreciated!

[NogDog]

You cannot output the actual image data within a [X]HTML document. You need a separate "image server" script that you will call from an <img> tag's "src" attribute within that document. So in the main page you might output an img tag with the DB id for the image:

<img src='path/to/images/image.php?id=<?php echo $image_id; ?>' />

Then your image.php file (in this example) would use $_GET['id'] -- properly sanitized -- to get the data from the DB and echo it after the applicable header() options. Nothing else must be output by that file, just the image header()'s and the actual image bytes.