php - 如何循环遍历 mysqli_multi_query() 以找出哪些查询成功？

Question

我正在运行多个 UPDATE SQL 查询:

$queriesRun = mysqli_multi_query($connection, $queries);

现在，我如何循环遍历结果以了解哪些查询成功，哪些查询失败？ PHP手册让我很头疼，这么多的功能都是事后才能用的。

谢谢!

Answer 1

how do I loop through the results to know which queries succeeded and which failed?

int mysqli_stmt_affected_rows ( mysqli_stmt $stmt )和 bool mysqli_next_result ( mysqli $link )这是您正在寻找的 2 个函数。

<?php
    $mysqli = new mysqli("localhost", "my_user", "my_password", "world");

    /* check connection */
    if (mysqli_connect_errno()) {
        printf("Connect failed: %s\n", mysqli_connect_error());
        exit();
    }

    $query  = "SELECT CURRENT_USER();";
    $query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5";

    /* execute multi query */
    if ($mysqli->multi_query($query)) {
        do {
            /* store first result set */
            if ($result = $mysqli->store_result()) {
                while ($row = $result->fetch_row()) {
                    printf("%s\n", $row[0]);
                }
                $result->free();
            }
            /* print divider */
            if ($mysqli->more_results()) {
                printf("-----------------\n");
            }
        } while ($mysqli->next_result());
    }

    /* close connection */
    $mysqli->close();
    ?>

来自documentation .

如果您想使用程序风格，请查看文档中的示例。您只需使用 mysqli_more_results 或 $mysqli->next_result() 在各种查询之间切换。