sqlsrv_num_rows Not Returning Any Value

by

It is because sqlsrv_query() uses SQLSRV_CURSOR_FORWARD cursor type by default. However, in order to get a result from sqlsrv_num_rows(), you should choose one of these cursor types below:

  • SQLSRV_CURSOR_STATIC
  • SQLSRV_CURSOR_KEYSET
  • SQLSRV_CURSOR_CLIENT_BUFFERED

For more information, check: Cursor Types (SQLSRV Driver)

In conclusion, if you use your query like:

$query = sqlsrv_query($conn, $result, array(), array( "Scrollable" => 'static' ));

you will get result in:

$row_count = sqlsrv_num_rows($query);

More Related Contents:

  1. How to connect sql server with php using xampp?
  2. How to execute a stored procedure in php using sqlsrv and “?” style parameters
  3. Reference — What does this symbol mean in PHP?
  4. Asynchronous shell exec in PHP
  5. method=”post” enctype=”text/plain” are not compatible?
  6. Fixing broken UTF-8 encoding
  7. Checking if form has been submitted – PHP
  8. Send array with Ajax to PHP script
  9. How to locate the php.ini file (xampp)
  10. INSERT – Number of bind variables doesn’t match number of fields in prepared statement
  11. PHP Install SSH2 on Windows machine
  12. file_put_contents – failed to open stream: Permission denied
  13. Call to a member function execute() on boolean in [duplicate]
  14. Generate SEO friendly URLs (slugs) [closed]
  15. How to fix memory getting exhausted with PHPExcel?
  16. PHP Warning Permission denied (13) on session_start() [duplicate]
  17. Fatal error: Out of memory, but I do have plenty of memory (PHP)
  18. Does the order of class definition matter in PHP?
  19. Setting a connect timeout with PDO
  20. PDO LIMIT and OFFSET [duplicate]
  21. PHP, SimpleXML, decoding entities in CDATA
  22. How do I declare a two dimensional array?
  23. PHP Streaming MP3
  24. Remotely connecting to a MySQL database
  25. How to get VALUE from FORM without Submitting it?
  26. How can i send an Email using PHP at windows Azure?
  27. PDO bindParam into one statement?
  28. Installing ImageMagick extension with php/windows
  29. How to make mysqli connect function?
  30. preg_match() vs strpos() for match finding?

Leave a Comment