getimagesize & mysql problem !

[Richi]

hi

am uploading the images to db, and am geting the images width and height from the temp name .

$img_info = getimagesize($HTTP_POST_FILES[image][tmp_name][$num]); 

the strange thing when i make echo for the img_info[0] and img_info[1] , i got the real size for image, but it insert it into db always 127 x 127 !!!

WHAY ?

[notepad_coder]

Try:

$i = $_FILES['image'];
$s = getimagesize($i);

// MySQL
$n = mysql_query("INSERT INTO table (img, imgsize) VALUES ('$i', '$s')") or die(mysql_error()); 

[Richi]

i had try it befor..out is ;

Warning: getimagesize: Unable to open 'image' for reading.

this the input fields :

$n =5;
$num=0;
        while ($num++ < $n)
        {
        
           $fileds .= "<input  class=\"input\" type=\"file\" name=\"image[$num]\" size=\"30\" value=\"$image[$num]\"><br>\n\n\n";


        }
        echo $fileds; 

[Richi]

found it, bad row type in db !

[DR_LaRRY_PEpPeR]

yep, you had a TINYINT column, didn't ya? SMALLINT UNSIGNED should be fine.

[Richi]

yes ..

btw i put int, is this will be slow when i query something from db ?

i mean if i give column longblob for value 'yes' or 'no' , is this make the query slow ?

[DR_LaRRY_PEpPeR]

INT just takes more space than SMALLINT. i always use the smallest column possible that will hold the range of values that i need to store.

same thing if you used LONGBLOB to store a "yes" or "no" value; it would waste space.

[Richi]

waste space of what ?
and what about the query speed in this case ?

[DR_LaRRY_PEpPeR]

wastes disk space. also, if it's an indexed column, it will waste space in the index cache (key_buffer). and yes, when your data is larger, it could technically make queries slower.

[Richi]

i see ..
well thx for info