hello,

I have a web form that allows a user to upload a picture.  I want to resize this image to a 180 pixel heigth,  then store the thumbnail as a blob in mysql.  

Here is what I have so far, but unfortuneatly, this code only stores the address of the resized image to mysql:

Code:

$fileName = $_FILES['imageFile']['name']; $tmpName  = $_FILES['imageFile']['tmp_name']; $fileSize = $_FILES['imageFile']['size']; $fileType = $_FILES['imageFile']['type']; if ($fileName)                                    {                                          $fp      = fopen($tmpName, 'r+');                                          $content = fread($fp, filesize($tmpName)); //reads $fp, to end of file length                                                                                    fclose($fp);                                          // get originalsize of image                                          $im = imagecreatefromstring($content);                                          $width = imagesx($im);                                          $height = imagesy($im);                                                                                                                        // Set thumbnail-height to 180 pixels                                                                              $imgh = 180;                                                                                    // calculate thumbnail-height from given width to maintain aspect ratio                                          $imgw = $width / $height * $imgh;                                                                                    // create new image using thumbnail-size                                          $thumb=imagecreatetruecolor($imgw,$imgh);                                                            // copy original image to thumbnail                                          imagecopyresampled($thumb,$im,0,0,0,0,$imgw,$imgh,ImageSX($im),ImageSY($im)); //makes thumb                                                                                                                              //  Need help here  how do I put ImageJPEG($thumb) to mysql as a blob?                                          $query = ("UPDATE user SET picture = '$thumb' WHERE userID = '$userID' ");                                          $result = mysql_query($query) or die( "An error has ocured: " .mysql_error (). ":" .mysql_errno ());

How do I convert the resized image ($thumb) to a jpeg, and store it as a blob in mysql?  

Thank you for any help or advice, -jon

As a quick fix, Jon, I would save the resampled image to a temportary file, read it back into a variable, and save that to the database.   I'm on the road at the moment - please feed back further if that doesn't point you in the right direction and I'll get back further in a day or two

Thanks for your quick reply Graham.  I tried your suggestion and now it is working with the following added code:

Code:

imagejpeg($thumb, "test.jpg", 80);  //imagejpeg($resampled, $fileName, $quality);                                                      $instr = fopen("test.jpg","rb");  //need to move this to a safe directory                                      $image = addslashes(fread($instr,filesize("test.jpg")));                                                                  mysql_query("UPDATE `user` SET `picture`= ( \"".$image."\") WHERE `userID`= '$userID' ");

BTW, thanks for posting all your great examples.  This site is very resourcefull and much appreciated.

---