求教连接数据库问题,win8.1(X64)+IIS+php5.5.23+sqlserver2008R2(x64)
本人新手刚学习PHP,遇到连接SQLSERVER2008R2数据库问题,环境win8.1(X64)+IIS8.5+php5.5.23+sqlserver2008R2(x64)
PHP文件能成功执行,但是执行phpinfo()并未发现sqlsrv,执行数据库连接后提示如下:
PHP Fatal error: Call to undefined function sqlsrv_connect() in E:\wwwroot\php.com\test\2.php on line 11
----------------代码如下---------------
<?php
$serverName = "(local)";
$uid ="sa";
$pwd = "mypwd123";
$connectionInfo = array("UID"=>$uid,"PWD"=>$pwd,"Database"=>"phpdb");
$conn = sqlsrv_connect( $serverName,$connectionInfo);
if( $conn == false)
{
echo "连接失败!";
die( print_r( sqlsrv_errors(), true));
}
?>
-------------------------------------------------------------------------
望高手指点迷津
php5.5.23 下载地址
http://windows.php.net/downloads/releases/php-5.5.24-nts-Win32-VC11-x64.zip
php_pdo_sqlsrv_55_nts.dll下载地址
The Microsoft Drivers 3.2 for PHP for SQL Server provide connectivity to Microsoft SQL Server from PHP applications
SQLSRV32.EXE
https://www.microsoft.com/en-us/download/details.aspx?id=20098
解压SQLSRV32.EXE后,拷贝php_pdo_sqlsrv_55_nts.dll和php_sqlsrv_55_nts.dll 到PHP安装目录ext
并且修改了php.ini的配置文件extension=php_sqlsrv_55_nts.dll
extension=php_pdo_sqlsrv_55_nts.dll
mssql.secure_connection = On
Microsoft ODBC Driver 11 for SQL Server - Windows
http://www.microsoft.com/zh-cn/download/confirmation.aspx?id=36434