How to install MSSQL extension for PHP in CentOS7

This article will introduce to you how to install MSSQL extension for PHP in CentOS7. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to everyone.

1. Download freetds

and execute the following scripts in sequence:

cd /usr/local/src/
wget ftp://ftp.freetds.org/pub/freetds/stable/freetds-patched.tar.gz
tar -zxvf freetds-patched.tar.gz

That is, enter / usr/local/src directory (I usually put the source code used for compilation here), download the source code of freetds, and then unzip it.

2. Install freetds

Execute the following scripts in sequence:

cd freetds-1.2/
./configure --prefix=/usr/local/freetds --with-tdsver=7.4 --enable-msdblib
make && make install

Pay attention to the above freetds-1.2, according to your own Depending on the downloaded version of freetds, this may be different. Anyway, just enter the folder you got after unzipping it. Then --with-tdsver=7.4 Here, you can choose flexibly according to the different versions of SqlServer. You can refer to the picture below to choose by yourself. I am using SqlServer 2012 , so the 7.4 version selected:

The content selected for the above version comes from the official document of freetds, the document address: https: //www.freetds.org/userguide/ChoosingTdsProtocol.html

3. Configurationfreetds

Execute the following commands in sequence to initialize the freetds configuration:

echo "/usr/local/freetds/lib/" > /etc/ld.so.conf.d/freetds.conf
ldconfig

Other configurations are not required. There are some tutorials on the Internet about configuring the connection information of MSSQL in freetds.conf. In fact, it is not necessary. You can configure it when calling, that is, configure it in the PHP code. This is so flexible.

4. Testfreetds

Execute the following command to view the freetds version:

# /usr/local/freetds/bin/tsql -C
Compile-time settings (established with the "configure" script)
                            Version: freetds v1.2
             freetds.conf directory: /usr/local/freetds/etc
     MS db-lib source compatibility: yes
        Sybase binary compatibility: no
                      Thread safety: yes
                      iconv library: yes
                        TDS version: 7.4
                              iODBC: no
                           unixodbc: no
              SSPI "trusted" logins: no
                           Kerberos: no
                            OpenSSL: yes
                             GnuTLS: no
                               MARS: yes

Execute the following command to testfreetds Connection:

# /usr/local/freetds/bin/tsql -H example.com -p 1433 -U username -P password
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
1> select @@version
2> go

Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
	Feb 10 2012 19:39:15
	Copyright (c) Microsoft Corporation
	Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)

(1 row affected)

where example.com is the host address of MSSQL, username and password are the username and password of MSSQL respectively.

5. Download PHP-5.6.40 Source code

Execute the following scripts in sequence:

cd /usr/local/src/
wget https://www.php.net/distributions/php-5.6.40.tar.gz
tar -zxvf php-5.6.40.tar.gz

is the same as downloading freetds above , we won’t go into details here.

6. Install PHP-5.6.40-MSSQL Extension

Execute the following scripts in sequence:

cd php-5.6.40/ext/mssql/
/www/server/php/56/bin/phpize
./configure --with-php-config=/www/server/php/56/bin/php-config --with-mssql=/usr/local/freetds/
make && make install

/www/server above /php/56/bin/ path, because the installation path of php used in Pagoda is this, so the path is written like this. You can adjust it according to your own situation.

Get output similar to the following, indicating that the extension installation is complete:

...
Build complete.
Don't forget to run 'make test'.

Installing shared extensions:     /www/server/php/56/lib/php/extensions/no-debug-non-zts-20131226/

7. Modify php.ini

You can modify it as you like here , I directly used the Pagoda front-end to modify it, without using the command line. Add the following lines in php.ini:

[mssql]
extension=mssql.so

Save the changes after completing them, and then restart the php service.

Check phpinfo, you can see that the mssql extension has been enabled.

Done.

Recommended learning: php video tutorial

The above is the detailed content of How to install MSSQL extension for PHP in CentOS7. For more information, please follow other related articles on the PHP Chinese website!