连接到 Mac 上的 Microsoft SQL Server PHP


Connect to Microsoft SQL Server PHP on Mac

我有一台优胜美地的Macbook。我从苹果商店下载了一个应用程序来尝试运行PHP代码。我想连接到Microsoft SQL Server,这是代码:

$serverName = "astidbs";
$connectionInfo = array( "Database"=>"generale1", "UID"=>"xxxx", "PWD"=>"xxxx");
$conn = sqlsrv_connect($serverName, $connectionInfo);
if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}

这是错误:

Fatal error: Call to undefined function sqlsrv_connect() in /private/var/folders/t5/zjgg2nv149x48bqqdhvnllcw0000gn/T/com.kukosk.PHP-Code-Tester/PHP_Code_Tester_tempfile.php on line 5

我不明白这是否是应用程序问题,所以我在在线测试器上尝试了代码,但它也不起作用。错误相同,但没有路径。似乎没有指定调用的库,所以我在谷歌上搜索了如何安装它,但我无法解决问题。有人有解决方案吗?

尝试以下操作:

<?php
$myServer = "astidbs";
$myUser = "your_name";
$myPass = "your_password";
$myDB = "examples"; 
//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
  or die("Couldn't connect to SQL Server on $myServer"); 
//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
  or die("Couldn't open database $myDB"); 
//close the connection
mssql_close($dbhandle);
?>