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 phpexcel.codeplex.com

Niranjan N Raju
– Niranjan N Raju

2015-10-08 13:24:19 +00:00
Commented Oct 8, 2015 at 13:24 — Niranjan N Raju
– Niranjan N Raju, Commented Oct 8, 2015 at 13:24

Rohit Kumar · Accepted Answer · 2015-10-08 13:22:30Z

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 8, 2015 at 13:22

Rohit Kumar

1,9581 gold badge12 silver badges17 bronze badges

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

1 Comment

Arushi Chopra Over a year ago

Thankyou so much! I can't give upvote as of now. You are awesome!

Chizzle · Accepted Answer · 2017-10-12 02:51:24Z

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, 2017 at 2:51

answered Oct 8, 2015 at 13:19

Chizzle

1,7151 gold badge18 silver badges26 bronze badges

Collectives™ on Stack Overflow

Write PHP array object to a csv file

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related