试图将查询结果转换为JSON格式并将其发送回我的手机(Android) - Trying to convert Query result into JSON format and send it back to my phone (Android)

Trying to convert Query result into JSON format and send it back to my phone (Android)

我试图查询mySql数据库在我的服务器上使用PHP以下是我的代码:

   <?php
    require 'phtry.php';
    $message = 1 ; //$_POST["message"]; 
    $query = "SELECT `surname`,`firstname` FROM `users`";

    $query1 = "SELECT * FROM  `users` WHERE id = $message";
   if ($query_run = mysql_query($query1)){
      //echo 'Success.';
      while ($query_row = mysql_fetch_assoc($query_run)){
      $surname = $query_row['surname'];
      $firstname = $query_row['firstname'];

}

$out [] = $query_row;
print(json_encode($out));
}else{
    echo 'No Success';
}

然而，语句print(json_encode($out));输出结果为[false]。谁能给我指个正确的方向?

将$out放入while循环中

if ($query_run = mysql_query($query1)){
 //echo 'Success.';
 while ($query_row = mysql_fetch_assoc($query_run)){
 $surname = $query_row['surname'];
 $firstname = $query_row['firstname'];
 $out[] = $query_row;
}
print(json_encode($out));
}else{
 echo 'No Success';
}