使用php将json数据保存在MySQL中

$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

// 使用mysqli扩展连接MySQL数据库
$conn = new mysqli($servername, $username, $password, $dbname);

// 使用PDO扩展连接MySQL数据库
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

// 使用mysqli扩展创建数据表
$sql = "CREATE TABLE json_data (
    id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    data JSON
)";

if ($conn->query($sql) === TRUE) {
    echo "Table created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}

// 使用PDO扩展创建数据表
$sql = "CREATE TABLE json_data (
    id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    data JSON
)";

if ($conn->exec($sql) === TRUE) {
    echo "Table created successfully";
} else {
    echo "Error creating table: " . $conn->errorInfo()[2];
}

$data = json_decode($json, true); // 将JSON数据解析为PHP数组

// 使用mysqli扩展插入JSON数据
$sql = "INSERT INTO json_data (data) VALUES ('" . $conn->real_escape_string(json_encode($data)) . "')";

if ($conn->query($sql) === TRUE) {
    echo "JSON data inserted successfully";
} else {
    echo "Error inserting JSON data: " . $conn->error;
}

// 使用PDO扩展插入JSON数据
$sql = "INSERT INTO json_data (data) VALUES (?)";
$stmt = $conn->prepare($sql);
$stmt->execute([json_encode($data)]);

if ($stmt->rowCount() > 0) {
    echo "JSON data inserted successfully";
} else {
    echo "Error inserting JSON data";
}

// 使用mysqli扩展查询JSON数据
$sql = "SELECT data FROM json_data";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $data = json_decode($row['data'], true); // 将JSON数据解析为PHP数组
        // 处理JSON数据
    }
} else {
    echo "No JSON data found";
}

// 使用PDO扩展查询JSON数据
$sql = "SELECT data FROM json_data";
$stmt = $conn->query($sql);

if ($stmt->rowCount() > 0) {
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $data = json_decode($row['data'], true); // 将JSON数据解析为PHP数组
        // 处理JSON数据
    }
} else {
    echo "No JSON data found";
}