如何安裝Microsoft SQL Drivers在PHP中

Installing the Microsoft PHP Drivers 4.3 for SQL Server

安裝環境：

Ubuntu 16.04 for PHP 7.0

安裝步驟：

Step 1:
安裝PHP與相關的套件

 #apt-get -y install php7.0 mcrypt php7.0-mcrypt php-mbstring php-pear php7.0-dev php7.0-xml 

Step 2:
安裝編譯PHP SQLSRV, PDO_SQLSRV相關套件

 #curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
 #curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
 #apt-get update
 #ACCEPT_EULA=Y apt-get install msodbcsql mssql-tools 
 #apt-get install unixodbc-dev
 #'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
 #'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
 #source ~/.bashrc

Step 3:
安裝PHP SQLSRV, PDO_SQLSRV

 #pear config-set php_ini `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"` system
 #pecl install sqlsrv
 #pecl install pdo_sqlsrv

Step 4:
修改php.ini檔案，新增extension

 #echo "extension=sqlsrv.so" >> /etc/php/7.0/php.ini
 #echo "extension=pdo_sqlsrv.so" >> /etc/php/7.0/php.ini

Step 5:
確認主機語系設定

 #apt-get install -y locales && echo "en_US.UTF-8 UTF-8" > /etc/locale.gen && locale-gen

參考資料：

1. Microsoft PHP Driver for SQL Server