How do I put a download button on a site to get a CSV of a table Query?

Question

Currently I am using SELECT * INTO OUTFILE to make the CSV file on the server HD and is fine except...

I want to create the CSV like I am now, but I want the "OUTFILE" to be saved on the clients computer when they click Download.

<?php
// Create new file name for file to be created 
$csvfilename = "/dropbox/consolodated-" . date("Y-M-d_H-i-s") . ".csv";


mysql_query ("SELECT * INTO OUTFILE '$csvfilename' FIELDS TERMINATED BY ',' FROM people ");
?>

<H2>Done - File created - Now download it from FTP site.</H2>

You probably have a typo in `$csv-filename`. – Alix Axel Dec 24 '09 at 07:27 — Alix Axel, Dec 24 '09 at 07:27
Thanks Alix, Replaced $csv-filename with $csvfilename. – Ken Butcher Dec 28 '09 at 04:13 — Ken Butcher, Dec 28 '09 at 04:13

score 2 · Answer 1 · answered Dec 24 '09 at 07:21

2

The solution to this can be that:

First you save the csv file on to server.
then get it's path
and finally create an anchor tag with its path for download eg:

_

 <a href="pathtoyourcsvfile.csv">Download</a>

answered Dec 24 '09 at 07:21

Sarfraz

377,238
77
533
578

+1 for the simple approach, the CSV file has to be stored on a public accessible location though. – Alix Axel Dec 24 '09 at 07:26

score 0 · Answer 2 · edited May 23 '17 at 12:16

0

Here are a couple of similar posts:
Generating CSV file and then forcing the file to download.
PHP code to convert a MySQL query to CSV

edited May 23 '17 at 12:16

Community

1
1

answered Dec 24 '09 at 07:21

o.k.w

25,490
6
66
63

score 0 · Answer 3 · answered Dec 24 '09 at 07:22

Add a POST form at the end which includes a hidden field containing the filename (but NOT the path!) of the file to download. Then have the page it POSTs to read the variable and offer the file for download. Don't forget to enable output buffering and to occasionally flush so that the form is not visible until the query has completed.

score 0 · Answer 4 · answered Dec 24 '09 at 07:24

Simple, here is a sample snippet:

$csv_filename = "/dropbox/consolodated-" . date("Y-M-d_H-i-s") . ".csv";

Download($csv_filename);

And here is the download function:

function Download($path, $speed = null)
{
    if (is_file($path) === true)
    {
        set_time_limit(0);

        while (ob_get_level() > 0)
        {
            ob_end_clean();
        }

        $size = sprintf('%u', filesize($path));
        $speed = (is_null($speed) === true) ? $size : intval($speed) * 1024;

        header('Expires: 0');
        header('Pragma: public');
        header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
        header('Content-Type: application/octet-stream');
        header('Content-Length: ' . $size);
        header('Content-Disposition: attachment; filename="' . basename($path) . '"');
        header('Content-Transfer-Encoding: binary');

        for ($i = 0; $i <= $size; $i = $i + $speed)
        {
            echo file_get_contents($path, false, null, $i, $speed);

            flush();
            sleep(1);
        }

        exit();
    }

    return false;
}

Merry Xmas to you too! =)

Thanks, I have this quirky desire to fully understand what I copy and paste, so thanks to your help I am now going through the "Output Buffering Control" and "header" sections of PHP.net and it looks like this is what I am looking for. The more you know - the more you know you don't know. — Ken Butcher, Dec 28 '09 at 04:24

How do I put a download button on a site to get a CSV of a table Query?

4 Answers4