How to create and download a csv file from php script?

by

You can use the built in fputcsv() for your arrays to generate correct csv lines from your array, so you will have to loop over and collect the lines, like this:

$f = fopen("tmp.csv", "w");
foreach ($array as $line) {
    fputcsv($f, $line);
}

To make the browsers offer the “Save as” dialog, you will have to send HTTP headers like this (see more about this header in the rfc):

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

Putting it all together:

function array_to_csv_download($array, $filename = "export.csv", $delimiter=";") {
    // open raw memory as file so no temp files needed, you might run out of memory though
    $f = fopen('php://memory', 'w'); 
    // loop over the input array
    foreach ($array as $line) { 
        // generate csv lines from the inner arrays
        fputcsv($f, $line, $delimiter); 
    }
    // reset the file pointer to the start of the file
    fseek($f, 0);
    // tell the browser it's going to be a csv file
    header('Content-Type: text/csv');
    // tell the browser we want to save it instead of displaying it
    header('Content-Disposition: attachment; filename="'.$filename.'";');
    // make php send the generated csv lines to the browser
    fpassthru($f);
}

And you can use it like this:

array_to_csv_download(array(
  array(1,2,3,4), // this array is going to be the first row
  array(1,2,3,4)), // this array is going to be the second row
  "numbers.csv"
);

Update:
Instead of the php://memory you can also use the php://output for the file descriptor and do away with the seeking and such:

function array_to_csv_download($array, $filename = "export.csv", $delimiter=";") {
    header('Content-Type: application/csv');
    header('Content-Disposition: attachment; filename="'.$filename.'";');

    // open the "output" stream
    // see http://www.php.net/manual/en/wrappers.php.php#refsect2-wrappers.php-unknown-unknown-unknown-descriptioq
    $f = fopen('php://output', 'w');

    foreach ($array as $line) {
        fputcsv($f, $line, $delimiter);
    }
}

More Related Contents:

  1. printing a new line in a csv file cell
  2. How do I send a POST request with PHP?
  3. How to search by key=>value in a multidimensional array in PHP
  4. Print numeric values to two decimal places
  5. HTML Element Array, name=”something[]” or name=”something”?
  6. Remove index.php From URL – Codeigniter 2
  7. Replace last occurrence of a string in a string
  8. Is include()/require() with “side effects” a bad practice?
  9. Find out which class called a method in another class
  10. Posting array from form
  11. cURL download progress in PHP
  12. How can I get PHP to produce a backtrace upon errors?
  13. New CSRF token per request or NOT?
  14. Handling plupload’s chunked uploads on the server-side
  15. Get DIV content from external Website
  16. How do you use IN clauses with mysqli prepared statements [duplicate]
  17. Turn off deprecated errors in PHP 5.3
  18. Pass a PHP variable to a JavaScript variable
  19. Why I am getting an error when using w3school tutorial? [duplicate]
  20. What is null coalescing assignment ??= operator in PHP 7.4
  21. mysql_escape_string VS mysql_real_escape_string
  22. adding 30 minutes to datetime php/mysql
  23. Natural ORDER in Laravel Eloquent ORM
  24. How to use echo inside echo
  25. using header() to rewrite filename in URL for dynamic pdf
  26. PHP – Create simple animated GIF from two JPEG images? [closed]
  27. Add a quantity field to Ajax add to cart button on WooCommerce shop page
  28. How to remove /public/ from a Laravel URL
  29. Why does index.html have priority over index.php?
  30. Changing a global variable from inside a function PHP

Leave a Comment