Help With Picture Downsize After Image Upload

Anon

Howdy Everyone! We are beginners at this, and have finally got our picture uploader to work. Now we just need to adjust it slightly so the picture is downsized to fit into our inventory page. Please though, no references back to the manual or instructions we can’t understand. 🙂

The Add Record section is divided into two sections, the form page and the executable page. I have included the script for both of them below. Please let us know where we would add the additional script, what it would consist of, and any errors we might encounter in doing so. The picture should be approximately 350 X 230.

Thanks a million for your help!

FIRST SCRIPT

Picture<br>

<?php

if ($submit) {

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

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

copy($pic, "/httpd/realapplications/pics/$filename");

mysql_query("INSERT INTO pics (filename) VALUES ('$filename')") or die
(mysql_error());

echo "temp file: $pic<br>\n";
echo "file name: $filename<br>\n";
echo "file size: $filesize<br>\n";
echo "file type: $filetype<br>\n";
echo "<br>\n";
echo "<img src=images/$filename><br>\n";
}

</center>

</body>

SECOND SCRIPT

if ($submit) {
$connection = mysql_connect("**", "", "***")
or die ("Couldn't connect to server.");

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

copy($pic, "/httpd/realapplications/html/pics/$filename");

$filesize=filesize($pic);
$filetype=filetype($pic);

mysql_query("INSERT INTO boom_lifts VALUES
('$size', '$year', '$manufacturer', '$description', '$price', ' ',
'$model', '$filename', '$filesize', '$filetype')") or die (mysql_error());

echo "<table cellspacing=5 cellpadding=5>";

echo "<tr><td valign=top><strong>Size:</strong></td><td
valign=top>$size</td></tr>";

echo "<tr><td valign=top><strong>Year:</strong></td><td
valign=top>$year</td></tr>";

echo "<tr><td valign=top><strong>Manufacturer:</strong></td><td
valign=top>$manufacturer</td></tr>";

echo "<tr><td valign=top><strong>Model:</strong></td><td
valign=top>$model</td></tr>";

echo "<tr><td valign=top><strong>Item Description:</strong></td><td
align=top>$description</td></tr>";

echo "<tr><td valign=top><strong>Price:</strong></td><td valign=top>\$
$price</td></tr>";

echo "<tr><td valign=top><strong>File Name:</strong></td><td
valign=top>$filename</td></tr>";

echo "<tr><td valign=top><strong>Picture:</strong></td><td valign=top><img
src=../../pics/$filename></td></tr>";

echo "</table>";

}

<a href=\"index.html\">Return to Menu</a>

</body>

Anon

Well, unless you have compiled PHP with the GD libraries (the code used to manipulate images) the only thing you will be able to do is expicitly declare the width and height of the image in the <img> tag to be exactly what you want, and let the browser resize it.

If you do have the GD libraries installed (which do not come with the default installation, so I'm doubting it) you can email me and I can give further instructions. Hope that helps!

Chris King

Anon

assuming you are on a gnu/linux system, take do a 'man -k ppm' to find all the ppm programs on there. There's a slew of xxx2ppm ppm2xxx type programs available that you can run from the command line (i.e. use exec() to run from php) and do the conversion.

Also, look for cjpeg, djpeg for converting ppms into and out of jpges.

also, libgd has some nice functions (and it too is included in most newer linux distros) that you can access with php's built in libgd interface.

Anon

ImageMagick is another choice!! It's installed by default on Redhat. You can resize, crop, adjust contrast, and more with one of the binary called "mogrify". You even can create thumbnails on a whole directory. Check it out... 🙂

Anon

Chris, please help me with this question. If I have GD lib, then what I should doing ?

Anon

If you have the GD library, and you want to specify a specific height, width, first you want to do:

$filename = "path/to/image";
$dst_img = ImageCreate(100, 100);
$src_img = ImageCreateFromJPG($filename);
ImageCopyResized($dst_img, $src_image, 0,0,0,0,100,100,ImageSX($src_image),ImageSY($src_image));

ImageJPG($dst_img, $filename);

Now remember, you can only do this with JPG or PNG files in the new GD libraries, if you need more information on these functions, look at

http://www.php.net/imagecopyresized

http://www.php.net/imagecreate

http://www.php.net/imagecreatefromjpg

http://www.php.net/imagejpg

Hope that helps!

Chris King