<html>
<head>
<title>Ingresos</title>
</head>
<body>
<script language="JavaScript">
function salir() {
document.location.href='index.php';
}
</script>
<?php
// compara que usuario y contraseña sean correctos
if ($usuario=="user" && $password=="clave") {
?>
<br><br>
<center><h4><font color=red>Ingreso</font></h4></center>
<table border=1 align=center>
<form name="formulario" METHOD="POST" ACTION="password.php">
<tr>
<td>
Día <input type=text name="dia" size="1" maxlength="2"> Mes
<input type=text name="mes" size="1" maxlength="2">
Año
<input type=text name="anno" size="4" maxlength="4">
<input type="submit" name="Accion" value="consultar">
</td></tr>
<tr>
<td>Primer menú:
<INPUT TYPE="text" NAME="almuerzo1">
</td></tr>
<tr>
<td>Segundo menú:
<INPUT TYPE="TEXT" NAME="almuerzo2">
</td></tr>
<input type="Submit" value="grabar" name="Ingreso">
<input type="Submit" value="salir" onClick="salir();">
</td></tr>
</table>
</form>
<?php
} else {
?>
<h4 align="center" style="color: red;">Error</h4>
<p align="justify" style="color: red;">Login o password
incorrecto.</p>
<?php
}
?>
<?
/****************************************************************************************/
/****************************************************************************************/
//consultar datos en la base de datos,la consulta se realiza a traves del codigo
$accion = $_POST['Accion'];
if($accion=="consultar")
{
$dia = $_POST['dia'];
$mes = $_POST['mes'];
$anno = $_POST['anno'];
$fecha = $dia."-".$mes."-".$anno;
$dsn = "servidor";
$username = "user";
$password = "password"
$databasename4="BDD"
$dbconn = odbc_connect($dsn, $username, $password);
$query = "SELECT f01datos.$databasename4.imenu01 as MENU1,
FROM f01datos.$databasename4
WHERE f01datos.$databasename4.idia=$dia and f01datos.$databasename4.imes=$mes
and f01datos.$databasename4.iano=$anno ";
$result1=odbc_Exec($dbconn,$query);
$result=odbc_Exec($dbconn,$query);
$row = odbc_fetch_array($result1);
echo "<br><br>";
echo "<center><h4><font color=red>Ingreso</font></h4></center>
<table border=1 align=center> ";
echo "<form name='formulario' METHOD='POST' ACTION='password.php'>";
echo "
<tr>
<td>
Día <input type=text name='dia' size=1 maxlength='2' value='$dia'> Mes
<input type=text name='mes' size=1 maxlength='2' value='$mes'>
Año
<input type=text name='anno' size=4 maxlength='4' value='$anno'>
<input type=submit name=Accion value='consultar'>
</td></tr>
<tr>
<td>Primer menú:
<INPUT TYPE='text' NAME='almuerzo1' value='$row[MENU1]'>
</td></tr>
<input type='Submit' value='grabar' name='Ingreso'>
<input type='Submit' value='salir'>
</td></tr>
</form>
</table> ";
odbc_Close($dbconn);
}
/**************************************************************************************/
/**************************************************************************************/
?>
</body>
</html>