Implode Multi Dimensional Array to a single comma separated list in PHP

Question

If I have an array like:

Array ( [0] => abcdef )
Array ( [0] => abcdef [1] => abcdef )
Array ( [0] => abcdef [1] => abcdef [2] => abcdef )
Array ( [0] => abcdef [1] => qwerty )

And want to create a comma separated list like:

abcdef, abcdef, abcdef, abcdef, abcdef, abcdef, abcdef, qwerty

How would I do this?

When I try and implode the array like this:

while($row = mysql_fetch_array($search)){ 
    $row2 = $row['scholarshipid']; 
    $newarray = unserialize($row2);
    $unique_array = array_unique($newarray, SORT_REGULAR);
    $commaList = implode(', ', $unique_array);
    echo "$commaList";
    //print_r($newarray); 
} 

$commaList = implode(', ', $unique_array);

I get:

abcdefabcdefabcdefabcdef, qwerty

Then please show us your code where and how you create the arrays. — Rizier123, Dec 23 '15 at 15:24
while($row = mysql_fetch_array($search)){ $row2 = $row['scholarshipid']; $newarray = unserialize($row2); $unique_array = array_unique($newarray, SORT_REGULAR); $commaList = implode(', ', $unique_array); echo "$commaList"; //print_r($newarray); } — Tom Canfarotta, Dec 23 '15 at 15:27
That array description looks rather odd, can you do a `print_r($unique_array);` and edit that into your question please — RiggsFolly, Dec 23 '15 at 15:32
@TomCanfarotta Why the hell is sql a problem here, if the question does not even contain a single line of sql code? — Manikiran, Dec 23 '15 at 15:38
Please [edit] your post to include any additional information you have to your question. Avoid adding this in the comments, as they are harder to read and can be deleted easier. The edit button for your post is just below the post's tags. — Kyll, Dec 23 '15 at 15:46

score 2 · Accepted Answer · edited May 23 '17 at 12:15

2

As from the comments it turns out that the output which you show us comes from a loop. So you first have to collect all arrays in each iteration into 1 variable, which you then can implode, e.g.

$result = [];

while($row = mysql_fetch_array($search)){
    $row2 = $row['scholarshipid'];
    $newarray = unserialize($row2);
    $unique_array = array_unique($newarray, SORT_REGULAR);
    $result = array_merge($result, $unique_array);
}

echo implode(",", $result);

edited May 23 '17 at 12:15

Community

1
1

answered Dec 23 '15 at 15:36

Rizier123

58,877
16
101
156

@TomCanfarotta You're welcome. Also see: [tour] to get a quick overview of the site. – Rizier123 Dec 23 '15 at 15:49

Alaa M. Jaddou · Answer 2 · 2015-12-23T18:07:22.473

-2

you can do it like this UPDATE

$temp = array();
while($row = mysql_fetch_array($search)){ 
    $row2 = $row['scholarshipid']; 
    $newarray = unserialize($row2);
    $temp = array_merge($temp, $newarray);

}
$commaList = implode(', ', $temp);
print_r($commaList);

and it's all done :P

edited Dec 23 '15 at 18:07

answered Dec 23 '15 at 15:32

Alaa M. Jaddou

1,180
1
11
30

The problem is the array's are coming from the db and the amount will not be constant. – Tom Canfarotta Dec 23 '15 at 15:34
Please read the question properly, its a multidimensional array, not different arrays – Manikiran Dec 23 '15 at 15:35
@TomCanfarotta i've read the question but the result is not associative array so when you merge it it gives you two array in one array in this case it will merge all arrays that comes after the while loop implode the new array – Alaa M. Jaddou Dec 23 '15 at 18:09
the merge array it make all your results in one array, after that the implode is making the $commaList as you want – Alaa M. Jaddou Dec 23 '15 at 20:34
I know what the code does. I asked where the difference is to mine answer after the update. – Rizier123 Dec 23 '15 at 20:37
@Rizier123 i think there is no diff – Alaa M. Jaddou Dec 23 '15 at 20:39
@Rizier123 i think the only diff is that you use the array_unique to unique the values :) – Alaa M. Jaddou Dec 23 '15 at 20:41

Implode Multi Dimensional Array to a single comma separated list in PHP

2 Answers2