Output parameters seem to be populated after all result set are fetched using mssql_next_result(). However, mssql_execute seems to only return a valid result set resource on 'SELECT' queries, and not 'SELECT @param = expr' queries. The $result in a similar case is just 1.

In addition to my previous comment:
Windows XP SP1
MSSQL 2000
PHP Version => 4.3.2-dev
Build Date => Feb 26 2003 02:23:31
Server API => Apache 2.0 Filter

This too does not Work

PHPCode

$UserID = 'ADMIN';
$conn = mssql_connect("SERVER", "UID", "PASS"); 
mssql_select_db("DBANAME",$conn); 
$stmt = mssql_init("SELUser",$conn); 
mssql_bind($stmt,"@UserID",$UserID,SQLCHAR,false); mssql_bind($stmt,"@ReturnVal",$ReturnVal,SQLINT4,True); $result=mssql_execute($stmt); 
mssql_fetch_array($result); 
echo $ReturnVal; 

Stored Procedure

CREATE     PROCEDURE [SELUser]
	@UserID	CHAR(10),
	@ReturnVal INT OUTPUT
AS
BEGIN
	SELECT	*
	FROM 	[User]	USR
	WHERE	USR.[User ID]	= @UserID
	SET @ReturnVal=@@ROWCOUNT
END

I get the data in the resultset but not in the Output paramenter. I have used the Output parameter in different ways across the application. How can we get the output parameter populated.

Thanks

The version of PHP is use is 4.3.1 windows binary downloaded from the php.net site. The zip file date is 18-Feb-2003.
SQL Server 2000
OS Win 2000
Webserver Apache 4.0.44

Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip

There have been some fixes for mssql stuff in it..

forget my last comment, I didn't notice that you already
had tried the snapshot..

The documentation states that output variables have to be passed by reference into mssql_bind. Like this

mssql_bind($stmt,"@ReturnVal",&$ReturnVal,SQLINT4,True);

Also, the documentation also notes that if a stored procedure returns multiple result sets, the output parameters will _not_ be available until mssql_next_result has been called for the last result-set.

Does this have any effect on your test cases?

--Arnar

mssql_bind($stmt,"@ReturnVal",&$ReturnVal,SQLINT4,True);

does not work.

I have just testet this sample with the current CVS version.

This is my exact test code

<?php

if (!extension_loaded("mssql")) {
	dl("php_mssql.dll");
}

$conn = mssql_connect("asterix","web","webuser");

$stmt = mssql_init("AuthLoginUser", $conn);

$LoginUser = "frank";
$Password = "frank123";

mssql_bind($stmt,"@LoginUser",$LoginUser,SQLVARCHAR);
mssql_bind($stmt,"@Password",$Password,SQLVARCHAR);
mssql_bind($stmt,"@ReturnVal",&$ReturnVal,SQLINT4,True);

$result=mssql_execute($stmt);			

echo '<br><b>Return Value '.$ReturnVal.'</b>';

mssql_close($conn);

?>


And this is my output

Return Value 1

There is no problems with return values as far as I can telle.

mssql_bind($stmt,"@ReturnVal",&$ReturnVal,SQLINT4,True);
and
mssql_bind($stmt,"@ReturnVal",$ReturnVal,SQLINT4,True);

both works as the third parameter is forced to be BYREF.