PHP mysql将表行与json数组进行比较

<?php
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

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

// 从数据库中获取表数据
$sql = "SELECT * FROM table_name";
$result = $conn->query($sql);

// 将表数据转换为关联数组
$tableData = array();
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $tableData[] = $row;
    }
}

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

// 要比较的JSON数组
$jsonArray = '[{"id": 1, "name": "John"}, {"id": 2, "name": "Jane"}, {"id": 3, "name": "Doe"}]';

// 将JSON数组转换为关联数组
$jsonData = json_decode($jsonArray, true);

// 比较表数据和JSON数据
foreach ($tableData as $row) {
    foreach ($jsonData as $jsonRow) {
        if ($row['id'] == $jsonRow['id'] && $row['name'] == $jsonRow['name']) {
            echo "表行与JSON数组匹配：ID: " . $row['id'] . ", Name: " . $row['name'] . "<br>";
        }
    }
}
?>