get image size and info from BLOB (MySQL) ?

[feha]

I do have stored images in mySQL blob field's.

 

I can display image by using:

function blob2image ($item_id = "03-07-12", $image_mode = "s")
{
//by feha
        $image = '';
	$db = new clsDBcms();
$image = CCDLookUp("Picture_Small", "items", "No=". $db->ToSQL(trim($item_id), ccsText), $db);
  	$db->close();

  	if(strlen($image))
{
//list($width, $height, $type, $attr) = $image; //This part don't work ok ?!

header ("Content-Type: image/jpeg");
echo $image;
}
}

 

Is there any way to get this info ?

Note: list($width, $height, $type, $attr) = getimagesize($image); don't work on this string ...

 

 

 

[KrisNz]

getimagesize only works on files, not raw data. You can use imagecreatefromstring() to recreate the image as a resource, then use functions like imagesx(),imagesy() image_type_to_extension() to get those bits of information. But if you need that information it would make more sense to store it in the database when you first save the image, since that will save you a lot of overhead.

[feha]

Hi

Thank you a bit late respond from my side.

I usually store sizes in to tb table but i got a DB from client with images (blob).

I think the only way is to make temp image file as cache and read from there.