PHP连接MsSQL 且解决中文乱码

环境: php 5.6.3 + Apache

<?php


header("Content-type:text/html;charset=UTF-8");
$serverName = "127.0.0.1"; //数据库服务器地址
$uid = "gamedata"; //数据库用户名
$pwd = "00000000"; //数据库密码
$connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"game2018");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn == false)
{
    echo "连接失败！";
    die( print_r( sqlsrv_errors(), true));
}else{
    echo "连接成功！"."<br>";
}






$query = sqlsrv_query($conn, "select count(*) from test_zf where userid=123");
$row = sqlsrv_fetch_array($query);
echo "充值次数: " . $row["0"]."<br>";




//调用存储过程，并填充参数
 
  $id=3;
  $userid=123;
  $name="搞事";
  $name=iconv("utf-8", "gbk", $name);  //解决中文乱码
	$params = array( 
                     array(&$id, 	 SQLSRV_PARAM_IN),
                     array(&$userid, SQLSRV_PARAM_IN),
					 array(&$name,   SQLSRV_PARAM_IN)
                   );
	$tsql_callSP = "{call [dbo].[test_php](?,?,?)}";  //调用存储过程，并填充参数
    $stmt3 = sqlsrv_query( $conn, $tsql_callSP, $params);
    if( $stmt3 == false )
    {
         echo "出现错误了:1:提示过程参数过多 仔细看是不是连接错库了"."<br>";
       
		die( print_r( sqlsrv_errors(), true));
    }
	echo "11111111111111";