export reports as .csv file in browsers computer

[beginner]

Hi all,

I had generated backend reports as tables. now i have to give the option to export that table. Already im using manual code to export data as .csv file . But the pbm is, this report is getting stored in server itself ( same folder where the code is). but i need some code to save file in client (user ) mechine.
some one plz help.

[DavidAllen]

Hi
It is actually surprisingly easy to do

header( "Content-type: application/octet-stream");
header( "Content-disposition:  attachment; filename=My.csv"); 

echo out the above and then just echo the csv file contents and hey presto - one csv (called My.csv) will be downloaded to the users computer


Hope this helps

[beginner]

Ya its woking fine. thanks for help...
But, one more problem,is


Generally, the popup will ask us three option ==> open, save, cancel.
But this popup asks ==> Find, save, Cancel

Why ? Can u explain me plz !

[DavidAllen]

Generally, the popup will ask us three option ==> open, save, cancel.
But this popup asks ==> Find, save, Cancel

Why ? Can u explain me plz !

Think it's because there is no program associated with .csv files on your computer. if you set .csv to always open with Excel or notepad (or whatever program you want) then the find option will change to 'Open'

Regards

[beginner]

Great, thanks for help