Php generate csv file to download

The strings on lines 12 to 14 should be changed to the appropriate connection parameters and query string for your database. In a real application the database connection parameters should be defined as constants in a separate configuration file. The code needs to tell the browser that it is producing a CSV file and that the file should be offered for download, rather than displayed in the browser. The Content-Disposition header was defined in RFC and was intended to be used in e-mails, but was also adopted by web browsers.

Rossana Ferreira. Rossana Ferreira Rossana Ferreira 1 1 1 silver badge 2 2 bronze badges. I can't reproduce the problem. When I run that code, in the current version of Chrome, a CSV file is downloaded to my default downloads folder. Thank you Quentin. After your reply I tried the php code alone and it did work. I have some other problem that won't let the download inside my web app. Maybe because I use headers prior to this. Add a comment. Active Oldest Votes. You can use below code to save file in server fopen "filename.

Lalmani Dewangan Lalmani Dewangan 1 1 silver badge 10 10 bronze badges. Thank you, yes, that would be an option. I just found out my mistake. Please share it on social media if you like it. Post a Comment. Let's see how to do it. No comments:. Newer Post Older Post Home. Skip to content Automatically downloading a CSV file with PHP takes a particularly different structure of code that would be present in the general creation of files. Setting the header function Setting the headers of the HTTP request is of extreme importance when downloading files automatically.

The Author: Dan Englishby.