Hello all.
Im quite new to php and have a problem i hope you can help me with. Below i
have a copy of my code which i use for users to upload aviation photos to my
server.
First it uploads the photo and then copies it to a directory on my server.
Then it adds all the relevant data into the mysql database.
<?
include "header.inc";
$img_location = "aviation/uploads/$image_name";
if ($image_name != "") {
// exec("$CJPEG $image_name | $PNMSCALE -width 128 | $CJPEG -outfile >
$thimagefile");
// exec("$DJPEG $imagename > t.pnm");
// exec("$PNMSCALE -width 128 t.pnm > t2.pnm");
// exec("$CJPEG -outfile t3.jpg t2.pnm");
// exec("I:\Perl\bin\cjpeg.exe -quality 30 -progressive $image_name");
// exec("c:/autobatchit!/autobatchit.exe");
// exec("jpegtools/cjpeg.exe");
exec("convert.exe -geometry 600 $img_location $img_location");
copy("$image", "../aviation/uploads/$image_name") or die ("Couldn't copy the
file.");
} else {
die("You forgot to add a filename. Please click the back button and try
again.");
}
$db = mysql_connect("$user", "$password") or die("Can't connect to
server.");
mysql_select_db("database", $db) or die("Can't select database.");
$insert_data = "INSERT INTO table (image_name, image, name, email, country,
airfield, rego, remarks, airline, date, month, year, allfields) VALUES
('$image_name', $URL, $image_name', '$name', '$email', '$country',
'$airfield', '$rego', '$remarks', '$airline', '$date', '$month', '$year',
'$name')";
$update_rego = "update images set allfields = concat(allfields, ' $rego')";
$update_email = "update images set allfields = concat(allfields, '
$email')";
$update_country = "update images set allfields = concat(allfields, '
$country')";
$update_remarks = "update images set allfields = concat(allfields, '
$remarks')";
$update_image_name = "update images set allfields = concat(allfields, '
$image_name')";
$update_airline = "update images set allfields = concat(allfields, '
$airline')";
$update_date = "update images set allfields = concat(allfields, ' $date')";
$update_month = "update images set allfields = concat(allfields, '
$month')";
$update_year = "update images set allfields = concat(allfields, ' $year')";
mysql_query($insert_data) or die("Couldn't insert data.");
mysql_query($update_rego) or die("Couldnt Update Rego.");
mysql_query($update_email) or die("Couldnt Update Email.");
mysql_query($update_country) or die("Couldnt Update Country.");
mysql_query($update_remarks) or die("Couldnt Update Remarks.");
mysql_query($update_image_name) or die("Couldnt Update Image.");
mysql_query($update_airline) or die("Couldnt Update Airline.");
mysql_query($update_date) or die("Couldnt Update Date.");
mysql_query($update_month) or die("Couldnt Update Month.");
mysql_query($update_year) or die("Couldnt Update Year.");
exec("echo File has been uploaded! Filename is $URL $img_location.
Uploader's name is $name . Email Address is $email. Airline is $airline.
Country is $country. Date taken is $date of $month, $year. Registration is
$rego. Remark is $remarks. | blat - -s \"$image_name uploaded --\" -f
$from_email -t $to_email");
?>
All of it works wonderfully (according to a novice) except the image
maipulation stuff. What i want to do it have the image resized to 600 pixels
(maintaining ratio) and add just a touch of compression to bring te file
size down a little.
as you can see i have put the line:
exec("convert.exe -geometry 600 $img_location $img_location"); Im using
imagemagick at this point to try and get the desired outcome.
in before it copies the file to the directory. However this results in
absolutely nothing being executed. The rest of the script still works fine,
but none of the "convert" stuff looks like it ever registers. If i look at
the task manager on NT, nothing comes up to do with 'convert'.
I know convert is in the path, because if i go to the NT machine and just
type convert at the command prompt, it works fine.
Can anyone tell me what i am doing wrong here.?....i have tried a lot of
different things as you can see and nothing seems to work.
My configuration is: WindowsNT4 sp6, iis4, php4.
Thanks in advance guys and i hope i have posted this to the right group.
Regards
Dave
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
