Now I'm working on PHP+MSSQL.
So, I will use to get rows from database server.
And I'm typing on this code.
Code: Select all
<?php
$server = "host name";
$connectionInfo = array( "Database"=>"databasename", "UID"=>"id", "PWD"=>"password" );
$conn = sqlsrv_connect( $server, $connectionInfo );
$sql = "{call dbo.procedurename}";
$params = array();
$options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
$stmt = sqlsrv_query( $conn, $sql , $params, $options );
$row_count = sqlsrv_num_rows($stmt);
if ($row_count === false)
echo "Error in retrieveing row count.";
else
echo $row_count;
?>
Why did I get 0 rows?