RE: [PHP-DB] Broken Links 2 From: Rankin, Randy (randy.rankin <email protected>)
Date: 10/24/02

Thanks to everyone for the help.

For those interested, I have posted the final code below. It functions
beautifully with one exception: the resized image quality is rather poor. I
am now reading through the php manual and newsgroups for a solution, but if
anyone knows how to handle this it would be great to hear from you.

Thanks again for all your help!

Randy

--------- BEGIN CODE ------------------

<?
if( $image_id )
{
 $sql="SELECT image_bin_data from IMAGES where image_id='$image_id'";
 $result=db_query ( $sql );
 $record=db_fetch_object ( $result );
 $image=$record->image_bin_data;
 $new_w=75;
 $new_h=75;
 Header("Content-type: image/png");
 $src_img= <email protected>($image);
 $dst_img= <email protected>($new_w, $new_h);
 
ImageCopyResampled($dst_img,$src_img,0,0,0,0,$new_w,$new_h,ImageSX($src_img)
,ImageSY($src_img));
 ImagePng($dst_img);
 ImageDestroy($dst_img);
};?>

--------- END CODE ------------------