Berikut langkah untuk install PHP7.4 dengan PDO SQLSRV dengan Ubuntu 18.04
Table of Contents
Install Repository
apt -y install software-properties-common add-apt-repository ppa:ondrej/php -y apt update
Install PHP
apt -y install php7.4-cli php7.4-mbstring php-pear php7.4-dev php7.4-gd php7.4-zip php7.4-xml
Install SQLCMD
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - curl https://packages.microsoft.com/config/ubuntu/18.04/prod.list | tee /etc/apt/sources.list.d/mssql-tools.list apt update ACCEPT_EULA=Y apt -y install msodbcsql17 echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc source ~/.bashrc apt -y install unixodbc-dev
Install SQLSRV Driver
pecl install sqlsrv pdo_sqlsrv printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.4/mods-available/sqlsrv.ini printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/7.4/mods-available/pdo_sqlsrv.ini phpenmod -v 7.4 sqlsrv pdo_sqlsrv