any suggestion to this?

cody7

I have a program that is saving my MySQL database to an excel file.

I have seen most of the code in doing this but they are using

<?
header("Content-Type: application/$file_type");
header("Content-Disposition: attachment; filename=myFile.$file_type");
header("Pragma: no-cache");
header("Expires: 0");
?>

and this code prompt the user to open or to save the excel file.

my question is

I want to save the excel file in a predefined folder (e.x. "/excel") w/o asking the user to save it.

Thanks for any help....

bpat1434

Just for clarification:

You want to export your mySQL database to an excel file, which will automatically be downloaded to the users machine, in a pre-determined folder, but they don't have to click "Ok" to download it?

SECURITY!!

I think you just want to define what folder to put the file in, right?

Not sure if that's 100% possible via PHP. I'm not too sure, but I haven't seen anything around that does it.

Only reason I say this is:
Google turns up nothing, AND there's no guarantee that each user will have the same folder.

~Brett

cody7

ups sorry i mean this program will only be use in the server and no one can access this program. so everytime i use this program i will export my database in an excel file.

When i run the script it automatically export the database content to an excel file and will be stored in a local folder in the server.

I use this code located at

http://fundisom.com/phpsnippets/snip/databases/mySQL_to_excel

and this code prompt me where to save the excel file, what i want my program to do is it automatically save the excel file on a local folder.

Weedpacket

If you want to save it on the server, then you don't want to be sending it to the client.

Have a look at PHP's [man]filesystem[/man] functions.