php pdo 存储过程的返回所有结果,使用php / mysqli中的存储过程检索多个结果集

小编典典

我认为您在这里缺少什么(以下内容尚未经过测试)：

$stmt = mysqli_prepare($db, 'CALL multiples(?, ?)');

mysqli_stmt_bind_param($stmt, 'ii', $param1, $param2);

mysqli_stmt_execute($stmt);

// fetch the first result set

$result1 = mysqli_use_result($db);

// you have to read the result set here

while ($row = $result1->fetch_assoc()) {

printf("%d\n", $row['id']);

}

// now we're at the end of our first result set.

mysqli_free_result($result1);

//move to next result set

mysqli_next_result($db);

$result2 = mysqli_use_result($db);

// you have to read the result set here

while ($row = $result2->fetch_assoc()) {

printf("%d\n", $row['id']);

}

// now we're at the end of our second result set.

mysqli_free_result($result2);

// close statement

mysqli_stmt_close($stmt);

使用PDO您的代码如下所示：

$stmt = $db->prepare('CALL multiples(:param1, :param2)');

$stmt->execute(array(':param1' => $param1, ':param2' => $param2));

// read first result set

while ($row = $stmt->fetch()) {

printf("%d\n", $row['id']);

}

$stmt->nextRowset();

// read second result set

while ($row = $stmt->fetch()) {

printf("%d\n", $row['id']);

}

因此，根据您的PHP版本，您必须坚持使用mysqli-solution。顺便说一句：您是否故意使用程序样式？使用面向对象的样式mysqli将使您的代码看起来更具吸引力(我个人认为)。

2020-05-29