PHP json_en code（）的while循环 [英] PHP json_encode() in while loop

问题描述

我想使用 json_en code（）在循环同时获得数据库结果。这里是我的code：

I am trying to use json_encode() in a while loop while getting database results. Here is my code:

<?

$database = sqlite_open("thenew.db", 0999, $error);
if(!$database) die($error);

$query = "SELECT * FROM users";
$results = sqlite_query($database, $query);
if(!$results) die("Canot execute query");

while($row = sqlite_fetch_array($results)) {
  $data = $row['uid'] . " " . $row['username'] . " " . $row['xPos'] . " " . $row['yPos'];
}
echo json_encode(array("response"=>$data));

sqlite_close($database);

?>

的这个输出是

{回应：lastUserID lastUser lastXPos lastYPos}

{"response":"lastUserID lastUser lastXPos lastYPos"}

我想这是...

{回应：亚历克斯1 10 12，2弗雷德27 59，3汤姆47 19]}

{"response":["1 Alex 10 12", "2 Fred 27 59", "3 Tom 47 19"]}

等。

所以我想在 json_en code（）函数把所有用户到阵列中，而不是最后一个。我会怎么做呢？谢谢

So I want the json_encode() function to put ALL users into the array rather than the last one. How would I do this? Thanks

推荐答案

尝试：

<?

$database = sqlite_open("thenew.db", 0999, $error);
if(!$database) die($error);

$query = "SELECT * FROM users";
$results = sqlite_query($database, $query);
if(!$results) die("Canot execute query");

$data = array();

while($row = sqlite_fetch_array($results)) {
  $data[] = $row['uid'] . " " . $row['username'] . " " . $row['xPos'] . " " . $row['yPos'];
}
echo json_encode(array("response"=>$data));

sqlite_close($database);

?>

这篇关于PHP json_en code（）的while循环的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！