PHP7 - SQL Server

Question

I have the problem to retrieve information from SQL server database. But no problem to insert data.

this is the simple code:

$serverName = "xx.xx.xx.xx\SQLEXPRESS,1433";
$connectionOptions = array(
    "Database" => "Test",
    "Uid" => "User",
    "PWD" => "Password"
);

$connection = sqlsrv_connect($serverName, $connectionOptions);

if (!connection) {
    die("Database connection failed: " . mssql_get_last_message() ); 
} else {
    echo("Connected Successfully </br>" );
}

$sql = " INSERT INTO Imaging (ap) VALUES (1)"; 
$result = sqlsrv_query( $connection, $sql);

This code working perfectly.

But if I trying to retrieve data

$sql = "select ap from Imaging ";
$result = sqlsrv_query( $connection, $sql);

var_dump($result);

I have this result. Connected Successfully resource(2) of type (SQL Server Statement)

What is wrong?

Thank you

Connected Successfully resource(2) of type (SQL Server Statement) — Konstantin111
– Konstantin111, Commented Dec 7, 2017 at 16:52

IsThisJavascript · Accepted Answer · 2017-12-07 16:58:30Z

1

That's because $result is a resource;
From the man page of sqlsrv_fetch_array your code must be like so:

while( $row = sqlsrv_fetch_array( $result, SQLSRV_FETCH_ASSOC) ) {    
    echo $row['ap'];    
}

answered Dec 7, 2017 at 16:58

IsThisJavascript

1,7162 gold badges16 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

PHP7 - SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related