show blob image from mysql

carolynspeakman

does anyone know why this won't show the image? i've tried everything!

thanks,
Carolyn

<?php require_once('Connections/IntProg.php'); ?>
<?php
if($GET['id']) {
$query = sprintf("SELECT image, imagetype FROM entries WHERE id=%s", $GET['id']);
mysql_select_db($database_IntProg, $IntProg);
$result = mysql_query($query, $IntProg) or die (mysql_error());
$data = @mysql_result($result, 0, "image");
$type = @mysql_result($result, 0, "imagetype");
header("Content-type:$type");
echo $data;
}
?>

AstroTeg

Have you verified your query works? (Have you copied it and put it in phpMyAdmin to see if it actually returns a row?)

Does $type contain the correct (and valid) content type (such as: image/jpeg or image/gif)?

carolynspeakman

when i pull up the getimage.php?id=whatever it recognises that there is supposed to be an image, it just can't display it

AstroTeg

what is the value of $type?

AstroTeg

You might also try echo strlen($data) just as a sanity check to make sure $data actually does contain data.

carolynspeakman

returns 39128

carolynspeakman

$type = image/pjpeg

AstroTeg

$data looks like it should contain groovy data. You try a content type of just image/jpeg and does it do anything?

carolynspeakman

didn't do anything...

thanx for your help by the way!

AstroTeg

Hmm... I'm not seeing anything obvious with the code so its time for trial and error.

Have you tried commenting out the content type and just display the output? You should see a page of junk. If you don't, then you may have a problem with some code before your echo $data statement. You will also want to remove the '@' in from of mysql_result() which tells PHP to not echo warnings (we want the warnings displayed). When you load this script, see if you get any MySQL warnings or errors...

carolynspeakman

i get lots of junk, no errors or warnings tho

carolynspeakman

sql insert command for inserting the data into database:

$qry = "INSERT INTO entries (username, title, content, `date`, `time`, image, imagetype) VALUES ('".$username."', '".$title."', '".$content."', CURDATE(), NOW(), '$image', '$imageType')";

seems to be working

AstroTeg

Originally posted by carolynspeakman
i get lots of junk, no errors or warnings tho

Ok - thats good.

Go ahead and put your code back the way it was.

I'm going to bet that the browser has it cached. Try another browser that hasn't seen that page before. Or clear the cache and exit all browser windows and then go back to that page. And/or hold down shift and click refresh/reload.

carolynspeakman

still not working...

AstroTeg

I think I'm officially out of ideas.

carolynspeakman

me too... oh well, thanx very much for your help anyway! 🙂

AstroTeg

Do you have to save the image in the database?
Do any other images work? Is that just a bad image?
What browser are you using? If its IE, its possible IE is hanging up on the extension being .php (although I doubt this because I'm pretty sure I have image scripts that I just leave the .php on because I was lazy)

carolynspeakman

this works:

<?php
if($GET['id']) {
require_once('Connections/IntProg.php');
$query = sprintf("SELECT image, imagetype FROM entries WHERE id=%s", $GET['id']);
mysql_select_db($database_IntProg, $IntProg);
$result = mysql_query($query, $IntProg) or die (mysql_error());
$data = mysql_result($result, 0, "image");
$type = mysql_result($result, 0, "imagetype");
header("Content-type:$type");
echo $data;
}
?>

instead of:
<?php require_once('Connections/IntProg.php'); ?>
<?php
if($GET['id']) {
$query = sprintf("SELECT image, imagetype FROM entries WHERE id=%s", $GET['id']);
mysql_select_db($database_IntProg, $IntProg);
$result = mysql_query($query, $IntProg) or die (mysql_error());
$data = mysql_result($result, 0, "image");
$type = mysql_result($result, 0, "imagetype");
header("Content-type:$type");
echo $data;
}
?>

AstroTeg

If that was the case, you should have had MySQL database connection errors before...