connect azure

connect_azure.php

<?php

try {

    $conn = odbc_connect(
        "DRIVER={SQL Server};Server=tcp:ac1wr559wv.database.windows.net,1433;Database=1407_test",
        "project", "Plastic48");
    $cur = odbc_exec($conn, "select username, password, address from users");
    while (odbc_fetch_row($cur)) {
//collect results
        $username = odbc_result($cur, 1);
        $password = odbc_result($cur, 2);
        $firstName = odbc_result($cur, 3);
//format and display results
        print ("<p>$username, $password, $firstName</p>");

    }

//disconnect from database
    odbc_close($conn);


//    var_dump($conn);

} catch (Exception $e) {

    echo "<pre>";
    var_dump($e);

}




?>