|
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.测试代码
<div class="codetitle"><a style="CURSOR: pointer" data="4215" class="copybut" id="copybut4215" onclick="doCopy('code4215')"> 代码如下:<div class="codebody" id="code4215">
<?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");
?>
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
