how to find out the image size stored in database?

[shailajaAdiga]

Hi All..

images are stored in database(imagec ontent and image type is stored).Current ly i have displayed the image in popup window (no size limits to window). I would like to get the image size and display accordingly.
is it possible to get image size if i retireve imagecontent from databse?

Please anyone help me out.


Thanks..

[realin]

Hi All..

images are stored in database(imagec ontent and image type is stored).Current ly i have displayed the image in popup window (no size limits to window). I would like to get the image size and display accordingly.
is it possible to get image size if i retireve imagecontent from databse?

Please anyone help me out.


Thanks..

Correct me if i am wrong.. but you said stored image content in the database.. meaning.. what you did ? Stored the binary form of image, or you mean you stored its name in the database ?

You can get the size of an image using imagesx and imagesy function for more info goto Image functions in php

cheers !!

[shailajaAdiga]

Correct me if i am wrong.. but you said stored image content in the database.. meaning.. what you did ? Stored the binary form of image, or you mean you stored its name in the database ?

You can get the size of an image using imagesx and imagesy function for more info goto Image functions in php

cheers !!

Thanks for your reply.

I have stored image content(blob) in database not image name..
i'l look into the url

thanks once again

[pbmods]

Heya, shailajaAdiga.

LENGTH() works on binary strings as well as text.

[realin]

Heya, shailajaAdiga.

LENGTH() works on binary strings as well as text.

I dont know what does it show.. but when i uploaded an image of 28KB showed me 7 ... how come ? as per the manual it should show the number of bytes and if it does then also .. it showing the accurate ones..

correct me if i am wrong.. cause just now i learnt what's BLOB :p

and i suppose she wants to show the WxH and i suppose that imagesx and imagesy is the best function.. she can just fetch the values when she is about to shwo the image..

what say ?

[pbmods]

Heya, Realin.

Ah, I see. The OP is looking for the image dimensions, not the file size. In which case you are correct; imagesx() and imagesy() would be the best options.

Incidentally, a much less memory-intensive implementation would be to determine and store these values in the database with the image data.

[realin]

yup.. storing the image size at the time of upload is the best option.. you can further add more info like, the type of image, size,downloaded times, category, a tinyint column to show image or not to show.. etc etc..

that would be a better appraoch :)

btw, what does OP stands for .. "our programmer" :P

[shailajaAdiga]

Correct me if i am wrong.. but you said stored image content in the database.. meaning.. what you did ? Stored the binary form of image, or you mean you stored its name in the database ?

You can get the size of an image using imagesx and imagesy function for more info goto Image functions in phpcheers !!

Since i didnt store image name in databse I have tried this one..
retrive the binay form of image ,write that content into one tempfile...
then by using tempfile name findout image size(found this concept in php manual)
i could get height and width value..

still have to look into it to get it done properly..

thanks

//function to get image size
function getimagesize_raw($data){
                        $cwd = getcwd(); #get current working directory
                        $tempfile = tempnam("$cwd/tmp", "temp_image_");#create tempfile and return the path/name (make sure you have created tmp directory under $cwd
 
                        $temphandle = fopen($tempfile, "w");#open for writing
                        fwrite($temphandle, $data); #write image to tempfile
                        fclose($temphandle);
                        $imagesize = getimagesize($tempfile); #get image params from the tempfile
                       echo $imagesize;
                        unlink($tempfile); // this removes the tempfile
                        return $imagesize;
                   } 
 
if ( $image_id > 0 ) {
                               $sql = "SELECT image FROM organization_logos WHERE image_id = '$image_id' ";
$result = mysql_query($sql) or die(mysql_error());
                            $row = mysql_fetch_assoc($result);
                            extract($row);
                            /*$size = getimagesize_raw($image);
 

[realin]

does storing the pic in this binary format.. degrades its quality on its reform ??

[shailajaAdiga]

does storing the pic in this binary format.. degrades its quality on its reform ??

when i display th image, quality of the picture is not that good