Convert array into csv

by

I’m using the following function for that; it’s an adaptation from one of the man entries in the fputscsv comments. And you’ll probably want to flatten that array; not sure what happens if you pass in a multi-dimensional one.

/**
  * Formats a line (passed as a fields  array) as CSV and returns the CSV as a string.
  * Adapted from http://us3.php.net/manual/en/function.fputcsv.php#87120
  */
function arrayToCsv( array &$fields, $delimiter=";", $enclosure=""", $encloseAll = false, $nullToMysqlNull = false ) {
    $delimiter_esc = preg_quote($delimiter, "https://stackoverflow.com/");
    $enclosure_esc = preg_quote($enclosure, "https://stackoverflow.com/");

    $output = array();
    foreach ( $fields as $field ) {
        if ($field === null && $nullToMysqlNull) {
            $output[] = 'NULL';
            continue;
        }

        // Enclose fields containing $delimiter, $enclosure or whitespace
        if ( $encloseAll || preg_match( "/(?:${delimiter_esc}|${enclosure_esc}|\s)/", $field ) ) {
            $output[] = $enclosure . str_replace($enclosure, $enclosure . $enclosure, $field) . $enclosure;
        }
        else {
            $output[] = $field;
        }
    }

    return implode( $delimiter, $output );
}

More Related Contents:

  1. Split a comma-delimited string into an array?
  2. How to create an array from a CSV file using PHP and the fgetcsv function
  3. php implode (101) with quotes
  4. CSV to Associative Array
  5. Create a comma-separated string from a single column of an array of objects
  6. Process CSV Into Array With Column Headings For Key
  7. Isolate comma-separated values, remove duplicates and empty values, then sort
  8. Prevent creating duplicate entries in PHP
  9. Display multidimensional array in php
  10. Sum up array values [closed]
  11. Is there any array function by which I can get the expected result? [duplicate]
  12. Convert php array to Javascript
  13. Convert a PHP object to an associative array
  14. PHP Sort a multidimensional array by element containing Y-m-d H:i:s date
  15. PHP in_array() / array_search() odd behaviour
  16. How to check whether an array is empty using PHP?
  17. How is the PHP array implemented on the C level?
  18. MySQLi Bind Param with an array for IN [duplicate]
  19. Search for PHP array element containing string [duplicate]
  20. Merge two arrays containing objects and remove duplicate values
  21. Deep recursive array of directory structure in PHP
  22. String contains any items in an array (case insensitive)
  23. Reverse array in php
  24. Find number which is greater than or equal to N in an array
  25. How does array_diff work?
  26. Change array key without changing order
  27. Moving array element to top in PHP
  28. phpexcel Allowed memory size of 134217728 bytes exhausted [duplicate]
  29. Check if all values in array are the same
  30. PHP, pass array through POST

Leave a Comment