The sqlsrv_fetch_array() retrieves one row at a time as you discovered, it isbehaving exactly as documented. The SQLSRV driver does not have a method/api to fetch all rows in a single call. You should be able to do this use the PDO_SQLSRV driver using thePDOStatement::fetchAll()m...
If a row of data is retrieved, an array is returned. If there are no more rows to retrieve, null is returned. If an error occurs, false is returned. Based on the value of the $fetchType parameter, the returned array can be a numerically indexed array, an associative array, or both....
The sqlsrv_fetch_array() retrieves one row at a time as you discovered, it isbehaving exactly as documented. The SQLSRV driver does not have a method/api to fetch all rows in a single call. You should be able to do this use the PDO_SQLSRV driver using thePDOStatement::fetchAll()m...