在PHP中更改csv文件中的列标题名称和重新排序列

Question

I have a CSV file and I want, via PHP, to change columns header names and reorder columns.

I tried this but this wont work for me:

function toCSV($data, $outstream) {
    if (count($data)) {
        // get header from keys
        fputcsv($outstream, array_keys($data[0]));
        // 
        foreach ($data as $row) {
            fputcsv($outstream, $row);
        }
    }
}

Answer 1

I found the some kind fo solution This will remove first row with columns names and put it in new csv file and add new columns names in the old one.

$old_file = 'X.csv';
$new_file = 'testdata_new.csv';

$file_to_read = file_get_contents($old_file);  // Reading entire file
$lines_to_read = explode("
", $file_to_read);  // Creating array of lines

if ( $lines_to_read == '' ) die('EOF'); // No data 

$line_to_append = array_shift( $lines_to_read ); // Extracting first line 

$file_to_append = file_get_contents($new_file);  // Reading entire file

if ( substr($file_to_append, -1, 1) != "
" ) $file_to_append.="
";  // If new file doesn't ends in new line I add it

// Writing files
file_put_contents($new_file, $file_to_append . $line_to_append . "
");
file_put_contents($old_file, implode("
", $lines_to_read));



  $header = "here write the names  
";
  $data = file_get_contents($old_file);
  file_put_contents($old_file, $header.$data);