Write data from a CSV to Array to new CSV

Question

I am trying to extract data from a CSV, run a function on some of it and spit it out into a new CSV. I'm getting stuck and writing the data to an array properly. Also, the file is created but its empty.

PHP

$file = fopen("yahrzeit-3.csv","r");

if ($file) {
  while ( ( $row = fgetcsv( $file, ";" ) ) !== false ) { // 3

  $data .= array ( $row[2], $row[3], $row[6], $row[7], $row[8], $row[14] );

}
print_r($data);
$fp = fopen('mailchimp.csv', 'w');

foreach ($data as $fields) {
    print $subfields;
    fputcsv($fp, $fields);
}
fclose( $fh ); // 5

}

fclose($fp);

Mark Baker · Accepted Answer · 2014-08-11 16:48:04Z

1

$file = fopen("yahrzeit-3.csv","r");

if ($file) {
    $fp = fopen('mailchimp.csv', 'w');
    if (!$fp) {
        die('Cannot open output file');
    }
    while ( $row = fgetcsv( $file, ";" ) ) {
        $data = array ( $row[2], $row[3], $row[6], $row[7], $row[8], $row[14] );
        fputcsv($fp, $data);
    }
    fclose( $fp );
}
fclose($file);

is a lot more memory efficient than what you're trying to do

answered Aug 11, 2014 at 16:48

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

BA_Webimax · Accepted Answer · 2014-08-11 16:46:47Z

0

$data .= array ( $row[2], $row[3], $row[6], $row[7], $row[8], $row[14] );

should be

$data[] = array ( $row[2], $row[3], $row[6], $row[7], $row[8], $row[14] );

You are setting $data as a string and trying to cram an array into it.

answered Aug 11, 2014 at 16:46

BA_Webimax

2,6871 gold badge16 silver badges15 bronze badges

Collectives™ on Stack Overflow

Write data from a CSV to Array to new CSV

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related