PHP sql Server stored procedure PHP stored procedure
Title, hope to give a simple and clear example code and description.
Reply to discussion (solution)
http://hi.baidu.com/lei_com/item/232d6c56b6877e9709be1732
Look at this line no, there are many such tutorials on the web.
http://hi.baidu.com/lei_com/item/232d6c56b6877e9709be1732
Look at this line no, there are many such tutorials on the web. The following version of this tutorial should be available in PHP5.2, but I use PHP5.3.5, this version can not use the function of MSSQL. such as: Mssql_bind
Mssql_bind ($SP, "@user_name", $user _name,sqlvarchar,false,false,30); Mssql_bind ($SP, "@password", $password, sqlvarchar,false,false,30); Mssql_bind ($SP, "@info", $info, sqlvarchar,true,false,30); Add an output parameter for the stored procedure mssql_execute ($SP);//execute the stored procedure echo $info;//print out the output parameter values returned from the stored procedure
I changed the Mssql_bind function to Sqlsrv_bind and used it.