链接:http://blog.csdn.net/silentbalanceyh/article/details/4349790
相关下载:http://download.csdn.net/detail/dl425134845/8313593
http://msdn.microsoft.com/en-us/library/cc296170.aspx
如何你用的是5.3.10线程安全版,请使用压缩包中的SQLSRV20中文件,虽然SQLSRV30也有支持5.3的,但是不行。
代码:
<!--http://msdn.microsoft.com/zh-cn/dd744859.aspx-->
<?php
$serverName = "IP地址,端口号";
$connectionInfo = array( "Database"=>"数据库名", "UID"=>"用户名", "PWD"=>"密码");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
echo "Connection established.<br />";
}else{
echo "Connection could not be established.<br />";
die( print_r( sqlsrv_errors(), true));
}
//$dbName = "rPing_CNLinkBMS";
//mssql_select_db($dbName, $conn);
$sql ="SELECT TOP 10 [CompanyID] ,[ContactID] FROM [ContactMaster]";
$res=sqlsrv_query($conn,$sql);
$arr =array();
while($row = sqlsrv_fetch_array($res))
{
$arr[] = $row;
}
print_r($arr);
?>