Inserting dynamically generated Images into BLOB

[coffee_party]

Hi, I generate a thumbnail using GD and php, but now I want to store the resulting image in mysql. I have a field called imgbg which is a blob type, but when I make the update query, it insert a text saying "resource id#5" something like that?.

can you guys show another way ?

this is part of my code:

$tao = $POST['user'];
$smallPic = $FILES['smallPic'];

$image_type = $FILES['smallPic']['type'];
$image_type2 = $FILES['smallPic']['tmp_name'];
$sizer = $_FILES['smallPic']['size'];

$fileHandle = fopen($image_type2, "r");
$fileContent = fread($fileHandle, $sizer);
$fileContent = addslashes($fileContent);

$nw=80; //The Width Of The Thumbnails
$nh=80; //The Height Of The Thumbnails

$ipath = "/img/temp";

$img = $image_type2;

$dimensions = GetImageSize($img);

$thname = "img/temp/thumb". $tao .".jpg";

$w=$dimensions[0];
$h=$dimensions[1];

$img2 = ImageCreateFromJpeg($img);
$thumb = ImageCreateTrueColor($nw,$nh);

$wm = $w/$nw;
$hm = $h/$nh;

$h_height = $nh/2;
$w_height = $nw/2;

if($w > $h){

$adjusted_width = $w / $hm;
$half_width = $adjusted_width / 2;
$int_width = $half_width - $w_height;

ImageCopyResampled($thumb,$img2,-$int_width,0,0,0,$adjusted_width,$nh,$w,$h); 
ImageJPEG($thumb,$thname,95); 

}elseif(($w < $h) || ($w == $h)){

$adjusted_height = $h / $wm;
$half_height = $adjusted_height / 2;
$int_height = $half_height - $h_height;

ImageCopyResampled($thumb,$img2,0,-$int_height,0,0,$nw,$adjusted_height,$w,$h); 
ImageJPEG($thumb,$thname,95); 

}else{
ImageCopyResampled($thumb,$img2,0,0,0,0,$nw,$nh,$w,$h);
ImageJPEG($thumb,$thname,95);
}
imagedestroy($img2);

$Query = "UPDATE profile SET imgbg = '$img2' type = '$image_type' WHERE Id = '$tao'";
mysql_select_db($database_cs, $cs);
mysql_query($Query);

can you guys show another way ?

[Weedpacket]

That's because you're trying to store a GD-Lib image resource - which isn't the same thing as an image. You'll need to capture the actual image generated by imagepng or whatever, and store that in the database. ob_start(); imagejpg(); ob_end_clean(); or something like that (check the manual for those and their related functions). Once you've got the actual image data in a string, then you should have better luck getting it into the database.

After all that of course, there's the fun of getting it back out again.

But partly because of all the hassles involved, and also the decrease in utility (you can't search on BLOBs), general practice is to not store binaries like images in the database at all; instead it is to store them on the filesystem, storing only their file names in the database.

[coffee_party]

imagejpg() <-- will putting this to $img will work ? what else do i need ? and what does ob_start(); and ob_end_clean(); mean ?

[Weedpacket]

Originally posted by coffee_party
imagejpg() <-- will putting this to $img will work ? what else do i need ? and what does ob_start(); and ob_end_clean(); mean ?

Originally posted by Weedpacket
(check the manual for those and their related functions).