Yii2调用存程例子

$sqlProcedure = " CALL `p_Recharge`(:in_user_id, :in_recharge_id, :in_operate_type, :in_trade_no, :in_error_remark, @p5, @p6) ";
        $cmd = Yii::$app->db->createCommand($sqlProcedure);
        $cmd->bindParam(':in_user_id',$userId);
        $cmd->bindParam(':in_recharge_id',$userRechargeId);
        $cmd->bindValue(':in_operate_type',1); //1-成功，2-失败
        $cmd->bindParam(':in_trade_no',$tradeNo);
        $cmd->bindValue(':in_error_remark','');
        $res = $cmd->execute();
        
        $s = Yii::$app->db->createCommand(" SELECT @p5 AS `out_status`, @p6 AS `out_remark`");
        $ret = $s->queryOne();
        
        Yii::error($ret,'procedure');
        $userRecharge = UserRecharge::findOne(['id' => $userRechargeId]);
        
        if($ret['out_status'] == 1){
            $resultArray['ResultCode'] = 1;
            $resultArray['ResultMsg'] = '成功！';
        }else {
            $resultArray['ResultCode'] = -1;
            $resultArray['ResultMsg'] = '失败！';
        }