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

In this issue, the editor will bring you about how to install the pdo_sqlsrv extension in ubuntu. The article is rich in content and analyzes and describes it from a professional point of view. I hope you can get something after reading this article.

Install Microsoft source

Curl-s https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add-

Sudo bash-c "curl-s https://packages.microsoft.com/config/ubuntu/18.04/prod.list > / etc/apt/sources.list.d/mssql-release.list"

Sudo apt-get update

Install the driver

Sudo ACCEPT_EULA=Y apt-get-y install msodbcsql17 mssql-tools

Sudo apt-get-y install unixodbc-dev

Currently supports versions above php7

[download pdo_sqlsrv expansion pack http://pecl.php.net/package/pdo_sqlsrv]

Wget http://pecl.php.net/get/pdo_sqlsrv-5.3.0.tgz

And then decompress.

Tar-zxvf pdo_sqlsrv-5.3.0.tgz

Cd pdo_sqlsrv-5.3.0

[currently a pagoda, the path is as follows, use the corresponding php version of phpize]

/ www/server/php/70/bin/phpize

. / configure-- with-php-config=/www/server/php/70/bin/php-config

Make & & make install

70 represents the version number of php, if you are 7.1. Maybe the catalog is 71.

[add extension]

Echo "extension = pdo_sqlsrv.so" > > / www/server/php/70/etc/php.ini

/ etc/init.d/php-fpm-70 reload

[check whether the extension is installed successfully]

/ www/server/php/70/bin/php-m | grep-I sqlsrv

This is how to install the pdo_sqlsrv extension in the ubuntu shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.