saving temporary image to database

From: Date: Sat, 29 Jun 2002 13:08:52 +0000
Subject: saving temporary image to database
Groups: php.db php.general 
Request: Send a blank email to php-db+get-20197@lists.php.net to get a copy of this message
Hi there, I would like to save a jpg into a blob field of mysql. The function underneath works fine if I read the image from the temporary destination where php did put it after uploading. My problem is, that I would like to do some funky stuff to the image like changing colors or adding watermarks. So I have several functions ahead before I used to store them successfully to the file system. Now I would like to store it to a blob field, but this does not work. Like I said it works to store the temp file, but not the other one. I guess it has to do with something regarding the imagejpeg function. Here is what I tryed: ######################################### # save image to db into blob // this does not work (outputImg is a the colorcorrected file) $data = addslashes($outputImg); // this one would work # $data = addslashes(fread(fopen($picture_location, "r"), filesize($picture_location))); $stmt =" INSERT INTO test.picture_test (file_name, file_type, picture) VALUES ('$name', '$picture_location_type', '$data') "; execute_stmt($stmt, $link); ######################################### Maybe some of you guy has a good idea on that. Thanx for any help, Andy

« previous php.db (#20197) next »