download csv file with php

Question

I have a file csv with code:

// put data to file
    $file = 'file.csv';
        $fp = fopen($file, 'w');
        foreach ($excel as $fields) {               
            fputcsv($fp, $fields);
        }

// download file when click button:

if ($this->request->getPost('cvs')) { {
    if (file_exists($file)) {
         header('Content-Type:  text/csv');
         header('Content-Disposition: attachment; filename=' . ($file));
         header('Pragma: no-cache');
         readfile('/var/www/admin/backend/public/' . $file);
         // OR readfile($file);
            }
        }

Data in file.csv (file.csv in publuc folder):

[Time,A1,A7,A30
03/24/2015,42531,130912,315805
03/25/2015,41124,132746,319098
03/26/2015,41050,134858,320934
03/27/2015,38687,134679,321747]

But when i click button to download file, data in file dowloaded is all html of page:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"  
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"">
<html xmlns=""http://www.w3.org/1999/xhtml"">...etc..

How to fix it? Thanks very much!

possible duplicate of [In php Instead of downloading csv file it gets open in the browser](http://stackoverflow.com/questions/16188329/in-php-instead-of-downloading-csv-file-it-gets-open-in-the-browser) — kkuilla, Mar 31 '15 at 08:27
see this link for download a csv file from php script. [Download cvs file from php][1] [1]: http://stackoverflow.com/questions/16251625/how-to-create-and-download-a-csv-file-from-php-script — RaMeSh, Mar 31 '15 at 08:28

score 2 · Answer 1 · answered Jul 18 '16 at 08:18

2

a bit late but I think everyone missed the phalcon tag. what is missing is the

$this->view->setRenderLevel(\Phalcon\Mvc\View::LEVEL_NO_RENDER);

answered Jul 18 '16 at 08:18

zam3858

163
7

This helped me. Thank you – dars33 Sep 29 '16 at 21:16

score 2 · Answer 2 · answered Sep 29 '16 at 12:57

Here is my way to handle this.

$this->response->resetHeaders();
$this->response->setHeader('Content-Type', 'application/csv');
$this->response->setHeader('Content-Disposition', 'attachment; filename='.$fileName);
$this->response->setContent($content);
return $this->response;

$content - For me it is a string made from array but you can also use file_get_contents()

score 0 · Answer 3 · answered Mar 31 '15 at 08:24

I would need more information to answer with certainty, but it sounds like the browser is simply configured to save this type of download as html. Try using another browser or even better use an FTP client to get the file so the browser is not a factor.

If you would like to continue to use the browser, try doing the following instead of just clicking the link:

Put the mouse over the link and then right click. If you have an option to "save as" save the file as a .csv. It may automatically select .csv for you if you choose save as.

score 0 · Answer 4 · answered Mar 31 '15 at 08:25

0

use content/Type as,

header('Content-Type: application/csv');

instead of header('Content-Type: text/csv');

answered Mar 31 '15 at 08:25

US-1234

1,519
4
24
61

Thanks for your helping. I used header('Content-Type: application/csv'); but it still not working! – Ilu Mar 31 '15 at 08:34

score 0 · Answer 5 · answered Mar 31 '15 at 09:14

You can also use the below two lines 

header("Content-type: text/x-csv");
header("Content-type: application/csv");

If you want to set any particular file name to the download file then you can add 

header("Content-Disposition: attachment; filename=dates_for_".date('dMy').".csv");

download csv file with php

5 Answers5