如何使用PHP一次尝试将多行/多个数组写入CSV文件？ [关闭]

Question

I have to write multiple records in csv file. I'm using fputcsv function of php which take array as one row and write it in the file. In this way there will be multiple write operations for each row.

I'm looking for a method with which I can write multiple rows in one write operation to csv file.

Please help.

Answer 1

Solution 1: Saving Data in String and then using fwrite worked!

Code:

$file = 'test.csv';

$file = fopen($file, 'w');

$content = '';

for($i=0;$i<10;$i++){
    $content.="a,b,c,d
";
}

fwrite($file, $content);

fclose($file);

Solution 2: as suggested by @chiliNUT using output buffer.

Code:

$handle = fopen("php://output", "w");
$data = [[1, 2, 3], [4, 5, 6], [7, 8, 9]];
ob_start();
foreach ($data as $dat) {
    fputcsv($handle, $dat);
}
$csvContent = ob_get_clean();
file_put_contents("csv.csv", $csvContent);