PHP extension sqlsrv call MSSQL stored procedure

<无详细内容> $serverName = "127.0.0.1"; $connectionInfo = Array ("UID" = "sa", "PWD" and "" "," 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 '; The //parameter needs to be assigned a value as an array of type, sqlsrv_param_in is the input type, and sqlsrv_param_out is the output type. Note To assign a value in the order defined by the stored procedure $params = Array ( Array (& $spnumber, sqlsrv_param_in), Array (& $cha Rgenumber, sqlsrv_param_in) ); $tsql _callsp = "{call Msgexpress_unicomnewsubmit (?,?)}"; $stmt 3 = sqlsrv_query ($conn, $tsql _callsp, $params); if ($stmt 3 = = = False) { echo "Error in executing statement 3.\n"; die (Print_r (Sqlsrv_errors (), true)); } Copy Code

