Json tree output

Question

I want to change this json output to below style, Any ideas?

My Code:

$queryFunctions = $db->getChatRoomData($userID , $userName, $userMessage, $roomID);
$rows['roomInfo'] = array();
while ($result = mysql_fetch_array($queryFunctions, MYSQL_ASSOC)) 
       {
               $row['uid'] = $result['uid'];
               $row['name'] = $result['userName'];
               $row['message'] = $result['messageText'];
               array_push($rows, $row);

        }
echo json_encode($rows);

Current Output :

{"roomInfo":[],"0":{"uid":"50","name":"ali","message":"arz adab !"},"1":{"uid":"50","name":"ali","message":"arz adab !"},...}

Desired Output :

{"roomInfo" : [{"uid":"50","name":"ali","message":"arz adab !"},{"uid":"50","name":"ali","message":"arz adab !"},...}

Thanks in advance

your desired output isn't valid JSON. You must enclose the whole string with {}: you can't have a bare top-level attribute — pb2q
– pb2q, Commented Jul 30, 2012 at 17:31
Why would you want this? it's not valid JSON. You always need to have an { object } as the main output of your JSON or need at least a [ array ] as the top element... And then again, not even sure, if array can be top level — Mathieu Dumoulin
– Mathieu Dumoulin, Commented Jul 30, 2012 at 17:31

dgmike · Accepted Answer · 2012-07-30 17:35:12Z

4

You need to push the data to roomInfo key over your rows.

$queryFunctions = $db->getChatRoomData(
    $userID , $userName, $userMessage, $roomID
);
$rows = array('roomInfo' => array());
while ($result = mysql_fetch_array($queryFunctions, MYSQL_ASSOC)) 
{
    $row['uid'] = $result['uid'];
    $row['name'] = $result['userName'];
    $row['message'] = $result['messageText'];
    array_push($rows['roomInfo'], $row);

}
print json_encode($rows);

answered Jul 30, 2012 at 17:35

dgmike

1101 silver badge7 bronze badges

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

Comments

Mathieu Dumoulin · Accepted Answer · 2012-07-30 17:35:01Z

2

Ok, then what you want is to create an array with a key "roominfo" that maps to an array of roominfos.

$queryFunctions = $db->getChatRoomData($userID , $userName, $userMessage, $roomID);
$rows['roomInfo'] = array();
while ($result = mysql_fetch_array($queryFunctions, MYSQL_ASSOC)) 
{
    $row['uid'] = $result['uid'];
    $row['name'] = $result['userName'];
    $row['message'] = $result['messageText'];
    array_push($rows['roomInfo'], $row);

}
echo json_encode($rows);

answered Jul 30, 2012 at 17:35

Mathieu Dumoulin

12.3k7 gold badges47 silver badges71 bronze badges

Collectives™ on Stack Overflow

Json tree output

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related