php连接mssql 2005-优快云博客

本文详细介绍了如何在PHP环境中配置并使用SQL Server数据库，包括所需DLL文件的下载与放置、php.ini配置修改、sqlncli.msi安装步骤，以及通过示例代码展示如何建立连接、查询数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.测试代码

代码

<? php

$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 " );

?>

转载于:https://www.cnblogs.com/Jekhn/archive/2011/01/07/1929520.html