以下示例以Centos7.8 + PHP7.3 为例,可根据实际情况切换其他版本,注意版本之间的对应关系即可 第一步,安装Microsoft ODBC driver for SQL Server
通过 https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16 查询到支持php7.3版本的 Microsoft Drivers 版本为5.6和5.8,这里选择 5.6, 对应的 DOBC driver 版本 选择ODBC 17
sudo su#Download appropriate package for the OS version#Choose only ONE of the following, corresponding to your OS version#Red Hat Enterprise Server 7 and oracle Linux 7curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo#Red Hat Enterprise Server 8 and Oracle Linux 8#curl https://packages.microsoft.com/config/rhel/8/prod.repo > /etc/yum.repos.d/mssql-release.repoexitsudo yum remove unixODBC-utf16 unixODBC-utf16-devel #to avoid conflictssudo ACCEPT_EULA=Y yum install -y msodbcsql18# optional: for bcp and sqlcmdsudo ACCEPT_EULA=Y yum install -y mssql-tools18echo 'export PATH="$PATH:/opt/mssql-tools18/bin"' >> ~/.bashrcsource ~/.bashrc# optional: for unixODBC development headerssudo yum install -y unixODBC-devel
下载地址(5.6):
https://github.com/microsoft/msphpsql/releases/download/v5.6.1/CentOS7-7.3.tar
解压文件:
php -i | grep "Thread Safety"# Thread Safety => enabled
enabled
代表线程安全,使用 php_sqlsrv_73_ts.so
和 php_pdo_sqlsrv_73_ts.so
disabled
代表非线程安全,使用 php_sqlsrv_73_nts.so
和 php_pdo_sqlsrv_73_nts.so
查看扩展目录
php -i | grep "extension_dir"
将文件上传到扩展目录
可以使用xshell 拖动,或者ftp工具,此处略。
extension=php_sqlsrv_73_tsextension=php_pdo_sqlsrv_73_ts
sudo /etc/init.d/php-fpm restart
https://learn.microsoft.com/en-us/sql/connect/php/system-requirements-for-the-php-sql-driver
https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16
https://learn.microsoft.com/en-us/sql/connect/php/download-drivers-php-sql-server?view=sql-server-ver16
https://github.com/microsoft/msphpsql/releases/tag/v5.6.1
来源地址:https://blog.csdn.net/u010408289/article/details/127412093
--结束END--
本文标题: linux环境下php安装sqlsrv扩展连接mssql
本文链接: https://www.lsjlt.com/news/389299.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-03-01
2024-03-01
2024-03-01
2024-03-01
2024-03-01
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0