douyan4958 2016-06-14 01:37
浏览 64
已采纳

我找不到一个sqlsrv代码来执行PHP上的多个SQL查询,它们相互影响

Anyone can help me execute this 3 queries on php?

declare @result varchar(24);
 exec usp_UserLogin @aUser = '$_POST[user]', @aPassword = '$_POST[pass]', @aToken = @result out; 
select @result as token;

i need them to run one after each other, because as you can see, they need each other to work properly.

TY Nuno Santos

  • 写回答

2条回答 默认 最新

  • doupuchen6378 2016-06-14 22:12
    关注

    You need to execute one single query that contains those three lines, otherwise you get an error like undefined parameter. Think as you want to execute each of queries on separate SSMS query window.

    Your query will be executed step by step.

    $tsql= "declare @result varchar(24);
            exec usp_UserLogin @aUser = ?, @aPassword = ?, @aToken = @result out; 
            select @result as token;";
    
    $params = array($_POST[user], $_POST[pass]);
    
    $stmt = sqlsrv_query( $conn, $tsql, $params);
    

    If you want to check result of each step(seems unnecessary for this query), you should use transactions like BEGIN TRAN, COMMIT TRAN

    Reference: sqlsrv_query

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)
编辑
预览

报告相同问题?

悬赏问题

  • ¥15 PADS Logic 原理图
  • ¥15 PADS Logic 图标
  • ¥15 电脑和power bi环境都是英文如何将日期层次结构转换成英文
  • ¥20 气象站点数据求取中~
  • ¥15 如何获取APP内弹出的网址链接
  • ¥15 wifi 图标不见了 不知道怎么办 上不了网 变成小地球了
手机看
程序员都在用的中文IT技术交流社区

程序员都在用的中文IT技术交流社区

专业的中文 IT 技术社区,与千万技术人共成长

专业的中文 IT 技术社区,与千万技术人共成长

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

客服 返回
顶部