javascript - 将 JSON 从 quill 导出到数据库

Question

亲爱的社区，美好的一天，

我正在尝试将JSONQuill 富文本编辑器放入MariaDB数据库。

JSON 形成

var form = document.querySelector('form');
form.onsubmit = function () {
var body = document.querySelector('input[name=body]');
body.value = JSON.stringify(quill.getContents());
};

从 PHP 到 SQL

require "db_connection.php";
    $id = $_POST["id"];
    $header = $_POST["header"];
    $body = $_POST["body"];
    $state = $_POST["state"];
    $worktime = $_POST["worktime"];
    $agent = $_POST["agent"];
    $creationDate = $_POST["creationDate"];
    $startDate = $_POST["startDate"];
    $endDate = $_POST["endDate"];
    $billed = $_POST["billed"];

    $sql = "UPDATE 
    `ticketsystem`.`ticket` 
SET 
    `header` = '$header', 
    `body` = '$body', 
    `state` = '$state', 
    `worktime` = '$worktime', 
    `agent` = '$agent', 
    `creationdate` = '$creationDate', 
    `startdate` = '$startDate', 
    `enddate` = '$endDate',
    `billed` = '$billed' 
WHERE 
    `ticket`.`id` = '$id';";
    mysqli_query($conn, $sql);

JSON：

{"ops":[{"attributes":{"bold":true},"insert":"Test Message"},{"insert":"\nThanks for reading.\n"}]}

如果我将它插入到数据库中，它看起来像这样：

{"ops":[{"insert":"asfggd
adsg
"}]}

到目前为止，我知道问题所在，但我没有找到解决方案......

标签： javascriptphpsqljsonquill