#php #mysqli [Issue] Call stored with in/out parameters;
//Call stored with in/out parameters;
public function executeParams2($prcName, $arrParams, $outParams = null, $isOutVar = false){
$res1;$res2;
/*
CALL prc_UserAccount_CheckUserExist('[email protected]',1,@kq,@kq1);
SELECT @kq;
*/
$stmt = $this->db->prepare("call $prcName (?,?,?)");
if (!$stmt)
{
echo $this->db->error;
}
$stmt->bind_param('sii', $arrParams[0], $arrParams[1], $res1);
$stmt->execute();
$result = $stmt->bind_result($res1);
$aaa = $stmt->fetch();
var_dump($res1);
}
Comments