我会用更多的代码少说话。
我有一个mySQL数据库,我想从它与PHP和PDO生成json。
<?php
require("db.php");
$dsn = "mysql:host=localhost;dbname=$dbname";
$pdo = new PDO($dsn, $username, $password);
$rows = array();
$stmt = $pdo->prepare("SELECT * FROM table");
$stmt->execute();
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo '{"jsons":';
echo json_encode($rows);
echo "}";
?>
以上代码将返回
{"jsons":[{"date_time":"2012-09-06 20:55:44","name":"theOne","message":"i am god","ip":"","device":"HTC","device_type":"Phone","class":"class1","id":"1"}]}
我想修改php代码,使json输出为
{"jsons":[{"date_time":"2012-09-06 20:55:44","name":"theOne","message":"i am god","ip":"","devs":{"device":"HTC","device_type":"Phone","class":"class1","id":"1"}}]}
不同之处在于我想将device
, device_type
, class
和id
嵌套到开发中。
我无法做任何事情,也无法从谷歌上找到这样的任务。
任何帮助都将是感激的。
谢谢。
$push_in_devs = array("device","device_type","class","id") ;
$old_set = json_decode('{"jsons":[{"date_time":"2012-09-06 20:55:44","name":"theOne","message":"i am god","ip":"","device":"HTC","device_type":"Phone","class":"class1","id":"1"}]}') ;
$old_object = $old_set->jsons[0] ;
$new_set = new STDClass() ;
$new_set->jsons = array(0 => new STDClass) ;
$new_object = $new_set->jsons[0] ;
foreach($old_object as $name => $value){
if (!in_array(strtolower($name), $push_in_devs))
$new_object->$name = $value ;
}
$new_object->devs = array() ;
$dev = array() ;
foreach($push_in_devs as $name){
$dev[$name] = $old_object->$name ;
}
$new_object->devs[] = $dev ;
echo json_encode($new_set) ;
在$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
行之后运行这个代码块:
foreach ($rows as $key => $row) {
foreach ($row as $column => value) {
if ($column == 'device' || $column == 'device_type' || $column == 'class' || $column == 'id') {
$row[$key]['devs'][$column] = $value;
} else {
$row[$key][$column] = $value;
}
}
}
这将在继续编码为JSON之前,在每行的'devs'键下嵌套值。
$results = array();
foreach ($rows as $row) {
$result = array();
foreach ($row as $key => $value) {
if ($key === 'device' || $key === 'device_type'
|| $key === 'class' || $key === 'id') {
$result['devs'][] = $value;
} else {
$result[$key] = $value;
}
}
$results[] = $result;
}
json_encode($results);