Azure PHP Application and Azure SQL Database

Question

I have a PHP application on Azure and I want this application to connect to Azure SQL Database.

$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', '[email protected]')";


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

When I run this php script I get a 500 error.

Do you have experience with PHP on Azure and Azure SQL Database? Or must setting something on Azure for Azure SQL Database?

do you use Sql Azure? if so, make sure you have config your firewall rules to allow your site to connect to it. — Xiaomin Wu
– Xiaomin Wu, Commented Jan 12, 2016 at 22:22
yes, i using azure sql and firewall has rules for my websites :/ — Tomáš Jurásek
– Tomáš Jurásek, Commented Jan 12, 2016 at 22:35
What format are you using for username? Also, for clarification, since you're connecting to SQL Database service (and not MS SQL Server), I changed the tagging accordingly. — David Makogon
– David Makogon, Commented Jan 12, 2016 at 22:39
What does your table definition (especially column types) look like? — shoover
– shoover, Commented Jan 12, 2016 at 23:06

Gary Liu · Accepted Answer · 2016-01-13 04:08:02Z

3

By default, Azure environment doesn't install php_mssql.dll extension, it installs php_sqlsrv.dll instead.

You can use sqlsrv() instead:

$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));
}

answered Jan 13, 2016 at 4:08

Gary Liu

13.9k1 gold badge21 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Azure PHP Application and Azure SQL Database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related