fwrite an image from mysql to a file

Anon

I want to write an jpg-image from a mysql result to a file on disk.

How can i do this??

This is NOT working....
$tmpfile="/tmp/tmpfile.jpg";
fp = fopen($tmpfile,"w");
fwrite($fd,$image);
fclose($fp);

Please help me.

Thanks

Terje

brandonschnell

you have some typos in there:

$tmpfile="/tmp/tmpfile.jpg";
$fp = fopen($tmpfile,"w");
fwrite($fp,$image);
fclose($fp);

kparker

You don't say what platform you're using. On *nix, what you have should actually be ok, but on Windows you need use "wb" (write-binary) for your file-open mode.

Another thing you don't say is exactly how this is failing. Saying "This is not working" is exactly like going to the doctor and saying, "I'm sick." Please tell us what is happening.

Anon

My configuration is :
Linux 7.0 with kernel 2.4.3
Apache 1.3.19
PHP 4.0.4pl1
MySQL 3.23.36

I want to write $image to a file. This a variable from a tinyblob in my database with an image.
This is the message from the script :
"Supplied argument is not a valid File-Handle resource".

kparker

Ah. That's easy--when you said:

$tmpfile="/tmp/tmpfile.jpg";
fp = fopen($tmpfile,"w");

the file named in the variable $tmpfile either doesn't exist, or you don't have the rights to open it for writing, so the call to fopen() fails, returning a magic value that means "not a valid file handle".

In other words (don't know how I missed this) you should really be saying:

if ($fp = fopen(...))
  {
  // write something to the file
  }
else
  echo "Can't open file";