PHP Building an array with variables

Question

I want to build an array to create a CSV file using variables. The $arraybuild variable will gather lines from a search so will never be the same amount of rows.

$arraybuild = "'aaa,bbb,ccc,dddd',";
$arraybuild .= "'123,456,789',";
$arraybuild .= "'\"aaa\",\"bbb\"'";

$list = array
(
    $arraybuild
)
;

$file = fopen("contacts.csv","w");

foreach ($list as $line)
  {
  fputcsv($file,explode(',',$line));
  }

fclose($file);

The problem is the result does not separate the lines, it places them all in the same line.

I want to get

aaa,bbb,ccc,dddd 123,456,789 "aaa","bbb"

What I am getting is

aaa bbb ccc dddd 123 456 789 "aaa" "bbb"

All in separate columns

Can someone please assist?

What result do you expect to have? At this moment you have an array with one item which you write as a single line. — zerkms
– zerkms, Commented Jul 12, 2018 at 0:30
Hi, I just adjusted the question to show what I want. Thanks @zerkms — Renegade Rob
– Renegade Rob, Commented Jul 12, 2018 at 0:34

Goma · Accepted Answer · 2018-07-12 00:39:07Z

3

Push each rows to an array instead of concatenating to a string, then loop and add to csv

$arraybuild[] = "'aaa,bbb,ccc,dddd',";
$arraybuild[] = "'123,456,789',";
$arraybuild[] = "'\"aaa\",\"bbb\"'";

$file = fopen("contacts.csv","w");

foreach ($arraybuild as $line) {
    fputcsv($file, explode(',', $line));
}

fclose($file);

answered Jul 12, 2018 at 0:39

Goma

1,9811 gold badge13 silver badges19 bronze badges

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

1 Comment

dan_nl Over a year ago

RenegadeRob: if you’re satisfied with this answer, you can mark it as the accepted answer to let the community know that your question has been answered and to give Erwin credit for it.

Maxim Mazurok · Accepted Answer · 2018-07-12 00:34:24Z

1

In your code, you are concatenating all values to one string, separated by ,. After that, you are creating one array with one element in it (that long string).

So, it's not a surprise, that you are getting all of them on the same line.

To separate lines, you should create separate arrays inside the $list array. Each included array will be on the new line.

Try this:

<?php

$arraybuild1 = "'aaa,bbb,ccc,dddd',";
$arraybuild2 = "'123,456,789',";
$arraybuild3 = "'\"aaa\",\"bbb\"'";

$list = array
(
    explode(',', $arraybuild1),
    explode(',', $arraybuild2),
    explode(',', $arraybuild3)
);

$file = fopen("contacts.csv", "w");

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

fclose($file);

answered Jul 12, 2018 at 0:34

Maxim Mazurok

4,2002 gold badges29 silver badges46 bronze badges

2 Comments

Renegade Rob Over a year ago

This would be good, but the actual $arraybuild is in a loop adding lines for the CSV. so I cant rename each variable in the loop because it will never be the same amount.

Maxim Mazurok Over a year ago

sure thing, variables here are just for example. @Erwin's answer may be more specific to what you're looking for

Collectives™ on Stack Overflow

PHP Building an array with variables

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related