asked on 5/17/2011

help needed in building json data

Hi

any idea how to build this structure with json using php

"data" : [
				{ 
					"data" : "My Documents", 
					"children" : [ {"attr":{"id":"2","rel":"file"},"data":"file1.doc","state":""} ]
				}
			]

Open in new window

Thanks

PHP JavaScript Joomla

Last Comment

3xtr3m3d

5/17/2011

hielo

5/17/2011

Use json_encode:
http://us3.php.net/manual/en/function.json-encode.php

Refer to the example sections on that page

Proculopsis

5/17/2011

//Something like this:

$o = array( "data" => array(
"data" => "My Documents",
"children" => array(
"attr" => array(
"id" => 2,
"rel" => "file"
),
"data" => "file1.doc",
"state" => ""
)
)
);

ASKER CERTIFIED SOLUTION

hielo

5/17/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

3xtr3m3d

5/17/2011

ASKER

Hi

Thanks all for the replies guys.

hielo: thanks i changed your solution like this and it works

$obj = array(
				array(
								"data" => "My Documents",
								"children" => array(
													array(
															"attr" => array(
																			"id" => 2,
																			"rel" => "file"
																		),
															"data" => "file1.doc",
															"state" => ""
														)
											)
								)
						
		);
		
echo json_encode($obj);

Open in new window

any idea how to build this with two mysql queries? like getting
"data" => "My Documents" from 1 query and contents for children with second query.

Thanks

hielo

5/17/2011

It sounds like you will need nested while loops. Open a new thread and post your php code related to these queries.

3xtr3m3d

5/17/2011

ASKER

Thanks posted new question on

New Question