Unable to display blob image ?

Stirnpanzer

Am trying to display some php fields in a html table....

all ok except the blob file 'person_photo' which displays as a broken image ?

with the following as the img source :

http://localhost/xampp/mydb/image_test.php?id=10

where record 10 'person_photo" has a valid photo ???

is it syntax or me ??

My display page :

Print"<table width='100%' height='1000' border cellpadding=1>"; 
while($info = mysql_fetch_array( $data )) 
{ 
Print "<tr>";
Print "<td height='59'>&nbsp;</td>";
Print "<td >Lastname : " .$info['person_lastname'] . "</td>";
Print "<td width='20%>&nbsp;</td>";
Print "<td width='18%'>Firstname : ".$info['person_firstname'] . "</td>";
Print "<td width='18%'>&nbsp;</td>";
Print "<td width='22%' rowspan='5'>Photo: <img src='display_image.php?id=" . $info['person_id'] . "' alt='Picture here' /></td>";
Print "<td width='5% rowspan='7'>&nbsp;</td>";
Print "</tr>"; 
Print "</table>";
}  

?>

display_image.php

<?php
//  primary key
$id = (int)$_GET['id'];
$query = "SELECT * FROM people WHERE id = $id";
$data = mysql_query($query);
$info = mysql_fetch_array($data);

header('Content-type: image/jpeg');
echo $info['person_photo'];

?>

big_nerd

Stirnpanzer,

Although I've never done this before myself, I would recommend these items to check:

1) Comment out the header content type from display_image.php and try to visit that with your browser, see if there are any errors
2) in display_image.php (pending errors) set: ini_set('display_errors',0);
3) I DOUBT this will affect it, but make sure there is no space after ?> (closing php comment)

Not sure if anyone else has any ideas, but I'd personally start there.

bradgrafelman

big.nerd wrote:
2) in display_image.php (pending errors) set: ini_set('display_errors',0);

Not that display_errors should ever be turned on for a production server, but if there were errors, the solution wouldn't just be to turn of error reporting... it would be to fix them. 🙂

big.nerd wrote:
3) I DOUBT this will affect it, but make sure there is no space after ?> (closing php comment)

It would make a huge difference if there were any whitespace outside the PHP tags, since that would alter the image data.

Other than that, sounds like a good plan of attack.