Re: note 56668 rejected and deleted from function.imagecreatefromstring by notes editor derek

This didn't seem to be suggesting a feature or asking for help. It was supposed to clarify a usage pattern to help the next person trying to manipulate images directly from a database. Can you let me know where would be an appropriate place to put this? It seemed to be in line with the other kinds of commentary that followed the official text. Thanks. On 9/11/05, php-notes@lists.php.net <php-notes@lists.php.net> wrote: > You are receiving this email because your note posted > to the online PHP manual has been removed by one of the editors. > > Read the following paragraphs carefully, because they contain > pointers to resources better suited for requesting support or > reporting bugs, none of which are to be included in manual notes > because there are mechanisms and groups in place to deal with > those issues. > > The user contributed notes are not an appropriate place to > ask questions, report bugs or suggest new features; please > use the resources listed on <http://php.net/support> > for those purposes. This was clearly stated in the page > you used to submit your note, please carefully re-read > those instructions before submitting future contributions. > > Bug submissions and feature requests should be entered at > <http://bugs.php.net/>. For documentation errors use the > bug system, and classify the bug as "Documentation problem". > Support and ways to find answers to your questions can be found > at <http://php.net/support>. > > Your note has been removed from the online manual. > > ----- Copy of your note below ----- > > 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); > } > ?> > -- Peter Kahn citizenkahn@gmail.com http://kahnstipation.blogspot.com Awareness - Intention - Action