1.下载Microsoft Drivers for PHP for SQL Server
查看各个版本的兼容性:Microsoft Drivers for PHP 支持矩阵 - PHP drivers for SQL Server | Microsoft Learn
本文的扩展插件下载:(https://wybing.lanzoui.com/iq7blho94rg)[https://wybing.lanzoui.com/iq7blho94rg]
解压后得到:
72 对应 php 7.2
73 对应 php 7.3
74 对应 php 7.4
在SQLSRV_Readme.htm文件中,可以找到相应的扩展:
把扩展文件加入到对应的php版本的配置文件(php.ini)中,
写个test.php文件,重启Apache或Nginx
<?php phpinfo();?>
查看扩展安装好没?
安装msodbcsql.msi
地址:https://www.microsoft.com/zh-CN/download/details.aspx?id=50420
测试连接
PHP 连接到 SQL的教程地址:https://docs.microsoft.com/zh-cn/sql/connect/php/step-3-proof-of-concept-connecting-to-sql-using-php?view=sql-server-ver15
function OpenConnection()
{
try
{
$serverName = "tcp:myserver.database.windows.net,1433";
$connectionOptions = array("Database"=>"AdventureWorks",
"Uid"=>"MyUser", "PWD"=>"MyPassword");
$conn = sqlsrv_connect($serverName, $connectionOptions);
if($conn == false)
die(FormatErrors(sqlsrv_errors()));
}
catch(Exception $e)
{
echo("Error!");
}
}