php连接sqlserver数据库

<?php


/*
 * Created on 2012-8-8
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */
//$server = "172.**.*.**";
//$username = "sa";
//$password = "123456";

//$server = "172.**.*.**";
//$username = "sa";
//$password = "as";
//$database = "test";

/*php5.2.17*/
//$conn = mssql_connect($server, $username, $password) or die("Couldn't connect to SQL Server on $server");
//
//print ("Connected successfully");
//$db = mssql_select_db($database) or die("Couldn't open database $database");
//$sql = "select * from user1";
//$rows = mssql_query($sql);
//while ($rs = mssql_fetch_assoc($rows)) {
//	echo $rs['name'] . "<br>";
//}
//$sql = "insert user1(name) values('中国130123456')";
//$rows = mssql_query($sql);

/*php5.3.6*/
$serverName = "172.**.*.**";
$uid = "sa";
$pwd = "123456";

//$serverName = "localhost";
//$uid = "sa";
//$pwd = "as";
$connectionInfo = array (
	"UID" => $uid,
	"PWD" => $pwd,
	"Database" => "SqlTest"
);
$conn = sqlsrv_connect($serverName, $connectionInfo);
if ($conn == false) {
	echo "连接失败！";
	die(print_r(sqlsrv_errors(), true));
}else{
	print ("Connected successfully");
}
$sql = "select * from emp";
$stmt = sqlsrv_query($conn,$sql);
if( $rows === false )
{
     echo "Error in statement preparation/execution.\n";
     die( print_r( sqlsrv_errors(), true));
}
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC))
{
      echo $row['ename']."\n";
}
//$sql = "insert user1(name) values('中国')";
//$rows = sqlsrv_query($conn,$sql);


?>