PHP MySQL -检测数组查询中是否缺少行

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

if ($mysqli->connect_error) {
    die("连接失败: " . $mysqli->connect_error);
}

// 预期的ID数组
$expected_ids = [1, 2, 3, 4, 5];

// 查询数据库
$sql = "SELECT id FROM your_table";
$result = $mysqli->query($sql);

if ($result->num_rows > 0) {
    // 存储查询到的ID
    $found_ids = [];
    while($row = $result->fetch_assoc()) {
        $found_ids[] = $row["id"];
    }

    // 检测缺少的ID
    $missing_ids = array_diff($expected_ids, $found_ids);

    if (!empty($missing_ids)) {
        echo "缺失的ID有: " . implode(", ", $missing_ids);
    } else {
        echo "所有预期的ID都找到了。";
    }
} else {
    echo "没有找到任何行。";
}

// 关闭连接
$mysqli->close();
?>