php7.0 mssql,Linux – PHP 7.0和MSSQL(Microsoft SQL)

Microsoft在PECL上为PHP 7及更高版本提供了用于SQL Server的PHP Linux驱动程序.这些都是准备好的.要下载它们,请按照下列步骤操作：

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*||"`

这将安装PHP SQL Server驱动程序并将其注册到php.ini文件夹中.

使用以下示例验证它是否有效

$serverName = "localhost";

$connectionOptions = array(

"Database" => "SampleDB",

"Uid" => "sa",

"PWD" => "your_password"

);

//Establishes the connection

$conn = sqlsrv_connect($serverName, $connectionOptions);

if($conn)

echo "Connected!"

?>

参考链接：