php怎么连接数据库2008,php连接sqlserver2008及以上版本数据库

sqlserver2008及以上版本,微软废弃了对php自带扩展的支持,需要单独安装微软官方提供的驱动

1.安装odbc driver

下载地址: https://www.microsoft.com/en-us/download/details.aspx?id=36434

安装时需给Documents and Settings\\Local Settings\Temp”文件夹的绝对控制权。添加everyone 安装后取消

2.安装Microsoft Drivers for PHP for SQL Server

下载地址 https://www.microsoft.com/en-us/download/details.aspx?id=20098

解压exe文件,拷贝对应版本的dll文件到php对应版本的ext目录,如

php_pdo_sqlsrv_56_nts.dll

php_pdo_sqlsrv_56_ts.dll

php_sqlsrv_56_nts.dll

php_sqlsrv_56_ts.dll

3.修改php.ini

extension=php_pdo_sqlsrv_56_nts.dll

extension=php_sqlsrv_56_nts.dll

4.连接sqlsever示例

sqlsrv_connect取代mssql_connect函数

$uid, "PWD"=>$pwd, "Database"=>"gps0310");

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

if( $conn == false)

{

echo "连接失败！";

var_dump(sqlsrv_errors());

exit;

}

else

{

echo "链接成功";

}