Skip to content

connect-query-php.md

Latest commit

 

History

History
112 lines (83 loc) · 6.38 KB

connect-query-php.md

File metadata and controls

112 lines (83 loc) · 6.38 KB
title Use PHP to query
description How to use PHP to create a program that connects to a database in Azure SQL Database or Azure SQL Managed Instance, and query it using T-SQL statements.
titleSuffix Azure SQL Database & SQL Managed Instance
services sql-database
ms.service sql-database
ms.subservice connect
ms.devlang php
ms.topic quickstart
author dzsquared
ms.author drskwier
ms.reviewer kendralittle, mathoma, v-masebo
ms.date 05/29/2020
ms.custom sqldbrb=2 , mode-other

Quickstart: Use PHP to query a database in Azure SQL Database

[!INCLUDEappliesto-sqldb-sqlmi]

This article demonstrates how to use PHP to connect to a database in Azure SQL Database or Azure SQL Managed Instance. You can then use T-SQL statements to query data.

Prerequisites

To complete this quickstart, you need:

Get server connection information

Get the connection information you need to connect to the database in Azure SQL Database. You'll need the fully qualified server name or host name, database name, and login information for the upcoming procedures.

  1. Sign in to the Azure portal.

  2. Navigate to the SQL Databases or SQL Managed Instances page.

  3. On the Overview page, review the fully qualified server name next to Server name for a database in Azure SQL Database or the fully qualified server name (or IP address) next to Host for an Azure SQL Managed Instance or SQL Server in an Azure VM. To copy the server name or host name, hover over it and select the Copy icon.

Note

For connection information for SQL Server on Azure VM, see Connect to a SQL Server instance.

Add code to query the database

  1. In your favorite text editor, create a new file, sqltest.php.

  2. Replace its contents with the following code. Then add the appropriate values for your server, database, user, and password.

    <?php
    $serverName = "your_server.database.windows.net"; // update me
    $connectionOptions = array(
        "Database" => "your_database", // update me
        "Uid" => "your_username", // update me
        "PWD" => "your_password" // update me
    );
    //Establishes the connection
    $conn = sqlsrv_connect($serverName, $connectionOptions);
    $tsql= "SELECT TOP 20 pc.Name as CategoryName, p.name as ProductName
         FROM [SalesLT].[ProductCategory] pc
         JOIN [SalesLT].[Product] p
         ON pc.productcategoryid = p.productcategoryid";
    $getResults= sqlsrv_query($conn, $tsql);
    echo ("Reading data from table" . PHP_EOL);
    if ($getResults == FALSE)
        echo (sqlsrv_errors());
    while ($row = sqlsrv_fetch_array($getResults, SQLSRV_FETCH_ASSOC)) {
     echo ($row['CategoryName'] . " " . $row['ProductName'] . PHP_EOL);
    }
    sqlsrv_free_stmt($getResults);
?>

Run the code

  1. At the command prompt, run the app.

    php sqltest.php

  2. Verify the top 20 rows are returned and close the app window.

Next steps