How to save blob data to hard disk?

faheem786

Hi,

I have stored my document files in a blob field (mysql)

I know how to allow users to download the file manually one by one

But I want to loop through the whole table and export the blob data as files and store it in hard disk

How to do this?

Thanks a lot for your help

Faheem
Hong Kong

Andrew_W_Peace

Do you mean you want to loop through your database and take all the blobs of data and save them into files? Into one file or seperate ones? Also, do you mean save on your server or save to the user's HD?

faheem786

Yes.

I want to loop through the table which has got the blob data and export them as seperate files. It happens on the Server side not the client side

The reason for this is because I have upload the files to another server periodically using PHP - FTP

Thanks
Ahmad

Andrew_W_Peace

That's an easy one. Do something like this:

//select the data i want
$query = "SELECT `myblob` FROM `mytable`";

//get the result from the above query
$result = $mysql_query($query);

//first filename will be 1.txt
$filename = 0;

//keep looping through the result to get all the data
while($array = mysql_fetch_array($result))
{
	//set the next filename
	$filename++;

//create the file and open for writing
$handle = fopen($filename.".txt", 'x');

//write the blob to the file
fwrite($handle, $array['myblob']);

//close the file handle
fclose($handle);
}

Something like that :p. Hope this helps

faheem786

Thanks a lot Andrew for your help.

I will test this and see how it works

Thanks again