Hi Tedd,
Dynamic Thumbnail generation:
http://www.weberdev.com/ViewArticle-388.html
On 1/28/06, tedd <[EMAIL PROTECTED]> wrote:
>
> Hi:
>
> I'm trying to create a thumbnail from a jpeg stored in a long blob in
> mySQL.
>
> What's wrong here? I get an image that's the correct size, but it's black.
>
> Any ideas?
>
> Thanks.
>
> tedd
>
> <code>
>
> $dbQuery = "SELECT image_type, image, image_width, image_height ";
> $dbQuery .= "FROM pictures ";
> $dbQuery .= "WHERE image_Id = $pic_id";
> $result = mysql_query($dbQuery) or die("Couldn't get file list");
>
> if(mysql_num_rows($result) == 1)
> {
> $fileType = @mysql_result($result, 0, "image_type");
> $fileContent = @mysql_result($result, 0, "image");
> $width_orig = @mysql_result($result, 0, "image_width");
> $height_orig = @mysql_result($result, 0, "image_height");
>
> // Set a maximum height and width
> $width = 200;
> $height = 200;
>
> if ($width && ($width_orig < $height_orig))
> {
> $width = ($height / $height_orig) * $width_orig;
> }
> else
> {
> $height = ($width / $width_orig) * $height_orig;
> }
>
> // Resample
> $image_p = imagecreatetruecolor($width, $height);
> $image = imagecreatefromjpeg($fileContent);
> imagecopyresampled($image_p, $image, 0, 0, 0, 0, $width, $height,
> $width_orig, $height_orig);
>
> // Output
> imagejpeg($image_p, null, 100);
> }
>
> </code>
> --
>
>
