我需要替换csv中的大量数据,在更改所有内容后,我希望将其保存到一个新的csv文件中。我可以用php.net中的代码读取csv,但无法保存新文件。我有这个
$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);
您有两个选项:
-
使用n阵列
$rows = [] ... $rows[] = str_replace($cat_alt, $cat_neu, $data[$c] . "'n"); ... fputcsv($fp, $rows);
-
事先打开输出文件,并在处理数据时写入
$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);