asi:
Código PHP:
<?php
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=NotificacionCasosSospechososXHosp.xls");
header("Pragma: no-cache");
?>
<?php require_once('pruebasesion.php'); ?>
<?php require_once('../../../Connections/brotediarreas.php'); ?>
<?php
$colname_Recordset1 = "1";
if (isset($HTTP_SESSION_VARS['usuario'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['usuario'] : addslashes($HTTP_SESSION_VARS['usuario']);
}
mysql_select_db($database_brotediarreas, $brotediarreas);
$query_Recordset1 = sprintf("SELECT * FROM usuarios WHERE nomusuario = '%s'", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $brotediarreas) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
$colname_Recordset2 = "1";
if (isset($HTTP_SESSION_VARS['usuario'])) {
$colname_Recordset2 = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['usuario'] : addslashes($HTTP_SESSION_VARS['usuario']);
}
mysql_select_db($database_brotediarreas, $brotediarreas);
$query_Recordset2 = sprintf("SELECT * FROM hospnot WHERE usuario = '%s'", $colname_Recordset2);
$Recordset2 = mysql_query($query_Recordset2, $brotediarreas) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
?>
<!-- Visalización Base de Datos Notificación de Rotavirus Hospital-->
<html>
<head>
<title>Base de Datos Notificación de casos Sospechosos Rotavirus</title>
</head>
<body>
<br>
<br>
<H1><font color="#333399" size="3" face="Arial Narrow"> Base de datos Notificación
de Casos Sospechosos de Rotavirus del <?php echo $row_Recordset1['establecimiento']; ?>.</H1>
<font face="Arial Narrow">
<TABLE width="914" BORDER=1 CELLPADDING=1 CELLSPACING=1>
<TR bgcolor="#DFDFDF">
<td> Nº
MINSAL </TD>
<td> Fecha
Digitación </TD>
<td>Nombres </TD>
<td> Apellidos </TD>
<td>Fecha Nacimiento</TD>
<td>Edad</TD>
<td>Sexo</TD>
<td>Rut </TD>
<td>dv</TD>
<td>Dirección</TD>
<td>Cod. Comuna</TD>
<td>Consultorio</TD>
<td>Hospital</TD>
<td> Fecha Ingreso
Hospital</TD>
<td>Nº
Ficha</TD>
<td>Fecha Inicio
Diarrea</TD>
<td>Presencia
de Sangre</TD>
<td>Fecha Toma
Muestra </TD>
<td>Técnica
Diag. Lab.</TD>
<td>Result. Lab.</TD>
<td>Unidad /
Laboratorio</TD>
<td>Responsable</TD>
<td>Fecha Envio
Muestra </TD>
<td>Nº Registro
ISP </TD>
<td>Resultado
ISP</TD>
<td>Caso Cerrado</TD>
</TR>
<?php do { ?>
<TR>
<TD><?php echo $row_Recordset2['ncor']; ?></TD>
<TD><?php echo $row_Recordset2['fechadig']; ?></TD>
<TD><?php echo $row_Recordset2['nompac']; ?></TD>
<TD><?php echo $row_Recordset2['apellpac']; ?></TD>
<TD><?php echo $row_Recordset2['fnac']; ?></TD>
<TD><?php echo $row_Recordset2['edad']; ?></TD>
<TD><?php echo $row_Recordset2['sexo']; ?></TD>
<TD><?php echo $row_Recordset2['rut']; ?></TD>
<TD><?php echo $row_Recordset2['dv']; ?></TD>
<TD><?php echo $row_Recordset2['direc']; ?></TD>
<TD><?php echo $row_Recordset2['comuna']; ?></TD>
<TD><?php echo $row_Recordset2['consultorio']; ?></TD>
<TD><?php echo $row_Recordset2['nomhosp']; ?></TD>
<TD><?php echo $row_Recordset2['finghosp']; ?></TD>
<TD><?php echo $row_Recordset2['nficha']; ?></TD>
<TD><?php echo $row_Recordset2['finidiarr']; ?></TD>
<TD><?php echo $row_Recordset2['psangre']; ?></TD>
<TD><?php echo $row_Recordset2['ftomamuestra']; ?></TD>
<TD><?php echo $row_Recordset2['tecdiaglab']; ?></TD>
<TD><?php echo $row_Recordset2['resultado']; ?></TD>
<TD><?php echo $row_Recordset2['unilab']; ?></TD>
<TD><?php echo $row_Recordset2['respnom']; ?></TD>
<TD><?php echo $row_Recordset2['respfenvmues']; ?></TD>
<TD><?php echo $row_Recordset2['regisp']; ?></TD>
<TD><?php echo $row_Recordset2['ispresultado']; ?></TD>
<TD><?php echo $row_Recordset2['cerrado']; ?></TD>
</TR>
<?php } while ($row_Recordset2 = mysql_fetch_assoc($Recordset2)); ?>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>