[求帮]php连接mssql的存储过程

[cyyjm]

php连接mssql的存储过程，没有结果，但是，这个存储过程在sql server上运行是有数据的。

<?php
header("Content-type:text/html;charset=utf-8");
date_default_timezone_set('UTC');

    $serverName="172.18.200.83, 1433";
    $connectionInfo = array("Database"=>"bigfootmis", "UID"=>"sjfx", "PWD"=>"test@123456", "CharacterSet"=>"utf-8");
    $conn = sqlsrv_connect($serverName, $connectionInfo);
    if($conn === false){
        die(print_r(sqlsrv_errors(), true));
    }
    $startMonth = '201901';
    $endMonth = '201902';
    //$startMonth=$_POST["startTime"];
   // $endMonth = $_POST["endTime"];
            $params = array( 
                     array(&$startMonth, SQLSRV_PARAM_IN),
                     array(&$endMonth, SQLSRV_PARAM_IN)
                   );   
    $sp = "{call p_hslxgb_xxzx(?,?)}";
    $stmt = sqlsrv_query($conn, $sp, $params);
    if($stmt === false){
        die(print_r(sqlsrv_errors(), true));
    }

    $arr = array();
    $n=0;
  while(  $row  =  sqlsrv_fetch_array (  $stmt ,  SQLSRV_FETCH_ASSOC ) ) {
        
          $arr[$n] = array(
                           'gsmc'=>$row [ 'gsmc' ],
                           'yssf'=>$row [ 'yssf' ],
                           'sssf'=>$row [ 'sssf' ] ,
                           'zzdk'=>$row [ 'zzdk' ] ,
                           'total_hsl'=>$row [ 'total_hsl' ] ,
                           'zz_hsl'=>$row [ 'zz_hsl' ] ,
                           'dk_hsl'=>$row [ 'dk_hsl' ] 
          );
          $n++;
  }
    echo json_encode($arr); 
sqlsrv_free_stmt (  $stmt );
    sqlsrv_close( $conn);

?>