Install Microsoft SQL Server PHP Driver on Ubuntu

install-sqlserver-php.md

Referensi Utama disini: https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15

sudo su
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

Download sesuai dengan versi OS yg digunakan ( detail ada di https://packages.microsoft.com/config/ubuntu/ )

curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
curl https://packages.microsoft.com/config/ubuntu/20.10/prod.list > /etc/apt/sources.list.d/mssql-release.list
curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list > /etc/apt/sources.list.d/mssql-release.list

exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install -y msodbcsql17
# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y apt-get install -y mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
# optional: for unixODBC development headers
sudo apt-get install -y unixodbc-dev

sudo apt-get -y install gcc g++ make autoconf libc-dev pkg-config

# Perintah pecl membutuhkan package php-pear
sudo apt install php-dev php-pear

# Jika tampil phpize tidak ada, jalankan cmd berikut (sesuai versi):
# sudo apt install php-dev
# sudo apt install php7.0-dev
# sudo apt install php7.2-dev

# https://pecl.php.net/package/sqlsrv
# For PHP 7.0
sudo pecl install sqlsrv-5.3.0

# For PHP 7.1 ( dapat dicoba juga sqlsrv-5.7.0preview )
sudo pecl install sqlsrv-5.6.1

# PHP 7.4
sudo pecl install sqlsrv-5.10.1

# PHP 8.0
sudo pecl install sqlsrv-5.11.1

# PHP 8.1 dan diatasnya
sudo pecl install sqlsrv

# Add this line (library) to php.ini
# extension=sqlsrv.so

# reoad/restart apache
sudo systemctl reload apache2
# Jika menggunakan PHP-FPM ( Nginx )
sudo service php7.2-fpm reload # Ubuntu
sudo systemctl restart php-fpm # CentOS