从php函数调用存储过程

Question

我想学习一些关于stored procedures的知识。我有一个php函数qcWaitingTags()。在这个函数中，我尝试调用一个stored procedure。但是当我从我的php文件调用该函数时，它有错误expect parameter 1 to be mysqli_result boolean...。但是如果我从这个函数中取出整个代码并直接使用它，那么它就可以工作了。有人知道我哪里做错了吗?

function qcWaitingTags(){
global $conn;
//    $totalQcWaitingQuery = "SELECT * FROM plannertags WHERE (status = '0' OR status = '2') AND currentStage = '12' AND assignedTo = '0' AND handoverStatus='0' AND failedStatus='0'";
$totalQcWaitingQuery = "CALL qcWaitingQuery()";
$totalQcWaitingQueryExecute = mysqli_query($conn, $totalQcWaitingQuery);
$totalQcWaitingTags = mysqli_num_rows($totalQcWaitingQueryExecute);
return $totalQcWaitingTags;
}

Answer 1

问题是由于使用全局变量期望，它将触发连接。但事实并非如此。我将连接文件包含在函数中，它正在工作

function qcWaitingTags(){
include "../../commonFilesForAll/db.php";
$totalQcWaitingQuery = "CALL qcWaitingQuery()"; //This is calling stored procedure
$totalQcWaitingQueryExecute = mysqli_query($conn, $totalQcWaitingQuery);
$totalQcWaitingTags = mysqli_num_rows($totalQcWaitingQueryExecute);
return $totalQcWaitingTags;
}