Saving file from server to client side - Automatically 1

[bobrivers2003]

I have a php script that exports all the structure and data from a mysql db, the file is saved on the server, as it is a back up of the server db I wish to download it to a client when the back up file is created.

I have tried using

Header("Content-type: application/msword");
Header("Content-Disposition: attachment; filename=backup.txt");
echo "CONTENTS OF FILE ON SERVER";

I need to open the server file, loop through each line and print to backup.txt


Does anyone have any pointers on how this can be achieved?

Many Thanks

 

[sleipnir214]

When you said

I need to open the server file, loop through each line and print to backup.txt

you were pretty close.

But it seems to me that the correct operations would be open the file, loop through each line and stream that line to the browser using print.

You're right on target. This will entail use of fopen(), fgets() and a while loop.

There is example code on the PHP online manual pages to which I have provided links.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[sleipnir214]

Oh, and I think "text/plain" is a better content-type for a .txt file than "application/ms-word".

I take it back. Better than fopen() and fgets() is readfile()



Want the best answers? Ask the best questions! TANSTAAFL!

 

[bobrivers2003]

Top stuff, it worked a treat.

Thanks for the help

 

[dkdude]

If you need to do a (serverside) copy of your file, why not use ... copy()

<?php
$server_file = 'serverfile.txt';
$backup_file = 'backup.txt';
if (!copy($server_file, $backup_file)) {
   echo "failed to copy $server_file...\n";
}
?>

Regards


Jakob