Tema: Auxilio::::
Ver Mensaje Individual
  #17 (permalink)  
Antiguo 24/09/2010, 13:54
dianays
 
Fecha de Ingreso: agosto-2010
Mensajes: 147
Antigüedad: 13 años, 8 meses
Puntos: 1
Respuesta: Auxilio::::
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Documento sin t&iacute;tulo</title>
</head>

<body>
<form id="form1" name="form1" method="post" action="fecha3.php">
<table width="100%">
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td colspan="2">Selecciona el Nombre: </td>
<td colspan="2"><label>
<?php
$CONEXION = mysql_connect("localhost","root","");
if (!$CONEXION) {
die("p class='Estilo1' align='center'>LO SIENTO, PERO NO HA PODIDO CONECTARSE A MYSQL: </p>" . mysql_error());
}
else{
mysql_select_db("bd_control", $CONEXION);
$ARTICULOS=mysql_query("SELECT id_nom, nombre FROM usuarios ");
$ERROR = mysql_error($CONEXION);
if(empty($ERROR)){
echo "<select name=usuario>";
echo "<option selected='' value=''> [ Seleccione ] </option>";
while ($ARTICULO=mysql_fetch_array($ARTICULOS)){
echo "<option value=".$ARTICULO["id_nom"].">".$ARTICULO["nombre"]."</option>";
}
echo "</select>";
}
else{
$ERROR_CONSULTA="NO SE PUEDEN MOSTRAR LOS DATOS DEBIDO AL SIGUIENTE ERROR: ";
}
}
?>
</label></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>A&ntilde;o:</td>
<td><label>
<select name="mil" id="mil">
<option selected='' value=''> [ Seleccione ] </option>
<option value="2010"> 2010 </option>
<option value="2011"> 2011 </option>
<option value="2012"> 2012 </option>
<option value="2013"> 2013 </option>
</select>
</label></td>
<td>Mes:</td>
<td><label>
<select name="mes" id="mes">
<option selected='' value=''> [ Seleccione ] </option>
<option value="01"> 01 </option>
<option value="02"> 02 </option>
<option value="03"> 03 </option>
<option value="04"> 04 </option>
<option value="05"> 05 </option>
<option value="06"> 06 </option>
<option value="07"> 07 </option>
<option value="08"> 08 </option>
<option value="09"> 09 </option>
<option value="10"> 10 </option>
<option value="11"> 11 </option>
<option value="12"> 12 </option>
</select>
</label></td>
<td>D&iacute;a:</td>
<td><label>
<select name="dia" id="dia">
<option selected='' value=''> [ Seleccione ] </option>
<option value="01"> 01 </option>
<option value="02"> 02 </option>
<option value="03"> 03 </option>
<option value="04"> 04 </option>
<option value="05"> 05 </option>
<option value="06"> 06 </option>
<option value="07"> 07 </option>
<option value="08"> 08 </option>
<option value="09"> 09 </option>
<option value="10"> 10 </option>
<option value="11"> 11 </option>
<option value="12"> 12 </option>
<option value="13"> 13 </option>
<option value="14"> 14 </option>
<option value="15"> 15 </option>
<option value="16"> 16 </option>
<option value="17"> 17 </option>
<option value="18"> 18 </option>
<option value="19"> 19 </option>
<option value="20"> 20 </option>
<option value="21"> 21 </option>
<option value="22"> 22 </option>
<option value="23"> 23 </option>
<option value="24"> 24 </option>
<option value="25"> 25 </option>
<option value="26"> 26 </option>
<option value="27"> 27 </option>
<option value="28"> 28 </option>
<option value="29"> 29 </option>
<option value="30"> 30 </option>
<option value="31"> 31 </option>
</select>
</label></td>
<td>&nbsp;</td>
<td>A&ntilde;o:</td>
<td><select name="mil2" id="mil2">
<option selected='selected' value=''> [ Seleccione ] </option>
<option value="2010"> 2010 </option>
<option value="2011"> 2011 </option>
<option value="2012"> 2012 </option>
<option value="2013"> 2013 </option>
</select></td>
<td>Mes:</td>
<td><select name="mes2" id="mes2">
<option selected='selected' value=''> [ Seleccione ] </option>
<option value="01"> 01 </option>
<option value="02"> 02 </option>
<option value="03"> 03 </option>
<option value="04"> 04 </option>
<option value="05"> 05 </option>
<option value="06"> 06 </option>
<option value="07"> 07 </option>
<option value="08"> 08 </option>
<option value="09"> 09 </option>
<option value="10"> 10 </option>
<option value="11"> 11 </option>
<option value="12"> 12 </option>
</select></td>
<td>D&iacute;a:</td>
<td><select name="dia2" id="dia2">
<option selected='selected' value=''> [ Seleccione ] </option>
<option value="01"> 01 </option>
<option value="02"> 02 </option>
<option value="03"> 03 </option>
<option value="04"> 04 </option>
<option value="05"> 05 </option>
<option value="06"> 06 </option>
<option value="07"> 07 </option>
<option value="08"> 08 </option>
<option value="09"> 09 </option>
<option value="10"> 10 </option>
<option value="11"> 11 </option>
<option value="12"> 12 </option>
<option value="13"> 13 </option>
<option value="14"> 14 </option>
<option value="15"> 15 </option>
<option value="16"> 16 </option>
<option value="17"> 17 </option>
<option value="18"> 18 </option>
<option value="19"> 19 </option>
<option value="20"> 20 </option>
<option value="21"> 21 </option>
<option value="22"> 22 </option>
<option value="23"> 23 </option>
<option value="24"> 24 </option>
<option value="25"> 25 </option>
<option value="26"> 26 </option>
<option value="27"> 27 </option>
<option value="28"> 28 </option>
<option value="29"> 29 </option>
<option value="30"> 30 </option>
<option value="31"> 31 </option>
</select></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
<p>
<label>
<div align="center">
<input name="ACEPTAR" type="submit" id="ACEPTAR" value="ACEPTAR" />
</label>
<label></label>
</form>

<?php
if(isset($_POST["ACEPTAR"])){
$usuario=$_POST["usuario"];
$mil=$_POST["mil"];
$mes=$_POST["mes"];
$dia=$_POST["dia"];
$fecha=$mil."-".$mes."-".$dia;
$ART_SEL=mysql_query("SELECT folio, fecha, hora, unidad, nombre FROM reporte, unidades, usuarios WHERE reporte.id_unidad = unidades.id_unidad AND reporte.id_nom = usuarios.id_nom AND reporte.fecha=str_to_date($fecha, '%Y-%m-%d')") or die ("error:".mysql_error());
?>
<? if($num>0){ ?>
<table width='800' border='1' align='center'>
<tr>
<th width='90' scope='col'>FOLIO</th>
<th width='66' scope='col'>FECHA</th>
<th width='65' scope='col'>HORA</th>
<th width='69' scope='col'>UNIDAD</th>
<th width='66' scope='col'>NOMBRE</th>
</tr>
<? do{?>
<tr>
<td><? echo $fila['folio'];?>" </td>
<td><? echo $fila['fecha'];?>" </td> <td><? echo $fila['hora'];?>"
</td> <td><? echo $fila['unidad'];?>"
</td> <td><? echo $fila['nombre'];?>"
</td>
</tr>
</table>
<? } while ($fila=mysql_fetch_assoc($ART_SEL)); } ?>

</body>
</html>