Skip to content

Instantly share code, notes, and snippets.

@carlosalexandresmo
Created August 14, 2020 01:53
Show Gist options
  • Save carlosalexandresmo/d74694712cbc0b66588f8239c2261513 to your computer and use it in GitHub Desktop.
Save carlosalexandresmo/d74694712cbc0b66588f8239c2261513 to your computer and use it in GitHub Desktop.
include('config.php');
ob_start('ob_gzhandler');
$query = "SELECT ...";
$params = array();
$options =array("Scrollable" => SQLSRV_CURSOR_KEYSET);
$consulta = sqlsrv_query($conn, $query, $params, $options);
$numero_de_linhas = sqlsrv_num_rows($consulta);
$obj = new stdClass();
$dados = array();
if ($numero_de_linhas!= 0) {
$dados = sqlsrv_fetch_object($consulta);
//echo json_encode($dados);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment