PHP Export Array to CSV

Question

I currently have a query that returns the array below.. When I try to export the data to a CSV file I see the data twice (The columns are repeted, not the rows).. Can someone explain to my why? (I want to have each records show only once)

Array
(
    [0] => Array
        (
            [0] => 6991
            [id] => 6991
            [1] => 8588
            [work_num] => 8588
            [2] => Test123
            [name] => Test123
            [3] => 1407154
            [deployed] => 1407154
            [4] => 2015-10-13
            [created_date] => 2015-10-13
        )
)

This is the code that I am using to export the data

// create a file pointer connected to the output stream
$output = fopen('php://output', 'w');

// output the column headings
fputcsv($output, array('id','Work Number','Name','Deployed','Date'));


$get_data  = $CLASSNAME->FuntionName(Parameters);

foreach($get_data as $data_row) {
    fputcsv($output, $data_row);
}

fclose($output);

You data comes as a mysql-query result. Post code which gets data. — u_mulder
– u_mulder, Commented Nov 11, 2015 at 18:37

Samir Selia · Accepted Answer · 2015-11-11 18:38:14Z

2

If you are using MySQL, then replace mysql_fetch_array to mysql_fetch_row.

mysql_fetch_array returns result set as both numeric and associative array. mysql_fetch_row will return result set as only numeric array.

answered Nov 11, 2015 at 18:38

Samir Selia

7,1502 gold badges14 silver badges33 bronze badges

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

Comments

clemens321 · Accepted Answer · 2015-11-11 18:42:01Z

1

Either fix your incoming data (when using PDO, use PDO::FETCH_ASSOC or PDO::FETCH_NUM instead of PDO::FETCH_BOTH, which is default) or name your columns when putting to csv:

foreach($get_data as $data_row) {
    fputcsv($output, array(
        $data_row['id'],
        $data_row['work_num'],
        $data_row['name'],
        $data_row['deployed'],
        $data_row['created_date']
    ));
}

answered Nov 11, 2015 at 18:42

clemens321

2,09815 silver badges18 bronze badges

1 Comment

Yaco Zaragoza Over a year ago

I had to do a minor change.. $data_row[$i]['id']

Collectives™ on Stack Overflow

PHP Export Array to CSV

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related