insert array into csv through php

Question

I have

Array
(
    [Name] => sdvsdv
    [CanaryAMS__Account_id__c] => abc
    [CanaryAMS__S3_File_Url__c] => ascfdsv
    [CanaryAMS__Description__c] => statement faxed to Aurelia at Occi 9/29/09
    [CanaryAMS__DocExternalId__c] => dscmdsv
)

i am using following code but it is giving error

<?php

$list = Array
(
    Name => sdvsdv
    CanaryAMS__Account_id__c => abc
    CanaryAMS__S3_File_Url__c => ascfdsv
    CanaryAMS__Description__c => statement faxed to Aurelia at Occi 9/29/09
    CanaryAMS__DocExternalId__c => dscmdsv
);

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

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

fclose($fp);
?>

I want to upload this data into csv file. sdvsdv under name , abc under CanaryAMS__Account_id__c and so on.

l0ckm4 · Accepted Answer · 2015-05-22 14:06:05Z

1

try this. There are probable better ways of doing it though but for this simple example there is no need.

<?php

$list[0] = array
(
    'Name' => 'sdvsdv',
    'CanaryAMS__Account_id__c' => 'abc',
    'CanaryAMS__S3_File_Url__c' => 'ascfdsv',
    'CanaryAMS__Description__c' => 'statement faxed to Aurelia at Occi 9/29/09',
    'CanaryAMS__DocExternalId__c' => 'dscmdsv'
);
$list[1] = array
(
    'Name' => 'khk',
    'CanaryAMS__Account_id__c' => 'abckj',
    'CanaryAMS__S3_File_Url__c' => 'ghkghkv',
    'CanaryAMS__Description__c' => 'statement faxed to Aurelia at Occi 9/29/15',
    'CanaryAMS__DocExternalId__c' => 'dscmdsv'
);
$list[2] = array
(
    'Name' => 'gghfhfghf',
    'CanaryAMS__Account_id__c' => 'affbc',
    'CanaryAMS__S3_File_Url__c' => 'ascfffdsv',
    'CanaryAMS__Description__c' => 'statement faxed to Aurelia at Occi 05/05/20',
    'CanaryAMS__DocExternalId__c' => 'dscmdsv'
);

$header = '';
$fp = fopen('file.csv', 'w');
foreach ($list[0] as $k=>$v) $header .= $k.",";
$csvstring = trim($header,",")."\n";
fwrite($fp,$csvstring);
foreach ($list as $fields) fputcsv($fp, $fields);
fclose($fp);

edited May 22, 2015 at 14:06

answered May 22, 2015 at 14:00

l0ckm4

7475 silver badges17 bronze badges

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

5 Comments

Shalini Vashist Over a year ago

I can do same thing for array which contains 20 records right?array[0],array[1] etc

l0ckm4 Over a year ago

sure - u can have as many as your system will allow you to have limited by memory and your php ini settings (some of which may or may not be able to overridden in the php file itself)

Shalini Vashist Over a year ago

My array is in the form Array ( [Name] => sdvsdv [CanaryAMS__Account_id__c] => abc [CanaryAMS__S3_File_Url__c] => ascfdsv [CanaryAMS__Description__c] => statement faxed to Aurelia at Occi 9/29/09 [CanaryAMS__DocExternalId__c] => dscmdsv ) This array is generated from some code actually

l0ckm4 Over a year ago

if you have multiple arrays only one level deep then you will need to combine them into a nested array like i have sampled above otherwise you will need to call the same functions over and over again with anything other than the first array excluding the header part and of course opening the file with the 'a' flag and not the 'w' flag so not to truncate the file

Shalini Vashist Over a year ago

Please help me with above mentioned array Array ( [Name] => sdvsdv [CanaryAMS__Account_id__c] => abc [CanaryAMS__S3_File_Url__c] => ascfdsv [CanaryAMS__Description__c] => statement faxed to Aurelia at Occi 9/29/09 [CanaryAMS__DocExternalId__c] => dscmdsv )

Collectives™ on Stack Overflow

insert array into csv through php

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related