PHP MSSQL Database Azure

Question

I am trying to get parse data from the SQL Database from Azure into a JSON using PHP. I have the php script on a free web hosting server. I recieve an ERROR when I am to connect to the Azure's SQL Database.

My PHP Script

<?php

 $serverName = "tcp:ss4rda587x.database.windows.net,1433";
 $connectionOptions = array("Database"=>"DistribuireColete",
 "Uid"=>"danielcocos26@ss4rda587x", "PWD"=>"******");

 //Establishes the connection
 $conn = sqlsrv_connect($serverName, $connectionOptions);

 //Select Query
 $tsql = "SELECT * FROM Clienti";

 //Executes the query
 $getProducts = sqlsrv_query($conn, $tsql);

        if (!$getProducts)
        {
            //Query failed
            echo("Nu merge");
        }

        else
        {
            $clienti = array(); //Create an array to hold all of the contacts
            //Query successful, begin putting each contact into an array of contacts

            while ($row = sqlsrv_fetch_array($stmt,SQLSRV_FETCH_ASSOC)) //While there are still contacts
            {
                //Create an associative array to hold the current contact
                //the names must match exactly the property names in the contact class in our C# code.
                $client = array("ID" => $row['IdClient'],
                                 "Name" => $row['NumeClient'],
                                 "Number" => $row['TelNumar'],
                                 "ImageBase64" => base64_encode($row['Icon'])
                                 );

                //Add the contact to the contacts array
                array_push($clienti, $client);
            }

            //Echo out the contacts array in JSON format
            echo json_encode($clienti);
        }
?>

And the ERROR I recieve

 Warning: sqlsrv_query() expects parameter 1 to be resource, boolean given in H:\root\home\cdan26-001\www\site1\GetClienti.php on line 14

astaykov · Accepted Answer · 2015-06-22 05:44:44Z

1

You need to:

Find out the public IP of your free web hosting provider (the public IP that your PHP script uses to make calls. And this with free web hosting provider means that this IP will most likely change on an irregular basis.
Check the Azure SQL Database Firewall rules and
Let the public IP of the free web hosting provider through your Azure SQL Database Firewall.

A small advice - you better use the free tier of Azure ~~Web Sites~~ Web Apps (http://azure.microsoft.com/en-us/services/app-service/web/) , instead of the free web hosting provider. At least you will not have issues with configuring the Azure SQL Database Firewall.

answered Jun 22, 2015 at 5:44

astaykov

30.8k3 gold badges72 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ming Xu - MSFT · Accepted Answer · 2015-06-22 09:40:05Z

1

I agree with astaykov, please set up 'allowed ip addresses' (your free web hosting provider's public ip) via Azure portal:

enter image description here

otherwise your web APP should print 'Nu merge' on the page. In addition, I have a bit confused in your code snippet:

$row = sqlsrv_fetch_array($stmt,SQLSRV_FETCH_ASSOC)

you may also want to change $stmt to $getProducts.

answered Jun 22, 2015 at 9:40

Ming Xu - MSFT

2,1161 gold badge11 silver badges13 bronze badges

Collectives™ on Stack Overflow

PHP MSSQL Database Azure

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related