Help with Thumbnails

[newtothis]

This is a script for creating a thumbnail image of a jpg.

<?

// WIDTH TO RESIZED TO
$new_w=100;
// HEIGHT TO BE RESIZED TO
$new_h=100;

header("Content-type: image/jpeg");

$dst_img=ImageCreate($new_w,$new_h);

$src_img=ImageCreateFromJpeg("../images/farms.jpg");

ImageCopyResized($dst_img,$src_img,0,0,0,0,$new_w,$new_h,ImageSX($src_img),ImageSY($src_img));

ImageJpeg($dst_img);
ImageDestroy($dst_img);
ImageDestroy($src_img);

?>

The only problem is it skews the image since it specifies the new image as 100 pixels by 100 pixels. I would like to constrain the proportions of the height OR the width. Is there a wildcard I can use in the $new_h=* or in the $new_w?

I realize this is a basic question but I truly am a newbe 😉 Thanks for any help!

[monkey]

Looks like you might be able to use www.php.net/imagesx and www.php.net/imagesy

[newtothis]

Thanks...that lead me to find a better code since I had a better search phrase. Please forgive my newness to php and to programming but I have another question. Here is the code I now have and it works very well.

<?

$src_img = imagecreatefromjpeg("pic.jpg");
$new_w = 175;
$new_h = imagesy($src_img) / ( imagesx($src_img) / $new_w );

$dst_img = imagecreate($new_w,$new_h);
imagecopyresized($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img));

Header("Content-Type: image/jpeg");
imagejpeg($dst_img, '', 65);

?>

I now need to make the pic.jpg be a variable such as $filename and draw from the database. How do I bring this into my page? The script it is going into is as follows:

<?

    $sql = "SELECT * FROM pics WHERE id = \"$id\"";

    $sql_result = mysql_query($sql,$connection)
            or die("Couldn't execute query.");

    if (!$sql_result) {  
            echo "<P>Couldn't get item!";

} else {

    $list = mysql_fetch_array($sql_result);
    $id = $list["id"];
    $filename = $list["filename"];
    $filetype = $list["filetype"];
    $filesize = $list["filesize"];
    $active = $list["active"];

echo "

<img src=http://www.domainname.com/pics/$pic.php>";

}

?>

Any help would be greatly appreciated.

[robsy]

I don't know if you solved your problem with exstracting filenames from a database you probably did since your posting was back in february. I reused the code you made for creating jpeg images and added some functionality to get the files from a database, the only trouble I have is that the content-type doesn't seem to work. My pictures come out as garbled text instead of an image. I am using IE 5.5 and a windows distribution of apache,php4 and mysql.
It looks like the mime types are correct declared in the mime file.
If anyone has any solution as to why the pictures come out as text please respond.
I will include my code on request though I warn you it's not pretty

[newtothis]

The following worked for me. I had to put the $connection in or it wouldn't work. Please keep in mind that I am still a newbe to this and my scripts are very basic but they do work in the end 😉 Good luck!

<?

$connection = mysql_connect("localhost", "name", "passwd")
	or die ("Couldn't connect to server.");

$db = mysql_select_db("databasename", $connection)
	or die ("Couldn't select database.");

Header("Content-Type: image/jpeg");

$sql = "SELECT * FROM dbfield WHERE id = '$id'";

$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query.");

$list = mysql_fetch_array($sql_result);
$filename = $list["filename"];

$src_img = imagecreatefromjpeg("../path/folder/$filename");
$new_w = 175;
$new_h = imagesy($src_img) / ( imagesx($src_img) / $new_w );

$dst_img = imagecreate($new_w,$new_h);
imagecopyresized($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img));

imagejpeg($dst_img, '', 65);

?>