Requesting Help in PHP ODBC Stored Procedure Calling

[tamilmani]

Hi Everyone,

 

This is Tamilmani Mohan , i have few doubts in SQL Stored Procedure.

 

I am able to run the SQL SP using odbc driver and also get the result set.

 

For Example: odbc_exec($connection,"exec get_Members");

 

I don't know how to run the input / output parameters SP's?

 

Example:-

If i run the below code by using SQL Management Visual Studio, I am able to insert to new record and get the member id and error code values.

 

declare @MemberId  int,@Error    int

   

EXEC INSERT_MEMBER 1,'Tamilmani','Mohan','Address1', 'Address2', 'Address3','Salem','Tamilnadu','India',9993234234 , @MemberId  OUTPUT ,  @Error    OUTPUT

 

SELECT @MemberId , @Error

 

I don't know how to run this type code in PHP ODBC ?

 

Kindly , please any one give me good suggestion for this problem ?

 

Thanks

Tamilmani Mohan

[gizmola]

I'm assuming this is ms sql server?  You need to use the mssql extension.