Can't get PHP array to get into CSV via fputcsv()

Question

I have an $events array that looks like

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
        )

And I am using the below code to try and put the user_id and the words "any authentication" each line of the CSV. However, using my code, I see the below (instead of "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"

My code is:

$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);

Chetan Ameta · Accepted Answer · 2015-12-17 05:04:09Z

1

for your array, try below solution:

<?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);

for more detail on fputcsv have a look at PHP: fputcsv - Manual

answered Dec 17, 2015 at 5:04

Chetan Ameta

7,8943 gold badges34 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

Can't get PHP array to get into CSV via fputcsv()

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