PHP array to another and json

Question

SQL output use for loop on the array , get only data to the new array and one key name ,data=> mycode:

$sql = "SELECT * FROM Alldata";
if($result = mysqli_query($mysqli,$sql))
{
    $rows = array();
    $newdata = array();
    while($row = mysqli_fetch_assoc($result))
    {
        $rows[] = $row;
    }
}
for($i = 0; $i <= 6; $i++){
    $newdata['data'][$i] = $rows[$i]['poo'];
}
echo json_encode($newdata);

output:

Array
(
    [data] => Array
        (
            [0] => 123
            [1] => 456
            [2] => 789
            [3] => 111
            [4] => 222
            [5] => 333
        )

)
{"data":["123","456","789","111","222","333"]}

but I want is like:

Array
(
    [0] => Array
        (
           
            [data] => 123,456,789,111,222,333
        )
)
[{"data":"123,444,555,666,777"}]

How to get this output? thank you!!

Why do you want the data in this form? Seems backwards.

GrumpyCrouton
– GrumpyCrouton

2020-10-01 11:42:43 +00:00
Commented Oct 1, 2020 at 11:42 — GrumpyCrouton
– GrumpyCrouton, Commented Oct 1, 2020 at 11:42
implode(',', $yourArray)

Cid
– Cid

2020-10-01 11:46:51 +00:00
Commented Oct 1, 2020 at 11:46 — Cid
– Cid, Commented Oct 1, 2020 at 11:46

Dharman · Accepted Answer · 2020-10-01 11:57:35Z

1

I am not sure why you want the data as a comma-separated string but if you want to do something like this then you can simply implode() a single column from the result set. To get the column use array_column()

Change your code to this:

$sql = "SELECT * FROM Alldata";
$result = $mysqli->query($sql);
$rows = $result->fetch_all(MYSQLI_ASSOC);
$newdata[] = [
    'data' => implode(',', array_column($rows, 'poo'))
];
echo json_encode($newdata);

It produces this output:

[{"data":"1,2,3,6,7,8,9,10,11,12"}]

edited Oct 1, 2020 at 11:57

answered Oct 1, 2020 at 11:50

Dharman♦

33.9k27 gold badges105 silver badges157 bronze badges

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

2 Comments

lili Over a year ago

Array ( [0] => Array ( [data] => 123,456,789,111,222,333 ) [1] => Array ( [data] => 456,666,777,888,333) )how to do it?

Dharman Over a year ago

Do you mean split into groups of 6 elements each? Use array_chunk()

Sahil Pasricha · Accepted Answer · 2020-10-01 11:50:33Z

0

This will do the trick, simple use implode function.

$sql = "SELECT * FROM Alldata";
if($result = mysqli_query($mysqli,$sql))
{
    $rows = array();
    $newdata = array();
    while($row = mysqli_fetch_assoc($result))
    {
        $rows[] = $row;
    }
}
for($i = 0; $i <= 6; $i++){
    $newdata['data'][$i] = $rows[$i]['poo'];
}
$glue = implode(",",$newdata['data']);
$newdata['data'] = $glue;
echo json_encode($newdata);

answered Oct 1, 2020 at 11:50

Sahil Pasricha

1331 gold badge3 silver badges10 bronze badges

3 Comments

M. Eriksson Over a year ago

Why not just get the value directly in your while-loop instead of adding an extra foreach?

lili Over a year ago

If I need add array ...like this

lili Over a year ago

Array ( [0] => Array ( [data] => 123,456,789,111,222,333 ) [1] => Array ( [data] => 456,666,777,888,333) ) )how to do it?

Collectives™ on Stack Overflow

PHP array to another and json

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related