php 显示对像编码,如何正确使用PHP将MySQL对象编码为JSON？

我试图迭代MySQL对象并在另一个页面上使用ajax调用来追加数据,但我无法让php将有效的JSON返回给回调.

这显然不起作用……

$db_host = "localhost";

$db_user = "blah";

$db_pass = "blah";

$db_name = "chat";

$mysqli = new MySQLi($db_host, $db_user, $db_pass, $db_name);

$myQuery = "SELECT * FROM users";

$result = $mysqli->query($myQuery) or die($mysqli->error);

$row = $result->fetch_assoc();

echo json_encode($row);

?>

或者这一个……

$db_host = "localhost";

$db_user = "blah";

$db_pass = "blah";

$db_name = "chat";

$mysqli = new MySQLi($db_host, $db_user, $db_pass, $db_name);

$myQuery = "SELECT * FROM users";

$result = $mysqli->query($myQuery) or die($mysqli->error);

while ( $row = $result->fetch_assoc() ){

echo json_encode($row) . ", ";

}

?>