6Fermer8
jacc90220Le 01/04/2011 à 01:12
Thanks, this is my php page:


<?php
include ("seguridad_04.php");
session_start();

$codigopers=$_SESSION["codigobuscado01"];

$con=mysql_connect("localhost","root","") or
die("No se puede conectar a la BD: " . mysql_error());

mysql_select_db("siper",$con);

$result01=mysql_query("select * from personal where codper='$codigopers'",$con);

while ($row01=mysql_fetch_array($result01))
{
$nombre=$row01["nombper"];
$ap_paterno=$row01["pateper"];
$ap_materno=$row01["mateper"];
$ci=$row01["cideper"];
$tin=$row01["tinaper"];
$f_ingreso=$row01["fingper"];
$f_nac=$row01["fnacper"];
$cod_dep=$row01["coddep"];
$cod_pro=$row01["codpro"];
$cod_loc=$row01["codloc"];
$cod_gra=$row01["codgra"];
$cod_esc=$row01["codesc"];
$cod_esp=$row01["codesp"];
$cod_cat=$row01["codcat"];
$cod_afp=$row01["codafp"];
$cod_gsa=$row01["codgsa"];
$cod_eci=$row01["codeci"];
}


$result11=mysql_query("select * from arresto where codper='$codigopers' order by fdocarr",$con);
$valida_filas_11=mysql_num_rows($result11);

$result12=mysql_query("select * from felicitaciones where codper='$codigopers' order by fdocban",$con);
$valida_filas_12=mysql_num_rows($result12);

<page backtop="40mm" backbottom="10mm" backleft="20mm" backright="20mm">
<page_header>
<table border="0">
<tr>
<td align="center" width="55"><img src="./fondos/escudoAB.JPG" width="50" height="50" /></td>
</tr>
<tr>
<td align="center" width="150"><font size="1">PROYECTO</font></td>
<td align="center" width="350"><strong>CURRICULUM VITAE</strong></td>
</tr>
<tr>
<td align="center"><font size="1">RR.HH.</font></td>
<td align="center" width="350"><strong>(Tipo 2)</strong></td>
</tr>
<tr>
<td align="center"><font size="1">La Paz - Bolivia</font></td>
</tr>
</table>
<hr style="border: 1px ridge #336699;" />
</page_header>
<page_footer>
<hr style="border: 1px ridge #336699;" />
<table align="center" frame="above" >
<tr>
<td style="text-align: left; width: 225px;">Divisi&oacute;n "H" - Archivo</td>
<td style="text-align: center; width: 200px;">[[page_cu]]-[[page_nb]]</td>
<td style="text-align: right; width: 225px;"><?php echo date('YmdHis'); ?></td>
</tr>
</table>
</page_footer>
<fieldset style="border: 1px ridge #336699; width: 650px;">
<table border="0">
<tr>
<td colspan="3" align="center"><strong>DATOS GENERALES</strong></td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td align="left"><strong>C&Oacute;DIGO:</strong></td>
<td colspan="2" lign="left"><?php echo $codigopers;?></td>
</tr>
<tr>
<td align="left"><strong>ESCALAF&Oacute;N:</strong></td>
<td align="left" colspan="2"><?php echo $escalafon;?></td>
</tr>
<tr>
<td align="left"><strong>GRADO:</strong></td>
<td colspan="2" align="left"><?php echo $grado;?></td>
</tr>
<tr>
<td align="left"><strong>ESPECILIDAD:</strong></td>
<td colspan="2" align="left"><?php echo $especialidad;?></td>
</tr>
<tr>
<td align="left"><strong>APELLIDO PATERNO:</strong></td>
<td colspan="2" align="left"><?php echo $ap_paterno;?></td>
</tr>
<tr>
<td align="left"><strong>APELLIDO MATERNO:</strong></td>
<td colspan="2" align="left"><?php echo $ap_materno;?></td>
</tr>
<tr>
<td align="left"><strong>NOMBRES:</strong></td>
<td colspan="2" align="left"><?php echo $nombre;?></td>
</tr>
<tr>
<td align="left"><strong>C&Eacute;DULA DE IDENTIDAD:</strong></td>
<td colspan="2" align="left"><?php echo $ci;?></td>
</tr>
<tr>
<td align="left"><strong>TIN:</strong></td>
<td colspan="2" align="left"><?php echo $tin;?></td>
</tr>
<tr>
<td align="left"><strong>FECHA DE INGRESO:</strong></td>
<td colspan="2" align="left"><?php echo $f_ingreso;?></td>
</tr>
<tr>
<td align="left"><strong>SEGURO SOCIAL:</strong></td>
<td colspan="2" align="left"><?php echo $seguro;?></td>
</tr>
<tr>
<td align="left"><strong>GRUPO SANGU&Iacute;NEO:</strong></td>
<td colspan="2" align="left"><?php echo $sangre;?></td>
</tr>
<tr>
<td align="left"><strong>ESTADO CIVIL:</strong></td>
<td colspan="2" align="left"><?php echo $ecivil;?></td>
</tr>
<tr>
<td align="left"><strong>FECHA DE NACIMIENTO:</strong></td>
<td colspan="2" align="left"><?php echo $f_nac;?></td>
</tr>
<tr>
<td align="left"><strong>LUGAR DE NACIMIENTO:</strong></td>
</tr>
<tr>
<td>&nbsp;</td>
<td align="left"><strong>Departamento: </strong></td>
<td align="left"><?php echo $departamento;?></td>
</tr>
<tr>
<td>&nbsp;</td>
<td align="left"><strong>Provincia: </strong></td>
<td align="left"><?php echo $provincia;?></td>
</tr>
<tr>
<td>&nbsp;</td>
<td align="left"><strong>Localidad: </strong></td>
<td align="left"><?php echo $localidad;?></td>
</tr>
</table>
</fieldset>
<hr style="border: 1px ridge #336699;" />
<br /><br />
<fieldset style="border: 1px ridge #336699; width: 650px;">

