PHP到csv分号问题

Question

I have the following $data array:

array(
    (int) 0 => '37899810;214214;01;5083;;',
    (int) 1 => '37899810;214215;01;19966;;',
    (int) 2 => '37899810;54654;01;35691;;',
    (int) 3 => '37899810;769;01;52016;;'
)

When I try to echo it as csv in the following way:

foreach($data as $row):
    echo $row."
";
endforeach;

For each and every row, the semi-colons are escaped and integers are put into different cells. What I want to get instead, is the whole string, let's say 37899810;214214;01;5083;; to be placed in one cell, and that the remaining ones would be placed in the other rows, but the strings would just take one cell.

Answer 1

try this

header( 'Content-Type: text/csv' );
header( 'Content-Disposition: attachment;filename=example.csv');
$handle = fopen('php://output', 'r+');
foreach ($data as $row) {
   fputcsv($handle, $row, ';');
}
fclose($handle);