Hello list, Sorry for this cross post, I subscribed to PHP and PHP-DB, the PHP list seems to be receiving about 95% of the traffic so I thought I'd post this here as well to reach more of the PHP wizards.
I've been stumped on this for a while, I have a large project where I am storing image data in a MySQL db for reasons I will not get into. The images are displayed as thumbnails in a table which are hyperlinks to a large file. The larger file is stored in the db as a BLOB type in GIF format. I have a nice freeware commandline program for creating thumbnails called gifsicle. I thought the following code would work: // connect to db, set up SQL, etc. etc. etc. $image = $row["image_data"]; // this is the binary GIF image data Header ("Content-type: image/gif"); if ($view_type == "thumbnail") { passthru ("/usr/bin/gifsicle --resize 320x240 < " . $image); } else { echo $image; } flush(); This script works if called to view an image in full size, but if $view_type is set to "thumbnail" and the passthru command is executed, nothing is displayed. gifsicle generally works like this: /usr/bin/gifsicle --resize NNNxNNN < src_image > dest_image. I have tried using system and exec as well, nothing seems to work except the following: $fp = fopen("/tmp/tmp.gif","w"); fwrite($fp, $image); fclose($fp); passthru("/usr/bin/gifsicle --resize 320x240 < /tmp/tmp.gif"); This adds a LOT of file system I/O though as it has to write each full sized image stored in the db /tmp and slows things down quite a bit. Does anyone have any other suggestions? My goal is to store only one version of each image file and create smaller versions on the fly. PHP is 4.1.2 on a SuSE Linux 7.3 box, latest Apache server, MySQL 3.23.44. Thanks for your help! Josh Trutwin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php