如何使用PHP和MySQL处理大量的JSON数据？

// 读取JSON文件内容
$jsonData = file_get_contents('data.json');

// 将JSON数据转换为PHP数组
$data = json_decode($jsonData, true);

// 连接到MySQL数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

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

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

// 循环遍历数据数组，并将数据插入到数据库中
foreach ($data as $item) {
    $name = $item['name'];
    $age = $item['age'];
    $email = $item['email'];

    $sql = "INSERT INTO users (name, age, email) VALUES ('$name', $age, '$email')";

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

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

// 连接到MySQL数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

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

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

// 查询数据库中的JSON数据
$sql = "SELECT jsonData FROM users WHERE id = 1";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        // 将JSON数据转换为PHP数组
        $data = json_decode($row["jsonData"], true);

        // 对数据进行处理
        foreach ($data as $item) {
            $name = $item['name'];
            $age = $item['age'];
            $email = $item['email'];

            // 其他处理逻辑...
        }
    }
} else {
    echo "没有找到数据";
}

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