lepuse pobo php pero igual
Código PHP:
<?
session_start();
include("include/bd.php");
include("include/functions.php");
bd_connect();
if(isset($_GET['paterno']) and $_GET['paterno'] != '') {
$sql_more = " AND paterno LIKE '%" . $_GET['paterno'] . "%' ";
}
if(isset($_GET['materno']) and $_GET['materno'] != '') {
$sql_more .= " AND materno LIKE '%" . $_GET['materno'] . "%' ";
}
if(isset($_GET['nombre']) and $_GET['nombre'] != '') {
$sql_more .= " AND nombre LIKE '%" . $_GET['nombre'] . "%' ";
}
$personal= "SELECT id_per, paterno, materno, nombre, id_ope, direccion_ope
FROM personal WHERE tipo_user = '5'
" . $sql_more . "
ORDER BY id_per";
//echo $personal;
$personal_query = db_query($personal);
?>
<html>
<head>
<title>REGISTRO</title>
</head>
<body>
<div style="height:280;width:100%;overflow:auto">
<table border="0" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<table border="0" width="100%" cellpadding="0" cellspacing="0" align="center">
<tr>
<td class="clsTituloTabla" align="center" width="30">Nro.</td>
<td class="clsTituloTabla">Código</td>
<td align="center" class="clsTituloTabla">Nombres</td>
<td class="clsTituloTabla">id_ope</td>
<td class="clsTituloTabla">Oficina de Enlace</td>
<td class="clsTituloTabla"> </td>
</tr>
<?
$i = 1;
while($personal = db_fetch_array($personal_query)) {
?>
<tr onMouseOver="this.className='dataTableRowSelected'" onmouseout="this.className='dataTableRow'">
<td align="center" height="22"><?echo $i?></td>
<td><?echo $personal['id_per']?></td>
<td align="center"><?echo $personal['paterno'] . ' ' . $personal['materno'] . ' ' . $personal['nombre']?></td>
<td><?echo $personal['id_ope']?></td>
<td><?echo $personal['direccion_ope']?></td>
</tr>
<tr>
<td colspan="7" height="1" bgcolor="#000000"></td>
</tr>
<?
$i++;
}
?>
</table>
<?
$Fecha= date('d-m-Y',time() - 21600 ); //le sumé una hora
$Hora= date('H:i:s',time() + 18000 ); //le sumé una hora
echo "Fecha: ".$Fecha;
echo "<br>";
echo "Su hora de ingreso ha sido: ".$Hora;
echo "<br>";
?>
<?
if ($Hora >= date ('-20:10:00',time()+18000)){
echo "UD. LLEGO TARDE";
}
else{
echo "UD. LLEGO TEMPRANO";
}
?>
</td>
</tr>
</table>
</div>
</body>
</html>