php 擴充sqlsrv調用mssql預存程序

<無詳細內容> $serverName = "127.0.0.1"; $connectionInfo = array( "UID"=>"sa","PWD"=>"","Database"=>"test"); $conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn === false ) { echo "Could not connect.\n"; die( print_r( sqlsrv_errors(), true)); } $spnumber = '10655****00'; $chargenumber = '155****6789'; //參數需要以如下數組方式賦值並標明類型，SQLSRV_PARAM_IN是輸入類型，SQLSRV_PARAM_OUT是輸出類型。注意要按照預存程序定義的順序賦值 $params = array( array(&$spnumber, SQLSRV_PARAM_IN), array(&$chargenumber, SQLSRV_PARAM_IN) ); $tsql_callSP = "{call msgexpress_UnicomNewSubmit(?,?)}"; $stmt3 = sqlsrv_query( $conn, $tsql_callSP, $params); if( $stmt3 === false ) { echo "Error in executing statement 3.\n"; die( print_r( sqlsrv_errors(), true)); } 複製代碼

