dslf46995 2017-03-16 03:36
浏览 17

PHP和Microsoft SQL Server的存储过程

I'm looking for a solution for my project with PHP and MSSQL (Stored Procedure)..I hope anyone can help me to fix it..Here my PHP code..what I want doing right now for register user function..My stored procedure :sp_register_info

<?php
    session_start();

    header('Content-type: text/json');
    header("Cache-Control: no-cache, must-revalidate");

    $name = $_REQUEST['data1'];
    $email = $_REQUEST['data2'];


    MSSQL();
    register_user($name,$email);

    function MSSQL(){
        require_once "../myDB.php";
            Connect_MSSQL();
    }

    function register_user($name,$email) {

            global $DBIn;

            $query =    "DECLARE @UserID varchar(20)".
                        "DECLARE @Name varchar(20)".
                        "DECLARE @Email varchar(200)".
                        "SET @Name = $name".
                        "SET @Email  = $email".
                        "EXEC sp_register_info @Name, @Email,@UserID OUTPUT".
                        "select @UserID";

            $data = array($name,$email);  

            $res =& $DBIn->query($query,$data);

            if ($res->numRows() > 0) {

                    while($row =& $res->fetchRow(DB_FETCHMODE_ASSOC)){
                            $UserID = $row['UserID'];
                    }
                    loadSuccess(UserID); 
            }

            else {

                    loadFailed();
            }

    }


    function loadSuccess($UserID) {

    header("Content-Type: application/json");
        exit(json_encode(array(

                    'UserID'    => $UserID,
                    'success'       => 'true',

        )));
    }
    function loadFailed(){

        exit(json_encode(array(

            'success'  => 'false',

        )));
    }       
?>

This code not work for me..

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Vue3 大型图片数据拖动排序
    • ¥15 划分vlan后不通了
    • ¥15 GDI处理通道视频时总是带有白色锯齿
    • ¥20 用雷电模拟器安装百达屋apk一直闪退
    • ¥15 算能科技20240506咨询(拒绝大模型回答)
    • ¥15 自适应 AR 模型 参数估计Matlab程序
    • ¥100 角动量包络面如何用MATLAB绘制
    • ¥15 merge函数占用内存过大
    • ¥15 使用EMD去噪处理RML2016数据集时候的原理
    • ¥15 神经网络预测均方误差很小 但是图像上看着差别太大