PHP open csv and save data to new csv

Question

I need to replace a lot of data in csv and after changing all things i want it saved to a new csv file. i can read the csv with the code from php.net but i can't get it to work saving the new file. i have this

  $row = 0;
  if (($handle = fopen("original.csv", "r")) !== FALSE) {
  while (($data = fgetcsv($handle, 20000, ";")) !== FALSE) {
    $num = count($data);
    $cat_alt = ['cold', 'hot', ... and so on...];                                                            
    $cat_neu = ['kalt', 'heiß', ...und so weiter...];

    echo "<p> $num Felder in Zeile $row: <br /></p>\n";
    $row++;
    for ($c=0; $c < $num; $c++) {
        $output = str_replace($cat_alt, $cat_neu, $data[$c] . "<br />\n");
        echo $output;


     }         
   }  
 }

   $fp = fopen('changed.csv', 'w');

   foreach ($row as $rows) {
    fputcsv($fp, $rows);         

     }fclose($fp);

What error do you get? What does not work? How does the saved file look like? — BudwiseЯ
– BudwiseЯ, Commented Apr 16, 2016 at 20:05
i get no error but the content of the original csv. but it will not save the changed content to the 'changed.csv' the file is created at the server but it's empty. — Kallmas
– Kallmas, Commented Apr 16, 2016 at 20:09

yk11 · Accepted Answer · 2016-04-17 14:19:51Z

2

You have two options:

Use n array

$rows = []
...
$rows[] = str_replace($cat_alt, $cat_neu, $data[$c] . "\n");
...
fputcsv($fp, $rows);

Open the output file beforehand and write to it as you process the data

$fp = fopen('changed.csv', 'w');
if (($handle = fopen("original.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 20000, ";")) !== FALSE) {
        $num = count($data);
        $cat_alt = ['cold', 'hot', ... and so on...];                                                            
        $cat_neu = ['kalt', 'heiß', ...und so weiter...];

        echo "<p> $num Felder in Zeile $row: <br /></p>\n";
        $row++;
        for ($c=0; $c < $num; $c++) {
            fputs($fp, str_replace($cat_alt, $cat_neu, $data[$c] . "<br />\n"));
        }
    }
}

fclose($fp);

edited Apr 17, 2016 at 14:19

answered Apr 16, 2016 at 20:08

yk11

7684 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

PHP open csv and save data to new csv

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