使用mysqli_stmt_num_rows与foreach时的无数据提示异常问题求助

It sounds like the problem stems from two key missteps: you’re checking for missing data inside your loop (so every ID that returns 0 rows triggers the "未找到数据" message, even if other IDs have valid results), and you might be skipping a critical step when using mysqli_stmt_num_rows. Let’s break this down and fix it.

Common Mistake 1: Checking for No Data Per-ID Instead of After All Queries #

Right now, if your array has two IDs—one with results and one without—your code is likely showing the "未找到数据" message for the empty ID while also displaying results for the valid one. Instead, you should track whether any results were found across all IDs, then show the message only if none were found at all.

Common Mistake 2: Forgetting to Store the Result #

For prepared statements, you need to call mysqli_stmt_store_result() immediately after executing the statement before you can use mysqli_stmt_num_rows(). If you skip this step, num_rows will always return 0, even if there are matching rows in the database.

Corrected Example Code #

Here’s how to adjust your code to fix both issues:

// Initialize a flag to track if any results were found
$hasResults = false;

// Your array of IDs
$ids = [101, 202, 303];

// Prepare your statement once (outside the loop for better efficiency)
$stmt = mysqli_prepare($conn, "SELECT * FROM your_table WHERE id = ?");
mysqli_stmt_bind_param($stmt, "i", $id);

foreach ($ids as $id) {
    mysqli_stmt_execute($stmt);
    
    // Critical: Store the result set to access row count
    mysqli_stmt_store_result($stmt);
    
    if (mysqli_stmt_num_rows($stmt) > 0) {
        $hasResults = true;
        // Bind and fetch your results here
        mysqli_stmt_bind_result($stmt, $column1, $column2);
        while (mysqli_stmt_fetch($stmt)) {
            echo "找到匹配数据: $column1, $column2<br>";
        }
    }
    
    // Clear the result set for the next loop iteration
    mysqli_stmt_free_result($stmt);
}

// After processing all IDs, check if no results were found at all
if (!$hasResults) {
    echo "未找到数据";
}

// Clean up resources
mysqli_stmt_close($stmt);

Key Fixes Explained: #

• $hasResults Flag: This variable only gets set to true if any query returns rows. We check it after the entire loop finishes to decide whether to show the "未找到数据" message.
• mysqli_stmt_store_result(): This tells MySQL to store the result set in memory so we can accurately get the row count. Without it, mysqli_stmt_num_rows() won’t work as expected.
• Reusable Prepared Statement: Preparing the statement once outside the loop is more efficient than re-preparing it for every ID.

Give this a try—it should stop the mixed messages and only show "未找到数据" when none of your IDs return matching rows.

内容的提问来源于stack exchange，提问作者pippo