php 扩展sqlsrv调用mssql存储过程

1. $serverName = "127.0.0.1";
2. $connectionInfo = array( "UID"=>"sa","PWD"=>"","Database"=>"test");
3. $conn = sqlsrv_connect( $serverName, $connectionInfo);
4. if( $conn === false )
5. {
6. echo "Could not connect.\n";
7. die( print_r( sqlsrv_errors(), true));
8. }
9. $spnumber = '10655****00';
10. $chargenumber = '155****6789';
12. //参数需要以如下数组方式赋值并标明类型，SQLSRV_PARAM_IN是输入类型，SQLSRV_PARAM_OUT是输出类型。注意要按照存储过程定义的顺序赋值
13. $params = array(
14. array(&$spnumber, SQLSRV_PARAM_IN),
15. array(&$chargenumber, SQLSRV_PARAM_IN)
16. );
17. $tsql_callSP = "{call msgexpress_UnicomNewSubmit(?,?)}";
18. $stmt3 = sqlsrv_query( $conn, $tsql_callSP, $params);
19. if( $stmt3 === false )
20. {
21. echo "Error in executing statement 3.\n";
22. die( print_r( sqlsrv_errors(), true));
23. }

复制代码