Posted by Arjun on Wednesday 19th December 2018

How to connect to Azure SQL Server with PHP

How to Azure SQL PHP DB Connect

This article demonstrates how to use PHP to connect to an Azure SQL database.

To connect to an Azure SQL or Any SQL server using PHP, you should install the required drivers based on your operating system. i.e you have to install the ODBC driver, then install the PHP Driver for SQL Server.

In this post, I am not going to cover the installation part but I will share PHP script, which you can use, to connect to your Azure SQL server.

<code>try {    
    $hostname = '';
    $dbname = 'database_name';
    $username = 'database_user';
    $pwd = 'database_password';
    $pdo = new PDO ("dblib:version=8.0;charset=UTF-8;host={$hostname};dbname={$dbname}", $username, $pwd);
    $query = "SELECT * FROM location";
    $statement = $pdo->prepare($query);
    $results = $statement->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    echo "Failed to get DB handle: " . $e->getMessage() . "\n";