Can't get value into mysgl db

leinj

Hi,

I need to grab the width and height info from an uploaded image and stick it into my db record. I can get the info, but cannot get it into the db! For some reason, every time I INSERT these values, they come out as "127", the same number every time. However, when I print out the contents of the variable to the page, the correct values are shown.

Hears the code (gets info from submitted form, then...)

copy ($FILES['imagefile_large']['tmp_name'], "art/".$FILES['imagefile_large']['name']) or die ("Could not copy");

extract($_FILES['imagefile_large']); // "Extract" image info, which makes $name equal the file name of the image

$img_lg = $name; // Get image name

list($img_lg_sizew, $img_lg_sizeh, $type, $attr) = getimagesize("art/$name"); // Get width and height of image

Now, echoing $img_lg_sizew spits out the correct width of the image. But INSERTING the variable (as below) into the db results in "127" in each field.

$sql = "INSERT INTO paintings (title,cat,img_lg,img_lg_sizew,img_lg_sizeh) VALUES ('$title','$cat','$img_lg','$img_lg_sizew','$img_lg_sizeh')";

Help! 🙂

John

LordShryku

What are the fields setup as(smallint, int, varchar....)?
Have you echoed the SQL to the screen to see if it looks right?

leinj

Here's the type I set the field to: tinyint(11)

I'm not sure what you mean by echoing the SQL. I've checked the code and the result in PHPMyAdmin it seems like a billion times.

I have other fields of this type being submitted to (removed from previous post for clarity's sake) which don't seem to have this problem.

LordShryku

You have this

$sql = "INSERT INTO paintings (title,cat,img_lg,img_lg_sizew,img_lg_sizeh) VALUES ('$title','$cat','$img_lg','$img_lg_sizew','$img_l
g_sizeh')";

Now before executing it, do this

 echo $sql;

LordShryku

Nevermind. Change the column type. Tinyint column types only go up to 127. By inserting anything more than that, it's defaulting to the highest number it can handle.

leinj

Thanks! Guess I shoulda looked at the type descriptions more carefully when I set it up.

I'll give that a try tomorrow, thanks again!

John