今天工作需要连接sql server数据库,看了网上,要下载php_sqlsrv_73_nts_x64.dll等一系列驱动文件才可以.查了好久才找到文件并下载,好多文章里面都需要积分.
如果你是php7.2,php7.3,php7.4可以先用我网盘里面的
链接: https://pan.baidu.com/s/1xdHqcHgvZB6Dkc02eWp4MA 提取码: n3m8
下面我讲一下,其他php版本的获取方法
安装驱动(以windows系统为例)
1、打开 php.net,搜索关键词 sqlsrv
![](https://img.haomeiwen.com/i15400690/f92eea42097ae2a7.png)
![](https://img.haomeiwen.com/i15400690/61f073f9be5a3601.png)
![](https://img.haomeiwen.com/i15400690/6d869a7add1241e7.png)
![](https://img.haomeiwen.com/i15400690/200294daac6694b3.png)
![](https://img.haomeiwen.com/i15400690/716d95a93891b84f.png)
![](https://img.haomeiwen.com/i15400690/78e0ed74f3a23b2a.png)
![](https://img.haomeiwen.com/i15400690/b0c8429e24c9fe42.png)
2,安装好之后,将对应的dll文件拷贝到你的php安装目录php\php7.3.4nts\ext里面
3,在php.ini中配置好对应的dll路径即可
extension=php_sqlsrv_73_nts_x64.dll
extension=php_pdo_sqlsrv_73_nts_x64.dll
extension=php_sqlsrv_73_ts_x64.dll
extension=php_pdo_sqlsrv_73_ts_x64.dll
4,从https://www.microsoft.com/zh-CN/download/details.aspx?id=36434下载msi文件,并按照提示安装
5,重启服务器,输出phpinfo();看到下面即表示成功
![](https://img.haomeiwen.com/i15400690/13e8346c94abe793.png)
![](https://img.haomeiwen.com/i15400690/2cf35bb13cb9a840.png)
至此结束了.至于怎么连接数据库,在相应框架中连接即可
网友评论