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

Question

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

Answer 1

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