php5.2连接mssql2005,php下连接mssql2005的代码

1.下载以下两个文件,放入php ext目录及system32

php_sqlsrv_52_ts_vc6.dll (线程安全)

php_sqlsrv_52_nts_vc6.dll (非线程安全)

vc6用于Apache,vc9用于IIS

2.修改php.ini

extension=php_sqlsrv_52_ts_vc6.dll

3.下载sqlncli.msi，微软官方可以下

安装的时候提示是sql server 2008的，不过2005也是可以用的。

4.测试代码

$serverName = "127.0.0.1";

$connectionInfo = array("Database"=>"TestDB","UID"=>"test","PWD"=>"test");

$conn = sqlsrv_connect($serverName, $connectionInfo);

if($conn) {

echo "Connection established.
";

} else {

echo "Connection could not be established.
";

die(print_r(sqlsrv_errors(), true));

exit();

}

$sql = "select * from T_Employee";

$result = sqlsrv_query($conn,$sql);

$data = array();

while($row=sqlsrv_fetch_array($result)) {

$data[] = $row;

}

foreach($data as $p) {

echo $p['Name']."
";

}

sqlsrv_close($conn);

echo "
Done
";

echo date("Y-m-d h:i:s");

?>