<table width= "600" border="0">
<tr>
<td >&nbsp;</td>
</tr>
<tr>
<td align="center"><strong>DEM&Eacute;RITOS</strong></td>
</tr>
</table>

<table>
<?php
if ($valida_filas_11!=0)
{
?>
<tr>
<td colspan="6">&nbsp;</td>
</tr>
<thead>
<tr>
<td align="center" style="width: 7px;"><strong>N°</strong></td>
<td align="center" style="width: 20px;"><strong>N°&nbsp;DOC</strong></td>
<td align="center" style="width: 30px;"><strong>FECHA</strong></td>
<td align="center" style="width: 80px;"><strong>CAUSA</strong></td>
<td align="center" style="width: 20px;text-wrap:hard-wrap align: center;"><strong>TIEMPO (Horas)</strong></td>
<td align="center" style="width: 70px;"><strong>AUTORIDAD</strong></td>
</tr>
</thead>

<?php
$contador=1;
while ($row11=mysql_fetch_array($result11))
{
?>
<tr>
<td align="center" style="width: 7px;"><?php echo $contador;?></td>
<td align="left" style="width: 20px;"><?php echo $row11["ndocarr"];?></td>
<td align="left" style="width: 30px;"><?php echo $row11["fdocarr"];?></td>
<td align="left" style="width:100;"><?php echo $row11["causarr"];?></td>
<td align="center" style="width: 20px;"><?php echo $row11["tiemarr"];?></td>
<td align="left" style="width: 50px;"><?php echo $row11["impoarr"];?></td>
</tr>
<?php
$contador++;
}
?>
<tr>
<td colspan="6"><strong>Nota: </strong>Los documentos que registran en el campo TIEMPO el valor 0, son memorandos de Llamada de Atenci&oacute;n</td>
</tr>
<?php
}
else
{
?>
<tr>
<td><h1>NO REGISTRA</h1></td>
</tr>
<?php
}

?>
</table>
</fieldset>
<hr style="border: 1px ridge #336699;" />
<br /><br />
<fieldset style="border: 1px ridge #336699; width: 650px;">

<table frame="above">
<tr>
<td colspan="2" align="center"><strong>FELICITACIONES</strong></td>
</tr>
<?php
if ($valida_filas_12!=0)
{
?>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td align="center"><strong>N°</strong></td>
<td align="center"><strong>N°&nbsp;DOC</strong></td>
<td align="center" width="100"><strong>FECHA</strong></td>
<td align="center"><strong>GLOSARIO</strong></td>
<td align="center"><strong>IMPONE</strong></td>
<td align="center"><strong>OBS</strong></td>
</tr>

<?php
$contador=1;
while ($row12=mysql_fetch_array($result12))
{
?>
<tr>
<td><?php echo $contador;?></td>
<td><?php echo $row12["ndocban"];?></td>
<td><?php echo $row12["fdocban"];?></td>
<td><?php echo $row12["glosban"];?></td>
<td align="center"><?php echo $row12["impoban"];?></td>
<td><?php echo $row12["obseban"];?></td>
</tr>
<?php
$contador++;
}
}
else
{
?>
<tr>
<td><h1>NO REGISTRA</h1></td>
</tr>
<?php
}
?>
</table>
</fieldset>

<hr style="border: 1px ridge #336699;" />

</page>