Shows how to connect to an Azure database using SQLSRV and PHP to get all of the data from a specified table and print each 'FIELDNAME' that we got from the db

Azure DB Connect

<?php
	if (!extension_loaded("sqlsrv")) 
	{
		die("SQLSRV hasn't been loaded.");
	}
	// Connection details
	$server = "tcp:<FULL SERVER ADDRESS>, <PORT>";
	$user = "<DB USER>@<SERVER ADDRESS>";
	$pwd = "<PASS>";
	$db = "<DB NAME>";
	$conn = sqlsrv_connect($server, array("UID"=>$user, "PWD"=>$pwd, "Database"=>$db));
    
	// Ensure that the connection is successful.
	
	if($conn == false){
		die(print(sqlsrv_errors()));
	}
    	
    	// NOTE!: YOU NEED TO ADD THE SCHEMA NAME IN FRONT OF THE TABLE NAME!
	$tsql = "SELECT * FROM SCHEMA.TABLENAME";
	$stmt = sqlsrv_query( $conn, $tsql);
           
	// If the statement fails, we'll kill the process.
           
	if( $stmt === false)
	{
		echo "Error: \n";
		die( print_r( sqlsrv_errors(), true));
	}           
           
	// Print each 'FIELDNAME' value from the DB
           
	while($row = sqlsrv_fetch_array($stmt))
	{    
		echo ($row['FIELDNAME']);
	}
?>