Cannot Query MSSQL database with PHP7 + Microsoft Driver

Question

I have a problem querying my MSSQL database and PHP7 I use the new Microsoft driver. I got the following error: sqlsrv_query() expects parameter 1 to be resource, null given in /var/www/html/sqlFunctions.php on line 33

If I put the 2 functions together in one function it works According to the microsft examples it should work https://learn.microsoft.com/nl-nl/sql/connect/php/step-3-proof-of-concept-connecting-to-sql-using-php

function OpenConnection()  
{  
    try  
    {  
        $serverName = "devsql1";  
        $connectionOptions = array(
            "Database"=>"test",  
            "Uid"=>"test", 
            "PWD"=>"test"
            );  
        $conn = sqlsrv_connect($serverName, $connectionOptions); 

        if($conn == false)  
            die(FormatErrors(sqlsrv_errors()));  
    }  
    catch(Exception $e)  
    {  
        echo("Error!");  
    }  
}

  function ReadData()  
{  
    try  
    {  


        $conn = OpenConnection();

        $tsql = "SELECT [Corporatienaam] FROM tbl_Corporatie";  
        $getProducts = sqlsrv_query($conn, $tsql);  
        if ($getProducts == FALSE)  
            die(FormatErrors(sqlsrv_errors()));  
        $productCount = 0;  
        while($row = sqlsrv_fetch_array($getProducts, SQLSRV_FETCH_ASSOC))  
        {  
            echo($row['Corporatienaam']);  
            echo("<br/>");  
            $productCount++;  
        }  
        sqlsrv_free_stmt($getProducts);  
        sqlsrv_close($conn);  
    }  
    catch(Exception $e)  
    {  
        echo("Error!");  
    }  
}

OpenConnection doesn't return anything, so ReadData's $conn is null. — Jonnix
– Jonnix, Commented Feb 21, 2017 at 16:14

Michael Di Prisco · Accepted Answer · 2017-02-21 16:16:40Z

1

Your function OpenConnection is not returning any value, so $conn will be null when called. This should fix it:

function OpenConnection()  
{  
    try  
    {  
        $serverName = "devsql1";  
        $connectionOptions = array(
            "Database"=>"test",  
            "Uid"=>"test", 
            "PWD"=>"test"
            );  
        $conn = sqlsrv_connect($serverName, $connectionOptions); 

        if($conn == false)  
            die(FormatErrors(sqlsrv_errors()));  
        return $conn;
    }  
    catch(Exception $e)  
    {  
        echo("Error!");  
    }  
}

answered Feb 21, 2017 at 16:16

Michael Di Prisco

4064 silver badges13 bronze badges

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

2 Comments

Sven Hamers Over a year ago

Thanks, so obvious.

Michael Di Prisco Over a year ago

It happens, here to help.

Collectives™ on Stack Overflow

Cannot Query MSSQL database with PHP7 + Microsoft Driver

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related