将数据库中的结果集显示为单个数字

Question

I am trying to display a set of values as comma separated.

my data is $data = 123456789 i want to display it as (1,2,3,4,5,6,7,8,9)

i tried doing echo implode(',' ,(array)$data); But no result.

Answer 1

use below code

$data = 'value from database';
$data = (string)$data

$array = str_split($data);
print_r($array);
$string = implode(",",$array);
echo $string;

Here is Sample Output

 Array
(
    [0] => 1
    [1] => 2
    [2] => 3
    [3] => 4
    [4] => 5
    [5] => 6
    [6] => 7
    [7] => 8
    [8] => 9
)
1,2,3,4,5,6,7,8,9

According to your code

$sc1 = mysqli_query($con, "select distinct pt from pl_pts where first<>'' AND date(dtime) = CURDATE() ORDER BY pt");

while ($sc2 = mysqli_fetch_array($sc1))
    {
    $data = (string)$sc2['pt'];
    $array = str_split($data);
    $string = implode(",", $array);
    echo "(".$string.")";//concated parenthesis
    }