PHP sql query does not return table content

Question

I want to execute a simple sqlsrv_query query in php. To do so, I installed the MS Drivers and was able to establish a connection to my DB (SQL Server Management Studio 18.9.2). What I don´t understand is the message Resource id #3, which I believe is neither an failure or error. I expect a raw echo / print_r of the table content. What do I miss?

$sql = "SELECT * FROM nodes";
$stmt = sqlsrv_query($conn, $sql);

if ($stmt === false) {
    die (print_r(sqlsrv_errors(), true));
} else {
    while ($row = sqlsrv_fetch($stmt))
    print_r($row);
    print_r($stmt);
    echo "<br />Statement executed";
}

The table looks like:

Error I get:

Viktor Török · Accepted Answer · 2021-08-13 10:47:07Z

1

Try to use sqlsrv_fetch_array statement instead of the sqlsrv_fetch.

while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC))
{
    // print_r($row);
    print($row["nodes"] . "<br>");
}

edited Aug 13, 2021 at 10:47

answered Aug 13, 2021 at 10:32

Viktor Török

1,3291 gold badge9 silver badges12 bronze badges

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

3 Comments

Viktor Török Over a year ago

I think a better method can be using PDO instead of SQLSRV functions.

ICoded Over a year ago

thanks for your hint which I tested. The ressource #id 3 message is gone but I also do not receive any further result. Just pure blank, after the "Connection established" message.

Viktor Török Over a year ago

I modified the answer, try it please. I think the name of your column is "nodes".

Collectives™ on Stack Overflow

PHP sql query does not return table content

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related