trollolodn icon

#php #mysqli [Issue] Call stored with in/out parameters;

trollolodn | PRO | 02/04/13 09:08:09 AM UTC | 0 ⭐ | 165 👁️ | Never ⏰ | []
PHP |

580 B

|

None

|

0 👍

/

0 👎

//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