我使用PHP/MySQL运行查询并将其编码为JSON,但我不确定如何将JSON转换为我需要的形式。
这是我的PHP:
$myquery1 = "select 'links' as type, source, target, value from table";
$myquery2 = "select 'nodes' as type, name from table2";
$query = mysql_query($myquery1);
if ( ! $query ) {
echo mysql_error();
die;
}
$data = array();
for ($x = 0; $x < mysql_num_rows($query); $x++) {
$data[] = mysql_fetch_assoc($query);
}
//(and again for myquery2)
echo json_encode($data); //not sure how to combine queries here
我希望JSON按"类型"分组,像这样:
{
"links": [{"source":"58","target":"john","value":"95"},
{"source":"60","target":"mark","value":"80"}],
"nodes":
[{"name":"john"}, {"name":"mark"}, {"name":"rose"}]
}
任何帮助都是非常感激的。谢谢你! 你可以这样做:
$data = array(
"links" => array(),
"nodes" => array()
);
..
// for each link
$data["links"][] = mysql_fetch_assoc($query);
..
// for each node
$data["nodes"][] = mysql_fetch_assoc($query);
我认为mysql_fetch_assoc
添加每列两次,一次通过它的名称,一次通过它的索引,所以你会想要做一些修剪。即:
$row = mysql_fetch_assoc($query);
$data["links"][] = array(
"name" => $row["name"],
.. etc
)
在for循环条件下执行mysql_num_rows($query)
可能会出现问题。该值不会改变,但PHP必须在每次循环时运行该函数。缓存值或使用:
while (($row = mysql_fetch_assoc($res)) !== false) { .. }