Linux – PHP 7.0 and MSSQL (Microsoft SQL)

by

Microsoft has PHP Linux Drivers for SQL Server for PHP 7 and above on PECL. These are production ready. To download them, follow these steps:

Ubuntu 16.04:

sudo su 
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
exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install -y msodbcsql mssql-tools unixodbc-dev
sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv
echo "extension=sqlsrv" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`
echo "extension=pdo_sqlsrv" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`

CentOS 7:

sudo su
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
exit
sudo yum update
sudo ACCEPT_EULA=Y yum install -y msodbcsql mssql-tools unixODBC-devel 
sudo yum groupinstall "Development Tools"
sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv
echo "extension=sqlsrv" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`
echo "extension=pdo_sqlsrv" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`

This will install the PHP SQL Server Drivers and register them in the php.ini folder.

Verify that it works by using the following sample

<?php
$serverName = "localhost";
$connectionOptions = array(
    "Database" => "SampleDB",
    "Uid" => "sa",
    "PWD" => "your_password"
);
//Establishes the connection
$conn = sqlsrv_connect($serverName, $connectionOptions);
if($conn)
    echo "Connected!"
?>

Links for reference:

More Related Contents:

  1. Connect PHP to MSSQL via PDO ODBC
  2. CodeIgniter MSSQL connection
  3. UTF-8 all the way through
  4. How to escape strings in SQL Server using PHP?
  5. Run process with realtime output in PHP
  6. Running a Python script from PHP
  7. PHP Elvis operator vs null coalescing operator
  8. PHP passing $_GET in the Linux command prompt
  9. Why I am suddenly getting a “Typed property must not be accessed before initialization” error when introducing properties type hints?
  10. How can I enable the MySQLi extension in PHP 7?
  11. How can I detect a create, update, delete query is successful in Codeigniter
  12. Connect to SQL Server through PDO using SQL Server Driver
  13. Troubleshooting PHP Mail [duplicate]
  14. How do I get the SQLSRV extension to work with PHP, since MSSQL is deprecated?
  15. Notice: Array to string conversion in
  16. Extract text from doc and docx
  17. How do I throttle my site’s API users?
  18. PHP + SQL Server – How to set charset for connection?
  19. “Adaptive Server is unavailable or does not exist” error connecting to SQL Server from PHP
  20. Checking if process still running?
  21. PHP exec – check if enabled or disabled
  22. How to use PHP to connect to sql server
  23. Nullable return types in PHP7
  24. How can I change php-cli version on Ubuntu 14.04?
  25. How to connect PHP with Microsoft Access database
  26. How can I execute PHP code from the command line?
  27. PHP 7 and strict “resource” types
  28. ODBC prepared statements in PHP
  29. json_encode produce JSON_ERROR_UTF8 from MSSQL-SELECT
  30. SQL Server error 1934 occurs on INSERT to table with computed column PHP/PDO

Leave a Comment