sqlserver存储过程调用_sqlserver 调用sap rfc-优快云博客

本文介绍如何使用PHP连接到SQL Server，并通过SQLSRV扩展调用存储过程。示例代码展示了设置连接参数、定义输入参数及执行存储过程的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

$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));

    }