Re: resizing images comming out of blobs
| From: | Dan Koken | Date: | Fri, 05 Jul 2002 10:19:26 +0000 |
| Subject: | Re: resizing images comming out of blobs | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-20333@lists.php.net to get a copy of this message | ||
Andy,
Yes I do it all the time. In this example, I do this with a window that has buttons across the top of a image representing size from 1 to 10. Depending on the button they select they get a image displayed from small to large.
Here is a snip of code that displays the sized images.
----------------------------
The button name is $s. They select from 1 to 10, but can be any increment.
$hi = $s * 100; // size in 100 pixels. (but can be any increment)
echo "
<TABLE BORDER='15' CELLPADDING='0' CELLSPACING='0'><TR><TD>
<image src='ft_image.php?imno=$image_num' BORDER=0 ALIGN='TOP' height=$hi></TD></TR></TABLE>
";
Note: in the 'image src' you give it a program name, not the image, and pass some way for it to read the image from the DB. In this case the program is ft_image.php and it passes imno.
To didplay the photo in ft_image.php, execute the following:
header("Content-type: image/jpeg");
print(mysql_result($result, 0, "photo_image"));
photo_image is name of blob field from the DB
---------------------------------
HTH.. Good luck.. Dan.
===========================================================
Andy wrote:
Hi there, I am wondering how to resize an image which is stored in a mysql blob field. With files this workes just fine, but how to do this with the image comming from blob? Has anybody done this already? Thank you for any help on that, andy