Write PHP array object to a csv file

Question

I would like to ask that how can I write a php array std object to a csv file.

Convert array to csv Didn't solve my problem.

This is my Array

Array
    (
        [0] => stdClass Object
            (
                [lotNum] => 1
                [commissionRate] => 4.0%
                [detailUrl] => JEq7E6IEa
                [promotionVolume] => 0
                [packageType] => piece
                [price] => US $80.54
                [imageUrl] => BOX.jpg
                [subject] => Box
                [salePrice] => US $60.41
                [commission] => US $0.00
                [productId] => xxxx1
            )

        [1] => stdClass Object
            (
                [lotNum] => 1
                [commissionRate] => 4.0%
                [detailUrl] => JEq7E6IEa
                [promotionVolume] => 0
                [packageType] => piece
                [price] => US $80.54
                [imageUrl] => BOX.jpg
                [subject] => Box
                [salePrice] => US $60.41
                [commission] => US $0.00
                [productId] => xxxx1
            )
    )

How can I put data of each product in one row of csv file? Thanks :)

use `PHP Excel`, see docs here https://phpexcel.codeplex.com/ — Niranjan N Raju, Oct 08 '15 at 13:24

score 23 · Answer 1 · answered Oct 08 '15 at 13:22

23

Try following

<?php

//$list = ----your array

$fp = fopen('file.csv', 'w');

foreach ($list as $fields) {
    fputcsv($fp,get_object_vars($fields));
}

fclose($fp);
?>

answered Oct 08 '15 at 13:22

Rohit Kumar

1,948
1
11
16

2

Thankyou so much! I can't give upvote as of now. You are awesome! – Arushi Chopra Oct 08 '15 at 16:55

Chizzle · Answer 2 · 2017-10-12T02:51:24.160

3

You have objects within your array. Convert them to an array.

<?php
$fp = fopen('file.csv', 'w');
foreach ($myArray as $fields) {
    if( is_object($fields) )
        $fields = (array) $fields;
    fputcsv($fp, $fields);
}

fclose($fp);
?>

edited Oct 12 '17 at 02:51

answered Oct 08 '15 at 13:19

Chizzle

1,707
1
17
26

Write PHP array object to a csv file

2 Answers2