Implode array with comma separated string but no comma after last string

Question

I have used implode to separate the array. What I want is that my ids should be shown in brackets separated by commas, but after the last string there will be no comma. How can I show them in brackets with no comma after the last string?

<html>
   <head>
   </head>

   <body>
      <?php
         mysql_connect("localhost", "usename", "password") or die(mysql_error()); 
         mysql_select_db("dbname") or die(mysql_error()); 

         $ids=array();
         $data = mysql_query("SELECT id FROM information"); 
         while($row = mysql_fetch_assoc($data))  
         {
            $ids[]=$row["id"]; 
         } 
         echo implode(", ", $ids);
      ?>
   </body>
</html>

I think its better to show an example!

Jason OOO
– Jason OOO

2014-07-23 06:21:33 +00:00
Commented Jul 23, 2014 at 6:21 — Jason OOO
– Jason OOO, Commented Jul 23, 2014 at 6:21
What is the output you get?

Alexander Gelbukh
– Alexander Gelbukh

2014-07-23 06:22:30 +00:00
Commented Jul 23, 2014 at 6:22 — Alexander Gelbukh
– Alexander Gelbukh, Commented Jul 23, 2014 at 6:22
but using implode, no comma will get add after last string

Khushboo
– Khushboo

2014-07-23 06:22:45 +00:00
Commented Jul 23, 2014 at 6:22 — Khushboo
– Khushboo, Commented Jul 23, 2014 at 6:22
Expected output just mention here.

Sadikhasan
– Sadikhasan

2014-07-23 06:23:23 +00:00
Commented Jul 23, 2014 at 6:23 — Sadikhasan
– Sadikhasan, Commented Jul 23, 2014 at 6:23
implode doesn't add a glue after the last one array item.

pavel
– pavel

2014-07-23 06:24:03 +00:00
Commented Jul 23, 2014 at 6:24 — pavel
– pavel, Commented Jul 23, 2014 at 6:24

Ivan Yonkov · Accepted Answer · 2014-07-23 06:36:47Z

7

$arr = [1,2,3,4,5,6,7,8,9,10,12,13]; // array(1,2,3,4,5,6,7,8,9,10,12,13); for versions below 5.4

$str = "(".implode("), (", $arr).")";

echo $str;

Results in

(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (12), (13)

If that's your expected behavior, you just add the opening and closing bracket as delimiters, which will separate the strings by it, but will result in lack of opening and closing bracket at the beginning and at the end (as it adds the glue AFTER each element, except the last), so you add it manually with concatenation.

It will take 1 and 2 for example and will add after 1 (because 2 is the last, it will only add AFTER 1) the delimiter ), ( will result in 1), (2, thus adding the concatenated ( and ) results in (1), (2)

edited Jul 23, 2014 at 6:36

answered Jul 23, 2014 at 6:29

Ivan Yonkov

7,0291 gold badge20 silver badges25 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:32:47Z

0

Provided I followed your question correctly. You'd use something like this

(We're passing variables by reference in this example):

foreach($ids as $i => &$id) {
    $id = "({$id})";
}

$string = implode(", ", $ids);

Which will end up returning something like this:

(56), (74), (88), (100), (91), (61), (43), (47), (77), (2), (78), (61), (44), (6), (74), (90), (14), (86), (80)

Here is an example (^{Note: It just uses randomly generated id's})

In response to your comment:

Even with strings, this function works. See this example

edited May 23, 2017 at 12:32

CommunityBot

11 silver badge

answered Jul 23, 2014 at 6:26

Darren

13.1k4 gold badges44 silver badges81 bronze badges

5 Comments

Ivan Yonkov Over a year ago

This will suit the OP needs, but it's an overkill where you are mutating the array for purpose of late presentation, which is also a bad practice according to me. Afterwards each time you try to do something with that array, you will have brackets around each element

Darren Over a year ago

@RoyalBg That is a good point. I wrote this answer assuming the sole purpose of the OP was to create the string that he is echo'ing out to the DOM, as seen in his example.

user3815328 Over a year ago

your code works in numbers,but whenever i wanted bring simple string for exapmle names of tv the last string i get is something like this - ' CNN ', 'AMC', '' there is a extra comma plus two apostrophe signs

Darren Over a year ago

@user3815328 Could you supply an example of that set of strings?

Darren Over a year ago

@user3815328 is that not what you wanted?

Collectives™ on Stack Overflow

Implode array with comma separated string but no comma after last string

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related