發表文章

目前顯示的是 1月, 2018的文章

如何安裝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 "ext