下载上传到mysql的文件到服务器目录

Question

I've searched and searched but have not found a script capable of downloading files which are uploaded to my mysql database down to a directory in my server. This is only temporary and once the file has been used it'll need to be disposed of. Got any ideas?

Answer 1

I suppose you meant that the file is saved into mysql database like BLOB (binary data)

$result = mysql_query("select * from tablename where id=XXXX");
     if (mysql_num_rows($result)>0){
     $r = mysql_fetch_array($result,MYSQL_ASSOC);
     file_put_contents($filename,$r['column_blob']);  
   }

I used file_put_contents function that it is binary safe, but there is also fwrite