Skip to content

Setup PHP 8.1 with sqlsrv & pdo_sqlsrv on Linux (Ubuntu 22.04) #1

@bibosalman456

Description

@bibosalman456

sudo apt-get update
sudo apt-get upgrade

sudo service packagekit restart
sudo apt-get update --fix-missing

sudo apt install lsb-release ca-certificates apt-transport-https software-properties-common -y
sudo add-apt-repository ppa:ondrej/php
sudo apt update

sudo dpkg --configure -a
sudo apt --fix-broken install

sudo apt update

sudo apt-get install php8.1 php8.1-fpm
sudo apt-get install php8.1-mysql php8.1-mbstring php8.1-xml php8.1-gd php8.1-curl
php -v
#SHOW (install success) :
#PHP 8.1.25 (cli) (built: Oct 27 2023 14:00:40) (NTS)
#Copyright (c) The PHP Group
#Zend Engine v4.1.25, Copyright (c) Zend Technologies
#with Zend OPcache v8.1.25, Copyright (c), by Zend Technologies

sudo apt-get update
sudo apt-get -y --no-install-recommends install apt-utils libxml2-dev gnupg apt-transport-https
sudo apt-get clean
sudo rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/* /usr/share/doc/*

sudo apt-get clean
sudo apt update

sudo apt install asc

sudo service packagekit restart
sudo apt-get update --fix-missing

sudo apt install php8.1-dev
sudo apt-get install libtool

curl https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor > microsoft.gpg
sudo mv microsoft.gpg /etc/apt/trusted.gpg.d/microsoft.gpg
sudo apt-get update
ACCEPT_EULA=Y sudo apt-get -y --no-install-recommends install msodbcsql17

sudo pecl install sqlsrv-5.11.1
sudo sh -c 'echo "extension=sqlsrv.so" >> $(php --ini | grep "Scan for additional .ini files" | sed -e "s|.:\s||")/30-sqlsrv.ini'

sudo pecl install pdo_sqlsrv-5.11.1
sudo sh -c 'echo "extension=pdo_sqlsrv.so" >> $(php --ini | grep "Scan for additional .ini files" | sed -e "s|.:\s||")/30-pdo_sqlsrv.ini'

php -S localhost:8080
SHOW (install success) :
[Fri Nov 24 16:53:11 2023] PHP 8.1.25 Development Server (http://localhost:8080) started

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions