类似这样的数组怎么把他换输出为JSON的格式:
这样的JOSN格式是不正确的如下:
{"identifier":"id","label":"name","items":[["1","Json"],["2","Bryan"],["3","Andy"],["4","dangany"]]}下面的是正确:{"label":"name","identifier":"id","items":[{"id":"1","name":"Json"},{"id":"2","name":"Bryan"},{"id":"3","name":"Andy"},{"id":"4","name":"dangany"}]}
请教-----》》
我的代码如下:<?php header("Content-type: text/html; charset=utf-8");
mysql_connect("localhost","root");
mysql_select_db("Json");
mysql_query("set names gb2312");
$sql="select * from A";
$info=mysql_query($sql);
$id=0;
$data=array();
while($Array=mysql_fetch_array($info)){
unset($Array["id"]);unset($Array["name"]);
$data[$id]=$Array;
$id++;
}
$json = array(
"identifier"=>"id",
"label"=>"name",
"items"=>$data,
);
echo json_encode($json);
?>
谢谢。
这样的JOSN格式是不正确的如下:
{"identifier":"id","label":"name","items":[["1","Json"],["2","Bryan"],["3","Andy"],["4","dangany"]]}下面的是正确:{"label":"name","identifier":"id","items":[{"id":"1","name":"Json"},{"id":"2","name":"Bryan"},{"id":"3","name":"Andy"},{"id":"4","name":"dangany"}]}
请教-----》》
我的代码如下:<?php header("Content-type: text/html; charset=utf-8");
mysql_connect("localhost","root");
mysql_select_db("Json");
mysql_query("set names gb2312");
$sql="select * from A";
$info=mysql_query($sql);
$id=0;
$data=array();
while($Array=mysql_fetch_array($info)){
unset($Array["id"]);unset($Array["name"]);
$data[$id]=$Array;
$id++;
}
$json = array(
"identifier"=>"id",
"label"=>"name",
"items"=>$data,
);
echo json_encode($json);
?>
谢谢。
低版本的看这里: http://www.luocheng.cn/article-view-190.html
另外你正确的格式中的items段应该是object~
而你的$data却是array~
改一下就可以了~
require_once('JSON.php');
$cjson = new Services_JSON(); $json = array(
"identifier"=>"id",
"label"=>"name",
"items"=>$data,
);$output = $cjson->encode($json);
php5.2以上版本
<?php
$json = array(
"identifier"=>"id",
"label"=>"name",
"items"=>$data,
);echo json_encode($json);
?>
<?phpheader("Content-type: text/html; charset=utf-8");
mysql_connect("localhost","root");
mysql_select_db("Json");
mysql_query("set names gb2312");
$sql="select * from A";
$info=mysql_query($sql);
$id=0;
$data=array();
class Person {} // person class
while($Array=mysql_fetch_array($info)){
//unset($Array["id"]);unset($Array["name"]);
// create person object
$person = new Person();
$person->id = $Array["id"];
$person->name = $Array["name"];
//$data[$id]=$Array;
$data[$id]=$person;
$id++;
}$json = array(
"identifier"=>"id",
"label"=>"name",
"items"=>$data,
);
echo json_encode($json);
?>
class person
{
public $id;
public $name;
}需要定义一下。