php - JSON 为空，而数据库不为空

Question

我正在尝试使用 localhost 从数据库中使用 php 创建 json 文件。对于一个表“voteofthanks”，其工作绝对正常，但为另一个表编写类似的代码，生成的 json 文件为空 -> results.json。 Table for which it is working is:

创建其 json 的代码是:

<?php 
   define("DB_HOST", "localhost");
   define("DB_USER", "root");
   define("DB_PASSWORD", "");
   define("DB_DATABASE", "StageReady");
   $myConnection = mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD, DB_DATABASE) or die ("could not connect to mysql"); 
   $sqlCommand="SELECT id, content FROM voteofthanks ";
   $posts = array();
   $result=mysqli_query($myConnection, $sqlCommand) or die(mysql_error());
   while($row=mysqli_fetch_array($result)) 
   { 
       $title=$row['id']; 
       $url=$row['content']; 
       $posts[] = array('id'=> $title, 'content'=> $url);

   } 

     $fp = fopen('results.json', 'w');
    fwrite($fp, json_encode($posts));
    fclose($fp);
?> 

并且 localhost/JSON/results.json 显示正确

table "englishquotes" is here

现在对于表 englishquotes 我编写相同的代码

<?php 
   define("DB_HOST", "localhost");
   define("DB_USER", "root");
   define("DB_PASSWORD", "");
   define("DB_DATABASE", "StageReady");
   $myConnection = mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD, DB_DATABASE) or die ("could not connect to mysql"); 
   $sqlCommand="SELECT id, content FROM englishquotes ";
   $posts = array();
   $result=mysqli_query($myConnection, $sqlCommand) or die(mysql_error());
   while($row=mysqli_fetch_array($result)) 
   { 
     $title=$row['id']; 
     $url=$row['content']; 

     $posts[] = array('id'=> $title, 'content'=> $url);

    } 

   $fp = fopen('results.json', 'w');
   fwrite($fp, json_encode($posts));
    fclose($fp);

?> 

我在打开 localhost/english/results.json 时得到一个空白的白页

Answer 1

尝试在该行中使用htmlspecialchars()，

$posts[] = array('id'=> htmlspecialchars($title), 'content'=> htmlspecialchars($url));