\n

sudo phpdismod -v 7.3 sqlsrv pdo_sqlsrv<\/p>\n

sudo apt-get -y install php-pear php7.4-dev
\nsudo update-alternatives –set php \/usr\/bin\/php7.4
\nsudo update-alternatives –set phar \/usr\/bin\/phar7.4
\nsudo update-alternatives –set phar.phar \/usr\/bin\/phar.phar7.4
\nsudo update-alternatives –set phpize \/usr\/bin\/phpize7.4
\nsudo update-alternatives –set php-config \/usr\/bin\/php-config7.4<\/p>\n

sudo pecl uninstall -r sqlsrv
\nsudo pecl uninstall -r pdo_sqlsrv<\/p>\n

apt-get install unixodbc-dev
\nsudo pecl -d php_suffix=7.4 install sqlsrv
\nsudo pecl -d php_suffix=7.4 install pdo_sqlsrv
\nsudo su
\nprintf “; priority=20\\nextension=sqlsrv.so\\n” > \/etc\/php\/7.4\/mods-available\/sqlsrv.ini
\nprintf “; priority=30\\nextension=pdo_sqlsrv.so\\n” > \/etc\/php\/7.4\/mods-available\/pdo_sqlsrv.ini
\nexit
\nsudo phpenmod -v 7.4 sqlsrv pdo_sqlsrv
\nsudo service apache2 restart<\/p>\n

php -m | grep sql<\/p>\n

# \u7981\u7528 PHP 8.1
\nsudo a2dismod php8.1<\/p>\n

#
\n\u7981\u7528\u8f38\u51fa\u6a21\u584a PHP 8.1\u3002
\n\u8981\u6fc0\u6d3b\u65b0\u914d\u7f6e\uff0c\u60a8\u9700\u8981\u904b\u884c\uff1a
\nsystemctl restart apache2<\/p>\n

# Enable PHP 7.4
\nsudo a2enmod php7.4<\/p>\n

# Output
\nConsidering dependency mpm_prefork for php8.0:
\nConsidering conflict mpm_event for mpm_prefork:
\nConsidering conflict mpm_worker for mpm_prefork:
\nModule mpm_prefork already enabled
\nConsidering php8.0 \u7684 php5 \u885d\u7a81\uff1a
\n\u555f\u7528\u6a21\u584a php8.0\u3002
\n\u8981\u6fc0\u6d3b\u65b0\u914d\u7f6e\uff0c\u60a8\u9700\u8981\u904b\u884c\uff1a
\nsystemctl restart apache2<\/p>\n

# Restart Apache Web Server
\nsudo service apache2 restart<\/p>\n<\/blockquote>\n<\/div>

Shell Script<\/p>\n<\/div>


\n#!\/bin\/bash<\/code><\/p>\n

#ubuntu 20.04
\n#php8.1<\/p>\n

# install php ppa
\napt -y install software-properties-common
\nadd-apt-repository ppa:ondrej\/php -y
\napt update<\/p>\n

# install php w\/o apache
\napt -y install php8.1-cli php8.1-mbstring php-pear php8.1-dev php8.1-curl php8.1-gd php8.1-zip php8.1-xml<\/p>\n

# install sqlcmd
\ncurl https:\/\/packages.microsoft.com\/keys\/microsoft.asc | apt-key add –
\ncurl https:\/\/packages.microsoft.com\/config\/ubuntu\/20.04\/prod.list | tee \/etc\/apt\/sources.list.d\/mssql-tools.list
\napt update
\nACCEPT_EULA=Y apt -y install msodbcsql17
\necho ‘export PATH=”$PATH:\/opt\/mssql-tools\/bin”‘ >> ~\/.bash_profile
\necho ‘export PATH=”$PATH:\/opt\/mssql-tools\/bin”‘ >> ~\/.bashrc
\nsource ~\/.bashrc
\napt -y install unixodbc-dev<\/p>\n

# install sqlsrv driver
\n# if this fails install sqlsrv-5.5.0preview & pdo_sqlsrv-5.5.0preview
\npecl install sqlsrv pdo_sqlsrv
\nprintf “; priority=20\\nextension=sqlsrv.so\\n” > \/etc\/php\/8.1\/mods-available\/sqlsrv.ini
\nprintf “; priority=30\\nextension=pdo_sqlsrv.so\\n” > \/etc\/php\/8.1\/mods-available\/pdo_sqlsrv.ini
\nphpenmod -v 8.1 sqlsrv pdo_sqlsrv<\/p>\n<\/div><\/div><\/div>