exec/mogrify problem

jasonmartin

I am trying to reduce the size of image's being uploaded into our database. Everything works fine, so I am just trying to add ImageMagick's mogrify option via the exec command.

The code runs but when I go to display the image, it doesn't display (It displays fine if I don't try to use the mogrify command via the exec function.

Below is my working code & below that is what I have modified to try to get this to work; no luck yet.

Working code

$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));

New code utilizing mogrify via the exec command

$data = exec("mogrify -density 72x72 -geometry 200x200! ".(addslashes(fread(fopen($form_data, "rw"), filesize($form_data)))));

I've also tried the following:

$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));

$data2 = exec("mogrify -density 72x72 -geometry 200x200! ".$data);

Neither way works.

Any help would be greatly appreciated.

Thanks,

Jason Martin

Anon

Your problem lies in the exec() call. exec() does not print anything except for the last line of the program's output. Try system() instead.

-Chris

jasonmartin

I tried replacing exec with system in both instances & I got the same results.

Any help would be greatly appreciated.

Jason Martin

Anon

What is being passed as $form_data? Is it the name of a file? If so, it looks like you are taking the contents of the file and trying to pass it on to the mogrify command as a parameter. I dont know how that program works but you should probably run "mogrify -params < $data" or "mogrify -params filename".

-Chris

jasonmartin

$form_data is the actual image itself. I've tried changing it to $form_data_name, which is the filename of the image, but I get the same results.

ImageMagick's mogrify works like this from the command line:

mogrify -density 72x72 -geometry 200x200! image_name.jpg

This reduces this file's size from 18k to 6k.

From the man page:

mogrify [options...] file

Thanks,

Jason Martin

Anon

I downloaded mogrify, and one thing I cant figure out is how to get it to print the result to stdout. I can get it to take input, but the only way it would print its results was in a random file in /tmp or replace an image. I found 'fmogrify', a small script that gets mogrigy to print to stdout.

http://project802.net/test/index.php (takes gif files) is the example

http://project802.net/test/index.phps is the source

http://project802.net/test/fmogrify is the shell script you need

I'll delete these in a weeks time.

-Chris

jasonmartin

Thanks for all your help Chris. I tried your scripts, but the weird thing is when I go to
http://project802.net/test/index.php & pick an image & hit the mogrify button it works.

But, if I try to do another image after that, it just keeps displaying the first image I did. Even if I refresh the page it does the same thing. The only way to get to do another image, is to open another browser & go to the page again.

By the way, I forgot to mention that the point of changing this image is obviously so I can display a smaller version on a web page, but I am storing the images in a MySQL database; do you think the code you gave me will work with me inserting the image into the database.

Thanks,

Jason M

cvincent

Yea, just instead of loading the image to the file, have it dump the output into $data and insert $data into the database. Uncomment the second exec() I have, comment out the first one plus the lines below it and then run an sql query like "INSERT INTO images VALUES('$name', '$data')"

The image doesnt appear to change because of browser cache, using internet explorer?

-Chris

jasonmartin

Still can't get it to work. Below is what I have in my code including the database insert. I've also tried uncommenting the $data line.

If I uncomment the $data line, when I try to display the image, it displays the words 'Array'. If I comment out the $data line it displays the image from the database, but it never was formatted. I created the fmogrify in the same bin directory as mogrify & granted the same permissions (755).

Chris, once again thanks for your help on this!

Jason

if(isset($submit)) {

MYSQL_CONNECT("localhost","nobody","");
mysql_select_db("db");

exec("cat \"$submit\" | fmogrify -density 72x72 -geometry 200x200! - 2>/dev/null", $data);

//$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));

$result=MYSQL_QUERY("INSERT INTO employees (name,title,bin_data,filename,filesize,filetype) "."VALUES ('$name','$title','$data','$form_data_name','$form_data_size','$form_data_type')");

$id= mysql_insert_id();