How to join db value as string with comma separator using PHP and Mysql

Question

I need one help.I need to join DB value as string with comma(,) separator using PHP and Mysql.I am explaining my table below.

db_order:

id         name

1           Rahul

2           Raj


3           Shiv

4          Hari


$qry=mysqli_query($con,"select * from db_order");
while($row=mysqli_fetch_array($qry)){
   $data[]=$row;
}
print_r($data);

From my table i need to join all name with comma(,) so that result should like this Rahul,Raj,Shiv,Hari by executing the query.Please help me.

Do you already have tried to solve it yourself? You got to have at least some code, right? — mmgross
– mmgross, Commented Mar 31, 2016 at 9:48
i can only fetch the name using query but little bit confused how to join finaly with comma. — user5443928
– user5443928, Commented Mar 31, 2016 at 9:50
Then you should at least show your code till the point when you fetch the results of the query — Alessandro
– Alessandro, Commented Mar 31, 2016 at 9:51

sagi · Accepted Answer · 2016-03-31 09:55:32Z

1

Use GROUP_CONCAT :

SELECT group_concat(name separator ',') FROM YourTable

answered Mar 31, 2016 at 9:55

sagi

40.6k7 gold badges66 silver badges87 bronze badges

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

Comments

Gokul Shinde · Accepted Answer · 2016-03-31 09:58:16Z

0

If you have to use php then it will be like

$qry = mysqli_query($con,"select * from db_order");
$str = '';
while($row = mysqli_fetch_array($qry)){
   $str .= $row['name'].",";
}
$data = rtrim($str, ",");
echo $data;

answered Mar 31, 2016 at 9:58

Gokul Shinde

9753 gold badges10 silver badges30 bronze badges

Comments

Nirav Desai · Accepted Answer · 2016-03-31 09:55:02Z

0

You can directly get values from ur query by comma separated.

If you are using mysql, then you can get name of table comma separated like

select GROUP_CONCAT(name) from <table_name>;

and if you have database in oracle then u can use wm_concat() in place of GROUP_CONCAT().

answered Mar 31, 2016 at 9:55

Nirav Desai

93 bronze badges

Comments

Naresh Kumar Nakka · Accepted Answer · 2016-03-31 10:06:39Z

0

Please try this:

<?php
$server = 'localhost';
$username = 'root';
$password = '';
$database = 'test';

$con = mysql_connect($server, $username, $password) or die("Error:" . mysql_error());
mysql_select_db($database, $con) or die("Unable to select DB" . mysql_error());

$qry = "SELECT id, name FROM users";

$res = mysql_query($qry, $con) or die("Error to execute query " . mysql_error());

$users = '';
if (mysql_num_rows($res)) {
    while ($row = mysql_fetch_array($res)){
        if ($users) {
            $users .= ',' . $row['name'];
        } else {
            $users = $row['name'];
        }
    }
}

echo $users;

answered Mar 31, 2016 at 10:06

Naresh Kumar Nakka

5204 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to join db value as string with comma separator using PHP and Mysql

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related