Create downloadable csv file in php

Viewed k times. You are not echoing anything thus the page will be blank only. It will just create csv for you as per your code. Add a comment. Active Oldest Votes. Baba Baba I was having issues putting header after fputcsv and once I moved them above fputcsv , I stopped having issues. Ashish Ratan 2, 20 20 silver badges 46 46 bronze badges. Buzut Buzut 4, 4 4 gold badges 41 41 silver badges 50 50 bronze badges. Definitely, that should work and even might be more appropriate.

More details here — Buzut. Then it can be done as follows I know I have added a lot of comments just for newbies : I have added an example so that you can summarize well. You have to add the following at the start of the above script. Channaveer Hakari Channaveer Hakari 2, 2 2 gold badges 28 28 silver badges 40 40 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

PHP 5. Because fputcsv can only write to file pointers, line 6 opens the output stream as if it were a file. Line 9 then outputs column headers, while line 17 loops over the rows of data and outputs them.

How it works 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. Where now? Creating a CSV file from the database is similar to what we did in our previous examples. Find the sample code below. Instead of saving on the server, you can force download the file and hence save the space on the server. Refer sample code below.

Here we start by setting proper headers and then create the CSV file. The rest of the code is the same as explained before. That is all. We hope you found this article useful.