20,358
社区成员
发帖
与我相关
我的任务
分享
<?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);
?>
<?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();
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);
?>