getImageSize() with images stored in BLOBs?

MungoBBQ

I've got a mySQL database with a number of images (GIFs and JPGs) stored in BLOBs in a table. Now, I'd like to be able to use getImageSize() on them when I need to put them in my presentation. I have PHP code for displaying the image which works just fine, but for some reason I can't use getImageSize() on that file.

I.E. I try to do this:
$size = getImageSize('http://localhost/dbImg.php?id=110');

But I receive this error:
Warning: getimagesize: Unable to open 'http://192.168.0.5/dbImg.php?id=110' for reading.

Of course the URL http://192.168.0.5/dbImg.php?id=110 works just fine and displays a nice little GIF image stored in the database. Does anybody know if there is a way to solve this?

PyroX

Probably because the function works only on local filesystems.

Do you need size as in WxH , or size as in Kb?

MungoBBQ

That's what I feared, but the user notes in the PHP online function reference actually has somebody saying it works.

Anyway, I was looking for WxH.

PyroX

Hmmm.

Are you sending the headers for the image before you send it?

This is a crappy way of doing it, but I am sure there are methods for getting this info after it is displayed.

MungoBBQ

Well, yes, I'm sending the following headers before the image data:

header ("Accept-Ranges: bytes");
header ("Connection: close");
header ("Content-type: " . $rows["filetype"]);
header ("Content-Length: " . $rows["filesize"]); 
header ("Content-Disposition: inline; filename=\"" . $rows["filename"] . "\"");
echo $rows["filedata"];