Shulou(Shulou.com)06/02 Report--

Centos7 lnmp architecture upgrade php to 7.2.33 connection mysql encountered problems, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

How php7.2 connects to mssql2005:

There are two ways for php to connect to mssql:

Open source: FreeTDS+DBLIB (supports sql2005)

Closed source: MS ODBC+SQLSRV (Microsoft official, only supports sql2008 and above)

Mainly talk about FreeTDS+DBLIB

Don't say much about the specific installation, refer to the article

Https://blog.csdn.net/a114469/article/details/85260066

Https://blog.csdn.net/shidb/article/details/84142226

Tell me about the problems encountered.

The 1.DBLIB version is too low.

Solution: use ius source for yum installation reference website: https://centos.pkgs.org/7/ius-x86_64/php72u-pdo-dblib-7.2.20-1.el7.ius.x86_64.rpm.html

1.Download latest ius-release rpm: https://centos7.iuscommunity.org/ius-release.rpm2.Install ius-release rpm:# rpm-Uvh ius-release*rpm3.Install php72u-pdo-dblib rpm package:# yum install php72u-pdo-dblib

Software conflicts may occur during the yum process, removing the old software before installing the new one.

After the installation is complete, add the following to php.ini:

Extension = / usr/lib64/php/modules/pdo_dblib.so

Restart lnmp, the test passed

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.