php mssql_init,php調用mssql存儲過程

這裡給出實現方法，註釋就不多寫了，詳見php參考手冊[@more@]

sqlserver存儲過程

CREATE PROCEDURE ProcTest @id int, @name varchar(30) output CREATE PROCEDURE ProcTest @id int, @name varchar(30) output

AS

select @name=username from mm_user where id=@idselect @name=username from mm_user where id=@id

select * from mm_userselect * from mm_user

php實現代碼：

$userId = 2; // test parameter $userId = 2; // test parameter

$userName; // test return value $userName; // test return value

$link = mssql_connect("192.168.1.38", "sa", "sa123456a") or die("Can't connect sql server"); $link = mssql_connect("192.168.1.38", "sa", "sa123456a") or die("Can't connect sql server");

mssql_select_db("mm_db", $link) or die("Select database failure"); mssql_select_db("mm_db", $link) or die("Select database failure");

$stmt = mssql_init("ProcTest", $link) or die("initialize stored procedure failure"); $stmt = mssql_init("ProcTest", $link) or die("initialize stored procedure failure");

mssql_bind($stmt, "@id", $userId, SQLINT4); mssql_bind($stmt, "@id", $userId, SQLINT4);

mssql_bind($stmt, "@name", $userName, SQLVARCHAR, true); mssql_bind($stmt, "@name", $userName, SQLVARCHAR, true);

$rs = mssql_execute($stmt, false); $rs = mssql_execute($stmt, false);

do { do {

while ($row = mssql_fetch_array($rs)) { while ($row = mssql_fetch_array($rs)) {

print $row["id"]." ------ ".$row["username"]." ------ ".$row["password"]." ------

"; print $row["id"]." ------ ".$row["username"]." ------ ".$row["password"]." ------

";

}

} while (mssql_next_result($rs)); } while (mssql_next_result($rs));

print "user name is: ".$userName; print "user name is: ".$userName;

?>