write image to file from MySQL

[frans-jan]

Hi,

I got a MySQL table with about 2000 images stored in longblobs
What I want is to write those images back to files. I got a piece of code to get the pictures on screen, but the picture wil have the php documents name.

My guesses are to use fwrite in some way, but to use that I need to give every file a unique name (the id)

Here's my display code

if (mysql_num_rows ($result)) {
$foto = mysql_fetch_array ($result);
header ("Content-type: ".$foto["mimetype_foto"]);
if (isset ($thumb))
echo $foto["thumbnail"];
else
echo $foto["foto"];

Anybody?

Thanks!

[[deleted]]

You should be able to just use fopen() to open a new file and use the ID as a name, and then just print the content of $foto["foto"] and close the file again.

[Anon]

Yes that Works!

fopen() a file that doesn't excist makes a new one!

fwrite()
and
don't forget to fclose()

Thanks!