How to fetch data with php from a mssql procedure

Question

Example:

CREATE PROCEDURE test (@age int) AS BEGIN
BEGIN TRAN

declare @flag int

if @age>20
begin
set @flag=1
end

else if @age<21
begin
set @flag=0
end

select @flag as flag

COMMIT TRAN
END

I need to fetch the @flag's value using php, how can I make this possible?

$row=mssql_fetch_array($r, MSSQL_ASSOC); $flag=$row['flag'];

EDIT: Never mind, it wasn't working because I forgot to delete some output queries in my procedure.

Thanks anyways ;)

Gordon Linoff · Accepted Answer · 2014-05-20 03:17:21Z

1

@flag is a local variable to the procedure. The best way to return a value is to use an output parameter:

CREATE PROCEDURE test (@age int, @flag int output) AS
BEGIN
    set @flag = (case when @age > 20 then 1 else 0 end);
END;

I don't see why a transaction would be necessary or desirable in this case.

answered May 20, 2014 at 3:17

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to fetch data with php from a mssql procedure

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related