> ## Content Index
> Fetch the complete content index at: https://sgpublic.xyz/llms.txt
> Use this file to discover other available public pages before exploring further.

# php7.x连接 SQLServer数据库（CentOS 7）
- URL: https://sgpublic.xyz/p/2021/05/6aac9cb1810a4800015335eb/
- Published: 2021-05-09T07:00:23.000Z
- Updated: 2021-05-09T07:00:23.000Z
- Author: Haven Madray
- Tags: 软件开发, #wp-post

> 转自 [PHP7.X连接SQLSERVER数据库（CENTOS7） - 大约 - 博客园 (cnblogs.com)](https://www.cnblogs.com/ytjjyy/p/8119708.html?ref=sgpublic.xyz)

加入微软的源

```
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssqlrelease.repo
```

防止冲突先卸载原有版本(可选)

```
yum remove unixODBC
```

安装驱动（三个都要装上，缺一不可）

```
yum install msodbcsql mssql-tools unixODBC-devel
```

下载pdo\_sqlsrv扩展包：[http://pecl.php.net/package/pdo\_sqlsrv](http://pecl.php.net/package/pdo%5Fsqlsrv?ref=sgpublic.xyz)

以4.0.8为例：

```
tar -zxvf pdo_sqlsrv-4.0.8.tgz
```

进入解压目录

```
cd pdo_sqlsrv-4.0.8
```

执行PHP的一个扩展命令

```
/usr/local/php/bin/phpize
```

编译

```
./configure --with-php-config=/usr/local/php/bin/php-config
```

安装

```
make && make install
```

修改 `/usr/local/php/etc/php.ini` 查找：`extension =` 再最后一个 `extension=` 后面添加上：

```
extension = "pdo_sqlsrv.so"
```