Simple Array to String Conversion

Question

I have an array from a SQL query which looks like this:

array(2) { 
[0]=> array(2) { ["ID"]=> string(1) "a" [0]=> string(1) "a" } 
[1]=> array(2) { ["ID"]=> string(1) "b" [0]=> string(1) "b" } }

I want to turn it into a list, so it looks like this:

'a','b'

I've tried various methods from around the site/google, but can't seem to get anything working. They include:

implode(',',$arr);

$list='';
foreach($arr as $row){
$list=$list+$row['ID'];
}

Start by modifying your SQL query call so that it returns either an associative or an enumarated array, but not both — Mark Baker
– Mark Baker, Commented Aug 22, 2013 at 13:25
yes, noted, I've altered the fetch statement to $res = $stmt->fetchAll(PDO::FETCH_ASSOC); makes the array much easier to work with — xgstr
– xgstr, Commented Aug 22, 2013 at 13:32

knittl · Accepted Answer · 2013-08-22 13:17:52Z

4

First, turn your array into an array, containing only the IDs with quotemarks around them (array_map), then join them together with a comma (join):

echo join(', ', array_map(
  function($item) { return "'" . $item['ID'] . "'"; },
  $your_array));

answered Aug 22, 2013 at 13:17

knittl

269k59 gold badges339 silver badges405 bronze badges

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

3 Comments

Note that join is now an alias of implode so you should use implode directly.

@Technoh: yes, they both perform the same operation, so I don't see any advantage of using one over the other.

Have accepted this because, a. it was first and b. the explanation meant I understood how the answer worked. Thanks

Parixit · Accepted Answer · 2013-08-22 13:42:25Z

0

Try following


$test = "'".implode("','",$arr)."'";

for assoc array try


$test = "'".implode("','",array_map_assoc(function($k,$v){return "$v";},$arr))."'";

answered Aug 22, 2013 at 13:24

Parixit

3,8193 gold badges39 silver badges65 bronze badges

I tried that before, doesn't work... Array to string conversion

check for assoc array. Also see this post stackoverflow.com/questions/6556985/…