Full Stack LAMP - MEAN Developer, Python developer. Certified Azure Developer. Freelance programmer/consultant/trainer.

How to connect to Azure SQL Server with PHP

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.

try {    
    $hostname = 'your_host_name.database.windows.net';
    $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";

I hope you like this Post, Please feel free to comment below, your suggestion and problems if you face - we are here to solve your problems.

0 0 votes
Article Rating
Notify of

Inline Feedbacks
View all comments