<?php
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>ABM Alergias</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script type="text/javascript" src="../js/script3.js"> </script>
<script type="text/javascript" src="../js/ajax_ficha_sintoma.js"></script>
<script type="text/javascript" src="../js/ajax_ficha.js"></script>
</head>
<body>
<form enctype="multipart/form-data" name="form1" method="post" action="insert_temporal.php">
<table width="80%" border="0" align="center" cellspacing='1' cellpadding='0'>
<tr>
<td bgcolor='#CCCCCC' align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="000"><b>Alergias </b></font></td>
<td bgcolor='#CCCCCC' align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="000"><b>Fotografia</b></font></td>
<td bgcolor='#CCCCCC' align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="000"><b>Sintomas</b></font></td>
</tr>
<tr>
<td width="10%" bgcolor="#F6CECE">
<?php
include("../conexion.php");
// Consultar la base de datos
$consulta_mysql="select id_enfermedad,nombre_enfermedad from ENFERMEDAD order by nombre_enfermedad asc";
$resultado_consulta_mysql=mysql_query($consulta_mysql);
echo "<select name='id_enfermedad' id='id_enfermedad' onChange='cargaContenido(this.id)'>";
echo "<option value=''> - - - - - - - - - - </option>";
if ($fila['id_enfermedad']==$_SESSION['id_enfermedad']) {$tipo="SELECTED";}else{$tipo="";}
echo "<option value='".$fila['id_enfermedad']."' ".$tipo.">".$fila['nombre_enfermedad']."</option>";
}
echo "</select>";
?>
</td>
<td width="20%" bgcolor="#F6CECE"><div id="resultado"><fieldset class="fielset2"><legend>Imagen</legend>
<img align="middle" src="http://www.forosdelweb.com/f18/imagenes/nodisponible.jpeg" width="191" height="168" id="img_prev" />
</fieldset></div></td>
<td width="10%" bgcolor="#F6CECE">
<?php
// Consultar la base de datos
$consulta_mysql="select id_sintoma,nombre_sintoma from SINTOMAS order by nombre_sintoma asc";
$resultado_consulta_mysql=mysql_query($consulta_mysql);
echo "<select name='id_sintoma' id='id_sintoma' onChange='cargaContenido_sintoma(this.id)'>
<option value='0'> - - - - - - - - - - </option>";
if ($fila['id_sintoma']==$_SESSION['id_sintoma']) {$tipo="SELECTED";}else{$tipo="";}
echo "<option value='".$fila['id_sintoma']."' ".$tipo.">".$fila['nombre_sintoma']."</option>";
}
echo "</select>";
?>
</td>
</tr>
<tr >
<td align="center" bgcolor="#F6CECE">
</td>
</tr>
<tr>
<td bgcolor='#CCCCCC' align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="000"><b></b></font></td>
<td bgcolor='#CCCCCC' align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="000"><b>Peso Sintoma: <input type="text" name="peso" value="" id="peso" size="15" maxlength=""/></b></font></td>
<td bgcolor='#CCCCCC' align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="000"><b></b></font></td>
</tr>
</table>
<table width="70%" border="0" align="center">
<tr>
<td align="right"><input align="right" name="Enviar" type="submit" value="Agregar" /></td>
</tr>
</table>
<table width="775" border="0" align="center" cellpadding="0" cellspacing="0"
bgcolor="#FFFFFF">
<tr>
<td></td>
</tr>
<tr>
<td>
<table width="100%" border="0" align="center" cellspacing='1' cellpadding='0'>
<tr>
<td bgcolor='#CCCCCC'><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="000"><b><input name="topcheckbox" type="checkbox" class="check" id="topcheckbox" onClick="selectall();" value="ON">
All </b></font></td>
<td colspan="3" align="center" bgcolor='#CCCCCC'><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="blue"><b>Tabla de Patologia </b></font></td>
</tr>
<tr>
<td bgcolor='#CCCCCC'><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFCC"><b><a href="javascript:goDel()">Eliminar</a></b></font></td>
<td bgcolor='#CCCCCC' align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="000"><b>Nombre Alergia </b></font></td>
<td bgcolor='#CCCCCC' align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="000"><b>Nombre Sintoma</b></font></td>
<td bgcolor='#CCCCCC' align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="000"><b>Peso</b></font></td>
</tr>
<?php
// maximo por pagina
$limit = 8;
// pagina pedida
$pag = (int) $_GET["pag"];
if ($pag < 1)
{
$pag = 1;
}
$offset = ($pag-1) * $limit;
$sql="select SQL_CALC_FOUND_ROWS id_sintoma,nombre_sintoma,peso,nombre_alergia from temporal LIMIT $offset, $limit";
$sqlTotal = "SELECT FOUND_ROWS() as total";
// Total de registros sin limit
$total = $rowTotal["total"];
?>
<tr>
<td width="10%" bgcolor="#CC6666" onMouseOver="this.style.backgroundColor='#FF9900'; this.style.cursor='hand';" onMouseOut="this.style.backgroundColor='#CC6666'"> <input name="<?php echo $row['id_sintoma']; ?>" type="checkbox"
class="check"></td>
<td width="30%" bgcolor="#CC6666" align="center"><textarea readonly cols="25" rows="1" style="resize: none;"><?php echo $row['nombre_sintoma']; ?></textarea></td>
<td width="45%" bgcolor="#CC6666" align="center"><textarea readonly cols="45" rows="1" style="resize: none;"><?php echo $row['nombre_alergia']; ?></textarea></td>
<td width="45%" bgcolor="#CC6666" align="center"><textarea readonly cols="10" rows="1" style="resize: none;"><?php echo $row['peso']; ?></textarea></td>
</tr>
<?php } ?>
<tr>
<td bgcolor='#CCCCCC'><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFCC"><b><a href="javascript:goDel()">Eliminar</a></b></font></td>
<td bgcolor='#CCCCCC' align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="000"><b>Nombre Alergia </b></font></td>
<td bgcolor='#CCCCCC' align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="000"><b>Nombre Sintoma</b></font></td>
<td bgcolor='#CCCCCC' align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="000"><b>Peso</b></font></td>
</tr>
<tr>
<td colspan="4" ><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFCC"><b>
<?php
$totalPag = ceil($total/$limit); for( $i=1; $i<=$totalPag ; $i++)
{
$links[] = "<a href=\"?pag=$i\">$i</a>";
}
?>
</b></font></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>