假设数据库中数据中author表只有三个字段:
firstnanme
lastname
email
nationality打算从库中取出数据后,以nationality来分类生成json,如下:
{ "China": [
{ "firstName": "Brett", "lastName":"McLaughlin", "email": "aaaa" },
{ "firstName": "Jason", "lastName":"Hunter", "email": "bbbb" },
{ "firstName": "Elliotte", "lastName":"Harold", "email": "cccc" }
],
"USA": [
{ "firstName": "Isaac", "lastName": "Asimov", "email": "eeee" },
{ "firstName": "Tad", "lastName": "Williams", "email": "ffff" },
{ "firstName": "Frank", "lastName": "Peretti", "email": "gggg" }
],
"France": [
{ "firstName": "Eric", "lastName": "Clapton", "email": "hhhh" },
{ "firstName": "Sergei", "lastName": "Rachmaninoff", "email": "wwwww" }
]
}数据库连接部分请忽略,就从select * from author之后,到了$rs,从这里开始吧
firstnanme
lastname
nationality打算从库中取出数据后,以nationality来分类生成json,如下:
{ "China": [
{ "firstName": "Brett", "lastName":"McLaughlin", "email": "aaaa" },
{ "firstName": "Jason", "lastName":"Hunter", "email": "bbbb" },
{ "firstName": "Elliotte", "lastName":"Harold", "email": "cccc" }
],
"USA": [
{ "firstName": "Isaac", "lastName": "Asimov", "email": "eeee" },
{ "firstName": "Tad", "lastName": "Williams", "email": "ffff" },
{ "firstName": "Frank", "lastName": "Peretti", "email": "gggg" }
],
"France": [
{ "firstName": "Eric", "lastName": "Clapton", "email": "hhhh" },
{ "firstName": "Sergei", "lastName": "Rachmaninoff", "email": "wwwww" }
]
}数据库连接部分请忽略,就从select * from author之后,到了$rs,从这里开始吧
foreach($list as $k => $v){
if($v['China']){
$list[$k]['China']= json_decode($v['China'], true);
}
}