How to json encode a single object as a json objects array using PHP

Question

For two objects:

    {"publications":[{"nom":"toto","id":"2029","userid":"22","publication":"bla bla bla","time":"2017-02-20 00:00:00","avatar":{}},{"nom":"xxxx","id":"2027","userid":"31","publication":"kjdsfkuds","time":"2017-02-20 00:00:00","avatar":{}}]}

For One object:

    {"publications":{"nom":"xxxx","id":"2027","userid":"31","publication":"kjdsfkuds","time":"2017-02-20 00:00:00","avatar":{}}}

i want to have always a json array as a return no matter how the number of objects.

PHP Code:

    $result = $conn->query($sql);
    $json = new SimpleXMLElement('<xml/>');

  if ($result->num_rows > 0) {
   while($row = $result->fetch_assoc()) {
    $mydata = $json->addChild('publications');
    $mydata->addChild('nom',$row['nom']);
    $mydata->addChild('id',$row['id']);
    $mydata->addChild('userid',$row['userid']);
    /*echo(utf8_encode($row['publication']));*/
    $mydata->addChild('publication',utf8_encode($row['publication']));
    $mydata->addChild('time',$row['time']);
    $mydata->addChild('avatar',$row['avatar']);

     }
     echo( json_encode ($json));
    } else {
      echo "0";
    }

Get rid of Simplexml and use plain arrays.

u_mulder
– u_mulder

2017-04-27 20:25:02 +00:00
Commented Apr 27, 2017 at 20:25 — u_mulder
– u_mulder, Commented Apr 27, 2017 at 20:25

aprogrammer · Accepted Answer · 2017-04-27 20:36:28Z

3

Well you are not using XML for anything else but convert it to JSON, so there is no need for XML. Use array

$result = $conn->query($sql);
$json = ['publications' => []];

if($result->num_rows > 0)
{
    while($row = $result->fetch_assoc())
    {
        $json['publications'][] = [
            'nom' => $row['nom'],
            'id' => $row['id'],
            'userid' => $row['userid'],
            'publication' => $row['publication'],
            'time' => $row['time'],
            'avatar' => $row['avatar']
        ];
    }
    echo json_encode($json);
}
else
{
    echo "0";
}

answered Apr 27, 2017 at 20:36

aprogrammer

1,7781 gold badge11 silver badges20 bronze badges

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

Comments

u_mulder · Accepted Answer · 2017-04-27 20:31:56Z

It's a particluar behaviour of SimpleXML.

If you have one child in xml - you will have an object in json, if you have more than one child - you will get array of objects. So, I advise you to rewrite your code using simple arrays instead of xml-approach:

$result = $conn->query($sql);
$json = [];  // just array

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        // add new item
        $json[] = $row;   

        // or more specifically
        $json[] = [
            'nom' => $row['nom'],
            'id' => $row['id'],
            // more fields that you need
        ];   
    }
}
echo json_encode(['publications' => $json]);

Collectives™ on Stack Overflow

How to json encode a single object as a json objects array using PHP

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related