使用php在数据库中存储json对象

$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$jsonObject = array(
    "name" => "John Doe",
    "age" => 30,
    "email" => "john.doe@example.com"
);

$jsonString = json_encode($jsonObject);

$sql = "INSERT INTO your_table (json_data) VALUES ('$jsonString')";

if (mysqli_query($conn, $sql)) {
    echo "JSON object stored in the database successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

$sql = "SELECT json_data FROM your_table WHERE id = 1";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result);
    $jsonString = $row["json_data"];

    $jsonObject = json_decode($jsonString, true);

    // 访问JSON对象的属性
    echo $jsonObject["name"];
} else {
    echo "No JSON object found";
}

mysqli_close($conn);