首页 > 解决方案 > PHP json_encode 既漂亮又非转义

问题描述

我正在尝试从 mysqli 数据库创建一个 .txt 文档,并且成功如下:

header('Content-disposition: attachment; filename='.$lang.'.txt');
header('Content-type: text/plain; charset=utf-8');

$jsonData = [];
$result = mysqli_query($con, "SELECT * FROM ReloadedSnippets WHERE app = $app AND type=0 ORDER BY id");
while ($row = mysqli_fetch_assoc($result)) {
    $snippetId = $row['id'];

    $result1 = mysqli_query($con,"SELECT * FROM ReloadedTranslations WHERE fk_snipId=$snippetId AND lang='$lang' AND app=$app");
    $row1 = mysqli_fetch_assoc($result1);

    $string1 = $row1["translation"];
    //$string1 = mysqli_real_escape_string($con,$string1);
    $jsonData[$row['snippet']] = $string1;
}

$jsonString = json_encode($jsonData, JSON_UNESCAPED_UNICODE);
echo $jsonString;

现在,我的问题是,所有内容都打印在我的 txt 文档中的一大行中!我想使用 JSON_PRETTY_PRINT,但是当我还需要使用 JSON_UNESCAPED_UNICODE 时,我该怎么做?

希望提前帮助和感谢:-)

标签: phpjsonmysqli

解决方案


推荐阅读