i am new to JSON and i have e datas returning form db eg
example
example1
example2
sample
sample1
sample 2
like this i need to convert it to json like this
{'title':'Heavy Metal', 'results': [
['/metal/1', 'Disturbed - The Game', 'icons/metal.png'],
['/metal/2', 'Marilyn Manson - The Beautiful People', 'icons/metal.png'],
['/metal/3', 'Soil - 2 Skins', 'icons/metal.png'],
['/metal/4', 'Alestorm - Wenches & Mead', 'icons/metal.png']
]},
{'title':'Pop', 'results':[
['/pop/1', 'Michael Jackson - Bad', 'icons/pop.png'],
['/pop/2', 'Britney Spears - If U Seek Amy', 'icons/pop.png'],
['/pop/3', 'Take That - Relight My Fire', 'icons/pop.png'],
['/pop/4', 'Rick Astley - Never Gonna Give You Up', 'icons/pop.png']
]},
if i use json_encode simply i am getting "example","example1"
etc how can i attain this format.
-
please fix the formatting of your question. An example of the input object would be useful. Also, your full-stop button appears to be broken.Hamish– Hamish2010年11月19日 06:19:00 +00:00Commented Nov 19, 2010 at 6:19
3 Answers 3
If you can get the data you need to format in an array in PHP, using json_encode will work great for you.
For example:
array(
"Key1" => "Value1",
"Key2" => "Value2",
"Key3" => "Value3
);
converted using json_encode would give you:
{ "Key1": "Value1", "Key2": "Value2", "Key3": "Value3" }
Comments
$rs=mysql_query($sql);
$data = array();
while ($row=@mysql_fetch_object($rs)){
$data [] = $row;
}
$connections=json_encode($data);
echo $msg= "{'success': true,'message':'online users','online_users':'$connections'}";
Declare an array , paas all result of query in the array and use json_encode. Good Luck .
Comments
You can use this little PHP library. It sends the headers and give you an object to use it easily.
It looks like :
<?php
// Include the json class
include('includes/json.php');
// Then create the PHP-Json Object to suits your needs
// Set a variable ; var name = {}
$Json = new json('var', 'name');
// Fire a callback ; callback({});
$Json = new json('callback', 'name');
// Just send a raw JSON ; {}
$Json = new json();
// Build data
$object = new stdClass();
$object->test = 'OK';
$arraytest = array('1','2','3');
$jsonOnly = '{"Hello" : "darling"}';
// Add some content
$Json->addContent(new propertyJson('width', '565px'));
$Json->addContent(new textJson('You are logged IN'));
$Json->addContent(new objectJson('An_Object', $object));
$Json->addContent(new arrayJson("An_Array",$arraytest));
$Json->addContent(new jsonJson("A_Json",$jsonOnly));
// Finally, send the JSON.
json_send($Json)
?>