if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
$post_data = array(
'item' => array(
'ID' => $row["id"],
'Name' => $row["name"],
'Category' => $row["category"],
'Saldo' => $row["saldo"],
'Editor' => $row["editor"],
'Edited' => $row["reg_date"]
)
);
echo json_encode($post_data);
输出:
{"item":{"ID":"123456","Name":"Chair","Category":"Trashes","Saldo":"40","Editor":"Seppo","Edited":"2015-09-15 13:54:36"}}{"item":{"ID":"123888","Nimi":"Cheese","Kategoria":"Food","Saldo":"3","Editor":"Jorma","Edited:"2015-09-15 14:14:17"}}
当它看起来像这样的时候:
[{"item":{"ID":"123456","Name":"Chair","Category":"Trashes","Saldo":"40","Editor":"Seppo","Edited":"2015-09-15 13:54:36"}},{"item":{"ID":"123888","Nimi":"Cheese","Kategoria":"Food","Saldo":"3","Editor":"Jorma","Edited:"2015-09-15 14:14:17"}}]
不是正确的json格式。我应该如何编辑代码,使我所有的mysql项目通过。
我已经想不出我甚至长时间盯着结果…
您将在每次迭代中重置$post_data。你应该把它加上去。
if ($result->num_rows > 0)
{
while($row = $result->fetch_assoc())
{
$post_data[] = array(
'item' => array(
'ID' => $row["id"],
'Name' => $row["name"],
'Category' => $row["category"],
'Saldo' => $row["saldo"],
'Editor' => $row["editor"],
'Edited' => $row["reg_date"]
)
);
}
echo json_encode($post_data);
}