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.测试代码
<BR><?php <BR>$serverName = "127.0.0.1"; <BR>$connectionInfo = array("Database"=>"TestDB","UID<em style="color:transparent">本文来源[email protected]搞@^&代*@码)网9</em><strong>搞代gaodaima码</strong>"=>"test","PWD"=>"test"); <BR>$conn = sqlsrv_connect($serverName, $connectionInfo); <BR>if($conn) { <BR>echo "Connection established.<br>"; <BR>} else { <BR>echo "Connection could not be established.<br>"; <BR>die(print_r(sqlsrv_errors(), true)); <BR>exit(); <BR>} <BR>$sql = "select * from T_Employee"; <BR>$result = sqlsrv_query($conn,$sql); <BR>$data = array(); <BR>while($row=sqlsrv_fetch_array($result)) { <BR>$data[] = $row; <BR>} <BR>foreach($data as $p) { <BR>echo $p['Name']."<br>"; <BR>} <BR>sqlsrv_close($conn); <BR>echo "<br> Done <br>"; <BR>echo date("Y-m-d h:i:s"); <BR>?> <BR>
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：php下连接mssql2005的代码_php技巧
转载请注明原文链接：php下连接mssql2005的代码_php技巧
