Linux PHP连接sqlServer

末蓝、 2022-10-09 15:29 349阅读 0赞

本文主要介绍的是centOS7,如果是Debian的话省略步骤3，并且最后重启一下php即可

1.安装sqlServer 参考:[https://blog.csdn.net/m0\_37876935/article/details/112465558][https_blog.csdn.net_m0_37876935_article_details_112465558]

2.然后下载扩展文件:[https://github.com/microsoft/msphpsql/releases/tag/v5.9.0][https_github.com_microsoft_msphpsql_releases_tag_v5.9.0]

用phpinfo()查看扩展文件路径:

![20210625111430335.png][]

把扩展文件解压到这个路径

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfd194X2s_size_16_color_FFFFFF_t_70][]

然后打开php配置,写入:

extension=php\_sqlsrv\_73\_nts.so   
extension=php\_pdo\_sqlsrv\_73\_nts.so

3.安装unixODBC

执行命令 yum install unixODBC 和 yum install unixODBC-devel ,完成安装  
或者yum install -y *unixODBC*

*完了后配置路径:  **vim /etc/ld.so.conf,如下:*

include ld.so.conf.d/\*.conf \# 默认只有这一行

/usr/lib64

/usr/lib

/usr/local/lib

/usr/local/lib64

![20210625110834386.png][]

然后运行指令:ldconfig

4.查看是否成功:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfd194X2s_size_16_color_FFFFFF_t_70 1][]

5.重启环境如果程序报错

![20210625152211556.png][]

的话:

[https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017\#13.1][https_docs.microsoft.com_en-us_sql_connect_odbc_linux-mac_installing-the-microsoft-odbc-driver-for-sql-server_view_sql-server-2017_13.1]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfd194X2s_size_16_color_FFFFFF_t_70 2][]

执行完后测试:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfd194X2s_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfd194X2s_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfd194X2s_size_16_color_FFFFFF_t_70 5][]

[https_blog.csdn.net_m0_37876935_article_details_112465558]: https://blog.csdn.net/m0_37876935/article/details/112465558
[https_github.com_microsoft_msphpsql_releases_tag_v5.9.0]: https://github.com/microsoft/msphpsql/releases/tag/v5.9.0
[20210625111430335.png]: /images/20221005/a1b82978faea4b1095dca1e70b0af9ba.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfd194X2s_size_16_color_FFFFFF_t_70]: /images/20221005/82585da6fce44454a467d3da947347d3.png
[20210625110834386.png]: /images/20221005/2a6753b330ce486cb8e2f6bed16b6005.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfd194X2s_size_16_color_FFFFFF_t_70 1]: /images/20221005/7a7b89fa5e834b448af6ebcb5c54c12a.png
[20210625152211556.png]: /images/20221005/27fd1590ed9048d8bec66c33c61681ea.png
[https_docs.microsoft.com_en-us_sql_connect_odbc_linux-mac_installing-the-microsoft-odbc-driver-for-sql-server_view_sql-server-2017_13.1]: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017#13.1
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfd194X2s_size_16_color_FFFFFF_t_70 2]: /images/20221005/f7d44b35b05b458c8f1afd8772925246.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfd194X2s_size_16_color_FFFFFF_t_70 3]: /images/20221005/b8dd76a6434b48aeb8b8357872c5ca86.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfd194X2s_size_16_color_FFFFFF_t_70 4]: /images/20221005/022aa05e9a044af9ad5fe5cc84da2a9a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lfd194X2s_size_16_color_FFFFFF_t_70 5]: /images/20221005/eab02e11270b40549f0bc2528a06a61d.png