PHP PostgreSQL array to string

Question

I have a problem in my PHP script that uses PostgreSQL for fetching and storing data.

Currently I am using the following code:

 $q = "SELECT id FROM playlisty WHERE id_profilu=1;";
 $r = pg_query($q);
 $arr = pg_fetch_all($r);
 echo '<pre>'; var_dump($arr); echo'</pre>';

The output generated by the above code snippet:

array(4) {
  [0]=>
  array(1) {
    ["id"]=>
    string(4) "2014"
  }
  [1]=>
  array(1) {
    ["id"]=>
    string(4) "1549"
  }
  [2]=>
  array(1) {
    ["id"]=>
    string(4) "1965"
  }
  [3]=>
  array(1) {
    ["id"]=>
    string(4) "2047"
  }
}

However, I would prefer if the output looked something like the following: 2014, 1549, 1965, 2047 (i.e. a simple array of id-s of certain playlists). I also tried using implode (to no anvil), and got Array,Array,Array,Array as a reply.

Shankar Narayana Damodaran · Accepted Answer · 2014-02-12 08:16:57Z

1

Why not just loop it ?

$str=""; 
foreach($yourarr as $arr) 
{ 
    $str.=implode(',',$arr).',';
} 
echo rtrim($str,','); //"prints" 2014, 1549, 1965, 2047

edited Feb 12, 2014 at 8:16

answered Feb 12, 2014 at 7:51

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

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

4 Comments

M.Stark Over a year ago

When i loop it can i use it in "SELECT * FROM table WHERE id IN ($str)" ?

Shankar Narayana Damodaran Over a year ago

I don't have an idea what results that query would return...By the way did you try the code which I gave you ?

M.Stark Over a year ago

Yes, for me the result is "2014154919652047" - as You can see there is no commas

M.Stark Over a year ago

$q = "SELECT id FROM playlisty WHERE id_profilu=1 "; $r = pg_query($q); $yourarr = pg_fetch_all($r); $str=""; foreach($yourarr as $arr) { $str.=implode(',',$arr); } echo $str;

hindmost · Accepted Answer · 2014-02-12 08:16:08Z

1

Add this line before echo:

$arr = array_map(function ($v) { return $v['id']; }, $arr);

If you want to output result as string then you have to use implode function. Replace last line with this:

echo '<pre>'. implode(', ', $arr). '</pre>';

edited Feb 12, 2014 at 8:16

answered Feb 12, 2014 at 7:53

hindmost

7,1713 gold badges33 silver badges42 bronze badges

2 Comments

M.Stark Over a year ago

it returned "array(4) { [0]=> string(4) "2014" [1]=> string(4) "1549" [2]=> string(4) "1965" [3]=> string(4) "2047" }"

hindmost Over a year ago

If you want to output result as string you have to use implode function (php.net/manual/en/function.implode.php) instead of var_dump: echo '<pre>'; implode(', ', $arr); echo'</pre>';

HarryIsBack · Accepted Answer · 2014-02-12 07:55:42Z

0

Try this:

$array = array(
            0=>array('id'=>"2014"),
            1=>array('id'=>"2015"),
            2=>array('id'=>"2016"),
        );
        $ids = array_map(function($item) { return $item['id']; }, $array);
        $result = implode($ids,',');
        var_dump($result);

Output: string '2014,2015,2016' (length=14)

answered Feb 12, 2014 at 7:55

HarryIsBack

403 bronze badges

Comments

Vin.AI · Accepted Answer · 2014-02-12 08:31:02Z

0

Do select like this:

$q = "SELECT array_to_string(id, ',') AS id FROM playlisty WHERE id_profilu=1 ";

edited Feb 12, 2014 at 8:31

answered Feb 12, 2014 at 7:56

Vin.AI

2,4373 gold badges22 silver badges42 bronze badges

2 Comments

M.Stark Over a year ago

and how do i get the result from this ?

Vin.AI Over a year ago

Like this: $arr[0]['id'] will return 2014,2015,2016[,...]. You don't have need to implode using php.

Collectives™ on Stack Overflow

PHP PostgreSQL array to string

4 Answers 4

4 Comments

2 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related