how to add the comma in php result string

Question

I am using the following code

while($result1=mysql_fetch_assoc($sql))
{

    $result=$result1['userId'];
    $arr=explode(" ",$result);
    $userId=implode(",",$arr);
    echo $userId;
}

But I am getting the output like this:5354 I want my output 53,54 please help me

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi. — Rizier123
– Rizier123, Commented Apr 4, 2016 at 4:34

Rizier123 · Accepted Answer · 2016-04-04 04:30:33Z

2

You first want to collect your values, which you fetch from your db, into an array. Then you want to implode() it.

while($result1=mysql_fetch_assoc($sql)){   
    $result[] = $result1['userId'];
}

echo implode(",",$result);

Right now in your code you simply explode one value into an array, but it can't split the string on the delimiter, so it just puts your value into the first array element.

Then imploding an array with only 1 element doesn't make much sense and you simply just output the value again in the while loop. So what your current code does right now is just:

while($result1=mysql_fetch_assoc($sql)){
    echo $result1['userId'];
}

answered Apr 4, 2016 at 4:30

Rizier123

59.8k17 gold badges106 silver badges167 bronze badges

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

Collectives™ on Stack Overflow

how to add the comma in php result string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related