无法通过 fputcsv() 让 PHP 数组进入 CSV

Question

我有一个$events数组，看起来像

Array
(
    [0] => Array
        (
            [4fe8a21c6f05d60023009d96] => any authentication
        )
    [1] => Array
        (
            [4fe8a21c6f05d60023009d96] => any authentication
        )
    [2] => Array
        (
            [4fe8a21c6f05d60023009d96] => any authentication
        )
    [3] => Array
        (
            [4fe8a21c6f05d60023009d96] => any authentication
        )
    [4] => Array
        (
            [4fe8a21c6f05d60023009d96] => any authentication
        )

我使用下面的代码尝试将user_id和单词"any authentication"放在CSV的每一行。然而，使用我的代码，我看到了以下内容（而不是"4fe8a21c6f05d60023009d96 " "any authentication"）：

"User_ID    "   "   Event"
    "Array  "   "   Array"
    "Array  "   "   Array"
    "Array  "   "   Array"
    "Array  "   "   Array"
    "Array  "   "   Array"
    "Array  "   "   Array"
    "Array  "   "   Array"
    "Array  "   "   Array"
    "Array  "   "   Array"
    "Array  "   "   Array"
    "Array  "   "   Array"
    "Array  "   "   Array"
    "Array  "   "   Array"
    "Array  "   "   Array"

我的代码是：

$fp = fopen('events.csv', 'w');
$header = array('User_ID',",",'Event');
fputcsv ($fp, $header, "t");
foreach ($events as $event) {
    $line = array(array_keys($event),',',$event);
    fputcsv($fp, $line,"t");
}
fclose($fp);

Answer 1

对于您的阵列，请尝试以下解决方案：

<?php
$events = array
(
    '0' => array
    (
        '4fe8a21c6f05d60023009d96' => 'any authentication'
    ),
    '1' => array
    (
        '4fe8a21c6f05d60023009d96' => 'any authentication'
    ),
    '2' => array
    (
        '4fe8a21c6f05d60023009d96' => 'any authentication'
    ),
    '3' => array
    (
        '4fe8a21c6f05d60023009d96' => 'any authentication'
    ),
    '4' => array
    (
        '4fe8a21c6f05d60023009d96' => 'any authentication'
    )
);

$fp = fopen('events.csv', 'w+');
$header = array('User_ID',",",'Event');
fputcsv ($fp, $header, "t");
foreach ($events as $event) {
    $line = array(key($event),',',$event[key($event)]);
    fputcsv($fp, $line,"t");
}
fclose($fp);

有关fputcsv的更多详细信息，请参阅PHP：fputcsv-Manual