"HRIS_TEST", "UID"=>"jb", "PWD"=>"rse@122877");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
;
if( $conn ) {
echo "Connection Failed.
";
}else{
echo "Connection Error.
";
die( print_r( sqlsrv_errors(), true));
}
$sql = "SELECT last_name FROM HRIS_TEST.dbo.employeelist";
$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 al obtener datos.";
else
echo "bien";
//echo $row_count;
while( $row = sqlsrv_fetch_array( $stmt) ) {
print json_encode($row);
}
sqlsrv_close($conn);
?>