php - Azure PHP 应用程序和 Azure SQL 数据库

Question

我在 Azure 上有一个 PHP 应用程序，我希望该应用程序连接到 Azure SQL 数据库。

$servername = "AZURE.database.windows.net";
$username = "user";
$password = "pass";
$dbname = "DB";

$conn= mssql_connect($servername,$username,$password, $dbname);

$sql = "INSERT INTO AOL (AgentId,FullName, Email)
VALUES ('1', 'Doe', '<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="f09a9f989eb09588919d809c95de939f9d" rel="noreferrer noopener nofollow">[email protected]</a>')";


mssql_query($sql, $conn);
mssql_close($conn);

当我运行这个 php 脚本时，出现 500 错误。

您有在 Azure 和 Azure SQL 数据库上使用 PHP 的经验吗？或者必须在 Azure 上为 Azure SQL 数据库设置某些内容？

Answer 1

默认情况下，Azure 环境不安装 php_mssql.dll 扩展，而是安装 php_sqlsrv.dll。

您可以使用 sqlsrv() 代替:

$serverName = "<servername>.database.windows.net, 1433"; //serverName\instanceName
$connectionInfo = array("Database" => "<database_name>", "UID" => "<userid>", "PWD" => "<passowrd>");
$conn = sqlsrv_connect($serverName, $connectionInfo);

if ($conn) {
    echo "Connection established.<br />";

    $query = sprintf("SELECT 1 as test");
    $stmt = sqlsrv_query($conn, $query);
    if ($stmt === false) {
        die(print_r(sqlsrv_errors(), true));
    }

    while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
        print_r($row);
    }

    sqlsrv_free_stmt($stmt);

} else {
    echo "Connection could not be established.<br />";
    die(print_r(sqlsrv_errors(), true));
}