在Mysql中插入JSON问题(ajax/php)

CREATE TABLE my_table (
    id INT PRIMARY KEY AUTO_INCREMENT,
    data JSON
);

var jsonData = {
    name: "John",
    age: 30,
    city: "New York"
};

$.ajax({
    url: "insert.php",
    type: "POST",
    data: { json: JSON.stringify(jsonData) },
    success: function(response) {
        console.log(response);
    }
});

<?php
// 获取AJAX请求中的JSON数据
$jsonData = $_POST['json'];

// 连接MySQL数据库
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 将JSON数据插入到数据库表中
$sql = "INSERT INTO my_table (data) VALUES ('$jsonData')";

if ($conn->query($sql) === TRUE) {
    echo "数据插入成功";
} else {
    echo "数据插入失败: " . $conn->error;
}

// 关闭数据库连接
$conn->close();
?>