note 56668 added to function.imagecreatefromstring

I am storing images in a mysql database and wanted to scale them to be at a thumbnail and regular size. It was quiet difficult for me to locate an appopriate example. It is my hope the next poor fool searching on mysql database thumbnail and image jped or bmp will find this and not wander as much as I did. Pseudo code: 1. obtain user params 2. query db for binary object that is jpeg file 3. resize object is called for 4. output image hope this is of assistance. <?php // view.php?file=<id>&scale=<real number for scale size // Retrieve raw BLOB for image assuming JPEG // TODO: put in switch statement logic for multiple types // Note this is written with php4 with mysql and gd include 'db.inc'; // Secure the user data by escaping characters // and shortening the input string $file = clean($_GET['file'], 4); $scale = clean($_GET['scale'], 4); // file db id is required if (empty($file)) exit; // default scale 1.0 if (empty($scale)) $scale = 1.0; // Connect to DB and obtain BLOB for JPEG if (!($connection = @ mysql_pconnect($hostName, $username, $password))) showerror(); if (!mysql_select_db("test", $connection)) showerror(); $query = "SELECT mimeType, fileContents FROM files WHERE id = $file"; if (!($result = @ mysql_query ($query,$connection))) showerror(); $data = @ mysql_fetch_array($result); // Found blob? if (!empty($data["fileContents"])) { // convert binary data into image object // to allow for manipulation via GD image routines $img=imagecreatefromstring($data["fileContents"]); // Get image size and scale ratio $width = imagesx($img); $height = imagesy($img); // calculate new scale $new_width = floor($scale*$width); $new_height = floor($scale*$height); if ($width != $new_width) { // Create a new temporary image $tmp_img = imagecreatetruecolor($new_width, $new_height); // Copy and resize old image into new image imagecopyresized($tmp_img, $img, 0, 0, 0, 0, $new_width, $new_height, $width, $height); imagedestroy($img); $img = $tmp_img; } // Output the MIME header header("Content-Type: {$data["mimeType"]}"); imagejpeg($img); imagedestroy($img); } ?> ---- Manual Page -- http://www.php.net/manual/en/function.imagecreatefromstring.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+56668 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+56668&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+56668&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+56668&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+56668&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+56668&report=yes&reason=non-english Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+56668&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+56668&report=yes Search -- http://master.php.net/manage/user-notes.php