Add a second column in existing CSV using PHP

Question

I create a CSV file with one column using PHP. I do that iteratively in a loop. What I want now is to add a second column inside this CSV. I want to that after the end of the loop. Is it possible doing this with php?

for ($number = 1; $number <= 26; $number++) {
  #create CSV With one column
}

#append one more column to existing CSV

You will need to open the file, read in each line, append to the end of each line, and write to a new file. It is simply too difficult to append to the end of each line inside the same file. But... you could just keep it all in memory and write the file once you are done - a much better design. — kainaw
– kainaw, Commented Jul 6, 2015 at 14:23
Or create a temporary file, then read that and add a new column, write to final file, delete temp file. So many possibilities. :) — OIS
– OIS, Commented Jul 6, 2015 at 14:27
why not build both columns at the same point? Once you've written out as csv, it's just a huge blob of text as far as PHP is concerned. you'd have to RE-read the entire file, line-by-line... — Marc B
– Marc B, Commented Jul 6, 2015 at 14:27

n-dru · Accepted Answer · 2015-07-06 14:31:23Z

5

You can do it this way:

$a = file('csv.csv');// get array of lines
$new = '';
foreach($a as $line){
    $line = trim($line);// remove end of line
    $line .=";new column";// append new column
    $new .= $line.PHP_EOL;//append end of line
}
file_put_contents('csv.csv', $new);// overwrite the same file with new data

answered Jul 6, 2015 at 14:31

n-dru

9,4402 gold badges31 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

Add a second column in existing CSV using PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related